Cfquery table name appears to be case sensitive (how to fix?)

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