Lack of quotation usage

[SwordOfSouls]

None of the DAO generated queries utilize SQL quotation. This becomes problematic in various situations, but, is most visible when table names utilize built in symbols.

Example -
The statement select user.legalName, user.internalEmail, user.id from user LIMIT 1 OFFSET 0
results in org.jdbi.v3.core.statement.UnableToExecuteStatementException: org.postgresql.util.PSQLException: ERROR: syntax error at or near "."

This would be fixed by simply adding quotations.
SELECT "user"."legal_name", "user"."internal_email", "user"."id" FROM "user" LIMIT 1 OFFSET 0

[mvysny]

Hi, which database is it, Postgres?

[SwordOfSouls]

Appreciate the response. Postgres is used in this example.

[mvysny]

Thanks for confirming. vok-orm doesn't support quoted selects at the moment and this needs to be added as a feature to jdbi-orm. Could you please open a feature request at https://gitlab.com/mvysny/jdbi-orm and add an example code (SQL DDL + a Table class + a sample code) which works with quotations but fails without those?