Switch to Custom SQL query won't replicate Simple query

[Notum]

Wappler: 6.0.3
DB: Postgre SQL

I have an PostgreSQL with case sensitive Tables and Columns.
When I’m create SQL Query in design view - Wappler correctly represents table names and wraps such names with “”.

But when I switch to Custom SQL Query - all “” are gone and as a results - SQL query shows errors.

[George]

The escaping with quotes is only needed if you have invalid characters in the column or table names.

I don’t see any irregularities with your names so it should work also fine without quotes.

What sql errors are you getting?

[Notum]

@George as I mentioned: I have tables and columns in my PostgreSQL created as CREATE TABLE “bookingLogs” meaning they are case sensitive.

Error I get a general one - no relationships between tables but once I add " to tables and columns like bookingLogs - all works.

[Notum]

[Teodor]

Fixed in Wappler 6.0.4