Dear Metabase Community,
I am developing a custom database driver for IBM Informix, and it seems that this database does throw Syntax Errors when using " around table names.
e.g. SELECT * FROM "mytable"; throws a Syntax Error Exception, but
SELECT * FROM mytable works fine.
How can I configure my driver - which is using JDBC internally - to not add these quotes around tablenames automatically?
I found the quote-name function in metabase.driver.sql.util but do not know how to use it?
For reference, my custom driver code is at: metabase-informix-driver/ibminformix.clj at main · felixeichler/metabase-informix-driver · GitHub
Thank you very much for your help/advise! 
Felix
hello! Have you had any progress with this development? or have you abandoned it? I am very interested in finding a way to have a driver for ibm informix
No I did not find a way to get the quote mode fixed.
As a workaround I'm manually creating the queries in the SQL editor. This works, even including variables so I can build functioning reports/dashboard (though SQL knowledge is required).
1 Like
What version of metabase are you working with and could you share the driver to connect to informix? And also if you can, give me an example of the workaround you have done.
I'm using the repo above and Metabase v0.48 and it works with Informix v12.10. It does work for any custom SQL query that you write in metabase, no special workaround needed. It's just that the UI query builder does not work, I believe due to the way table/column names are quoted, but that doesn't apply when writing SQL directly. Hope this helps...