Issues with complex queries in Query Builder and protected identifiers

There are so many edge cases such as this where CI's query builder will bork that the db library would be absolutely huge to make it work for all cases, and then it would have to be replicated for each DB driver so everything works the same across platforms. Then what do you do with Platform specific functions that don't have a similar counterpart in other platforms? It would be a monumental task.