v.19.3New Features

Added Ability to Send Queries INSERT INTO Tbl VALUES

Added ability to send queries INSERT INTO tbl VALUES (.... to server without splitting on query and data parts. #4301 (alesapin)
Added the ability to send INSERT INTO tbl VALUES (…) queries to the server without splitting them into separate query and data parts.

Why it matters

This feature simplifies client-server interaction by allowing single-statement INSERT INTO queries with inline values. It removes the need to separate the query structure from the actual data, making data insertion more straightforward and compatible with typical SQL usage patterns.

How to use it

Users can send complete INSERT INTO tbl VALUES (...) queries directly to the ClickHouse server without any special handling or splitting. Just execute the query as a single statement in the usual way.