enhancement
Static SQL expressions should preferably be routed through the DBHelper in order to accommodate the specific characteristics of different database implementations.
PostgreSQL, for example, converts table and column names to lowercase. For example,
#!sql SELECT * FROM TEST_TABLE
is equivalent to
#!sql SELECT * FROM test_table
This means the statement will fail if the table ` test_table ` does not exist.
Some expressions are routed through the DBHelper, while others are not. If these interact with the same table or column, this can lead to problems, for example, in PostgreSQL.
For the sake of completeness and consistency, all SQL expressions should be routed through the DBHelper to avoid such errors.
Test
No test.