time_zone errors

[esadek]

When trying to connect to ClickHouse with MySQL driver version 0.2.0, I am getting the following error:

adbc_driver_manager.OperationalError: IO: [MySQL] failed to ping database: Error 115 (HY000): Code: 115. DB::Exception: Setting time_zone is neither a builtin setting nor started with the prefix 'SQL_' registered for user-defined settings. (UNKNOWN_SETTING) (version 25.12.3.21 (official build))

When trying to connect to Databend with MySQL driver version 0.2.0, I am getting the following error:

adbc_driver_manager.InternalError: INTERNAL: [MySQL] failed to ping database: Error 1105 (HY000): UnknownVariable. Code: 2801, Text = Unknown variable: "time_zone".

I am, however, able to connect to both ClickHouse and Databend successfully with MySQL driver version 0.1.0.

[lidavidm]

CC @Mandukhai-Alimaa (not a huge priority)

I think adding a connection/URI option to specify the vendor might be useful; if the vendor is not MySQL then we don't set the timezone (and maybe in the future we can do other things). We can't autodetect this since this is set before we connect. (Or can we connect without the option and set it during runtime? If so then autodetecting would be preferable.)

It appears Databend has a Docker image: https://hub.docker.com/r/datafuselabs/databend

Maybe we should integration test a few systems? (We can work that out in a separate issue, also see adbc-drivers/validation#63, and the workflows themselves could/should account for testing multiple systems)