Hi Kathy,
I have to disagree with you here.
When a function does not work correctly, it is a bug, not a lack of feature. The only function of the SQL Builder is to create a valid Query. If it can’t do that, there is a bug.
Postgres is one of the databases that are officially supported by Ignition. If there is a requirement for the database columns names to be all lowercase or enclosed in double-quotes, the Builder needs to provide that.
The Database Query Manager does this. When I select a single column, it adds double-quotes to the column name.
