Tip: Confirm that this dialect is being used in SQLAlchemy 1.3.17+

[gordthompson]

SQLAlchemy 1.3.17 added the hook to load this dialect if it is installed, otherwise fall back to the internal dialect. An easy way to confirm which dialect is actually being used is to execute

print(engine.dialect.get_table_names(engine.connect()))

This dialect will correctly return the table names, trimmed and case-normalized:

['table1', ...

while the internal dialect will return the raw table names from rdb$relations:

['TABLE1                         ', ...

[fdcastel]

Can we close this issue?