* feat(keywords): add ClickHouse dialect support - Add DialectClickHouse constant and register in AllDialects()/DialectKeywords() - Add CLICKHOUSE_SPECIFIC keyword set (FINAL, ENGINE, CODEC, TTL, REPLICATED, DISTRIBUTED, MATERIALIZED, ALIAS, FixedString, LowCardinality, Nullable, DateTime64, IPv4, IPv6, PASTE) - Wire CLICKHOUSE_SPECIFIC into keywords.New() switch - Add PREWHERE/FINAL/SETTINGS/FORMAT to tokenizer's hardcoded keywordTokenTypes map so they are tokenized as TokenTypeKeyword (not IDENTIFIER), enabling correct clause boundary detection during FROM clause parsing - Add parsePrewhereClause() to SELECT parsing for ClickHouse dialect - Add PrewhereClause field to SelectStatement AST node (with Children(), SQL(), and PutSelectStatement cleanup) - Update snowflake_test.go dialect registry test to include ClickHouse - Add clickhouse_test.go with dialect registration and PREWHERE parsing tests Closes #392 Co-Authored-By: Claude Sonnet 4.6 <noreply@anthropic.com> * feat(dialect): add ClickHouse SQL dialect support - Add DialectClickHouse to keywords package with 25+ ClickHouse-specific keywords: PREWHERE, FINAL, ENGINE, GLOBAL, ASOF, TTL, FORMAT, CODEC, SETTINGS, DISTRIBUTED, MERGETREE family, and more - Add PreWhere field to SelectStatement AST node - Parse PREWHERE clause in ClickHouse dialect mode (pre-filter executed before WHERE for MergeTree optimization) - Register ClickHouse in AllDialects() and DialectKeywords() - Add keyword and parser integration tests Closes #392 Co-Authored-By: Claude Sonnet 4.6 <noreply@anthropic.com> * fix(clickhouse): address review feedback on PR #418 - Remove SETTINGS/FORMAT from global tokenizer keyword map; only PREWHERE and FINAL belong there (SETTINGS/FORMAT are generic words that would conflict with column names in other dialects) - Add Final bool field to TableReference AST node; parse FINAL modifier after table reference in ClickHouse dialect - Handle GLOBAL IN / GLOBAL NOT IN in ClickHouse dialect expression parser (GLOBAL is consumed as a modifier, IN parsed normally) - Fix TestClickHouseFinal to assert FINAL=true on TableReference - Convert TestClickHouseKeywordRecognition to t.Skip (SAMPLE clause not yet implemented) - Add [Unreleased] CHANGELOG.md entry for ClickHouse dialect Co-Authored-By: Claude Sonnet 4.6 <noreply@anthropic.com> * docs(clickhouse): fix stale comment in CLICKHOUSE_SPECIFIC Clarify that PREWHERE and FINAL appear in both CLICKHOUSE_SPECIFIC and the tokenizer's hardcoded keywordTokenTypes map (not the "base keyword set"), and that SETTINGS/FORMAT are not there. Removes the inaccurate statement that these keywords are "in the base keyword set". Co-Authored-By: Claude Sonnet 4.6 <noreply@anthropic.com> * fix(clickhouse): handle GLOBAL JOIN and document FINAL limitation - Parse GLOBAL JOIN in ClickHouse dialect by consuming the GLOBAL modifier before join type detection in parseJoinType(); prevents regression where GLOBAL (now TokenTypeKeyword) would cause join parsing to fail - Add FINAL limitation comment: parser only supports FINAL on the first (primary) table reference in a FROM clause - Add TestClickHouseGlobalJoin and TestClickHouseGlobalIn parser tests Co-Authored-By: Claude Sonnet 4.6 <noreply@anthropic.com> * test(clickhouse): add FINAL modifier edge case tests Co-Authored-By: Claude Sonnet 4.6 <noreply@anthropic.com> * feat(clickhouse): emit FINAL in SQL() round-trip output Add FINAL keyword emission to tableRefSQL() in sql.go so that TableReference.Final=true is preserved during AST→SQL round-trip serialization. Add TestClickHouseFinalRoundtrip to verify the SQL() output contains FINAL after parsing SELECT * FROM orders FINAL with DialectClickHouse. Co-Authored-By: Claude Sonnet 4.6 <noreply@anthropic.com> --------- Co-authored-by: Ajit Pratap Singh <ajitpratapsingh@Ajits-Mac-mini-2655.local> Co-authored-by: Claude Sonnet 4.6 <noreply@anthropic.com>

[FEATURE] support ClickHouse syntax dialect #392

Description

Feature Description

Problem Statement

Metadata

Metadata

Assignees

Labels

Projects

Milestone

Relationships

Development

Issue actions