v.21.8Improvement
Allow complex quoted identifiers for JOINed tables
Allow complex quoted identifiers of JOINed tables. Close #17861. #25924 (alexey-milovidov).
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.idThe system now correctly parses and handles such complex quoted identifiers without errors.