Developing ibm informix driver - timezone problems

Hi I’m busy writing the clj’s for building an informix.metabase.jar.
so far I succeeded in connecting the informix database to metabase, as well as being able to do native queries and some questions simple questions with filters.
The major problem is the integration of database-fields with the data type of dates and datetimes.
As informix does not support time zone, this is very tricky.

As I understand, metabase uses the jdbc-driver (in my case ifxjdbc.jar) to fetch a Connection for a database with session time zone set to timezone-id (if supported by the driver.) The default implementation:

  1. Calls util fn datasource to get a c3p0 connection pool DataSource
  2. Calls .getConnection() the normal way
  3. Executes set-timezone-sql if implemented by the driver.

So my questions are:
1 - Does the util fn ‘datasource’ call a ‘set-timezone’?
2 - How can I make Metabase use the LocalDateTime as default and not the ZonedDateTime?
3 - Is it even possible for Metabase to connect to a Database that does not support “timestamps with timezone”?

Any help appreciated.

{
“browser-info”: {
“language”: “de”,
“platform”: “Linux x86_64”,
“userAgent”: “Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:76.0) Gecko/20100101 Firefox/76.0”,
“vendor”: “”
},
“system-info”: {
“file.encoding”: “UTF-8”,
“java.runtime.name”: “OpenJDK Runtime Environment”,
“java.runtime.version”: “1.8.0_262-b10”,
“java.vendor”: “Oracle Corporation”,
“java.vendor.url”: “http://java.oracle.com/”,
“java.version”: “1.8.0_262”,
“java.vm.name”: “OpenJDK 64-Bit Server VM”,
“java.vm.version”: “25.262-b10”,
“os.name”: “Linux”,
“os.version”: “3.10.0-1062.18.1.el7.x86_64”,
“user.language”: “de”,
“user.timezone”: “Europe/Berlin”
},
“metabase-info”: {
“databases”: [
“postgres”,
“ibminformix”,
“oracle”,
“h2”
],
“hosting-env”: “unknown”,