v.19.17Improvement

Queries Like CREATE TABLE ..

Queries like CREATE TABLE ... AS (SELECT (1, 2)) are parsed correctly #7542 (hcz)
Improved parsing support for queries using CREATE TABLE ... AS (SELECT ...) syntax with tuple expressions.

Why it matters

This feature addresses parsing issues for queries that create tables based on tuples returned by a SELECT statement. It ensures that queries like CREATE TABLE ... AS (SELECT (1, 2)) are correctly recognized and processed by ClickHouse, enhancing syntax flexibility and preventing errors during table creation from tuple results.

How to use it

Users can now write table creation queries using the syntax CREATE TABLE table_name AS (SELECT (1, 2)) without encountering parsing errors. No special configuration is required; this improvement is applied automatically in the newer ClickHouse version.