1.3.4.20250417 BETA

This beta version introduces significant changes under the hood. Specifically, we add more detailed information about supported data types that the driver shares with client applications. Instead of using general types such as VARCHAR or INTEGER, we now report the actual ClickHouse types and their properties. The change itself does not significantly affect visible behavior, and as far as we are aware, it only fixes one issue: Int64 columns are loaded as binary columns in PowerBI. However, it paves the way for future improvements that were not possible without this change.

Knowing that we cannot foresee how other applications rely on the way the driver reports the supported types, we are first releasing a beta version to collect feedback.

Technical details:

• The SQLGetTypeInfo function now returns native ClickHouse types, as advertised in the documentation. Specifically, instead of using TINYINT, SMALLINT, INT, REAL, TEXT, TIMESTAMP, etc., it now returns Int8, Int16, Int32, Float, String, DateTime64.
• Many columns of the SQLGetTypeInfo function have been populated with relevant data, where previously they contained NULLs or simple placeholders.
• Similar to SQLGetTypeInfo, SQLColumns now also returns native type names and is populated with data that was previously missing.
• DateTime64 now comes first when requesting type information for SQL_TYPE_TIMESTAMP. This allows using fractions of a second in the WHERE clause and is also compatible with DateTime as long as the fraction of a second is set to zero.