Support for ODBC Table Function in ClickHouse

Why it matters

This feature allows users to perform write operations using the ODBC Table function, which previously supported only read operations. It expands ClickHouse's integration capabilities by enabling seamless data writing to external ODBC-compliant data sources, improving interoperability and workflow efficiency.

How to use it

Users can enable writes by using the ODBC Table function in their queries with standard INSERT INTO statements, for example:

INSERT INTO odbc('DSN', 'table_name', 'user', 'password') VALUES (...)

This allows data to be written directly to the external data source accessed via ODBC during insert operations.