Autoquote identifiers using IBPhoenix ODBC

Connection string

This IBPhoenix Open Source ODBC Driver (aka Firebird ODBC driver) connection string can be used for connections to Firebird.

The driver will quote (") your table names in SQL statements automatically.

DRIVER=Firebird/InterBase(r) driver;UID=SYSDBA;PWD=masterkey;
DBNAME
=C:\database\myData.fdb;
AUTOQUOTED=YES;

'SELECT A.Field FROM Table A' will be transformed into 'SELECT "A.Field" FROM "Table" A'

Be aware that upper case SQL keywords must be used, ie SELECT and FROM etc, not Select and From, else transformation will fail.