remove quotemarks: PostgreSQL case sensitivity (& msSQL compatability)

[Justus-Maier]

The legacy database im using exists in postgres and mssql variants, the postgre db has everything lowercased, while the tables in the mssql db have also some capital letters.

• MSSQL seems not to care about the casing of table and column names at all
• PostgreSQL cares about casing, if quotemarks are used!
• PostgreSQL uses 'public' schema, msSQL doesn't use one

Obviously I want to select one dialect and have it just work.
I'd like to keep using camel case, but since everything in the postgre db is lowercase, I have to use those names (moduleid, modulename), because querying without quotemarks is not possible?

Please help me to solve this properly, creating an abstraction over those sql dialects!