how to handle case sensitivity

[Darshan Patel]

SELECT a.Pbc AS PBC

O/P

SELECT a.pbc AS pbc

i am using linux mysql combination so that gives error

[Nathan Williams (nwilliams)]

Unquoted identifiers are case-insensitive in standard SQL. Out of all the quirky behavior MySQL has, their case handling is about the worst.

The parser itself won't be able to give you all same behavior, as it is just dealing with the query, but there is an IdentifierCase option if you want to preserve instead of normalize.

See the example here:
https://gist.github.com/nathanlws/5797500