Common pitfall. I fell in it too back in the day.
The SQL specification actually calls for case-insensitivity, and most DBMSs will automatically lowercase or UPPERCASE your names for you unless you quote them.
I’m actually migrating a database from SQL Server, which maintains the original CaSe, to Postgres, which follows the specification and does not, resulting in the less readable camelcase
names, so I am converting the camelCase
tables to snake_case
. I posted about it recently at https://lucee.daemonite.io/t/rebind-jquery-tablesorter/2711/14?u=21solutions