v.21.8Improvement

Allow complex quoted identifiers for JOINed tables

Allow complex quoted identifiers of JOINed tables. Close #17861. #25924 (alexey-milovidov).
ClickHouse now supports complex quoted identifiers in JOINed tables, allowing more flexible and precise referencing of table names in JOIN clauses.

Why it matters

This feature addresses the limitation of using simple identifiers in JOIN operations by enabling complex quoted identifiers. It allows users to reference tables with special characters or reserved keywords in their names during JOINs, improving query expressiveness and compatibility with various schemas.

How to use it

Simply use quoted identifiers with double quotes around table names in JOIN clauses as needed. For example:

SELECT * FROM "my-schema"."my-table" AS t1
JOIN "another-schema"."another-table" AS t2 ON t1.id = t2.id


The system now correctly parses and handles such complex quoted identifiers without errors.