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!
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.
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!