Skip to content

ClickHouse SQL Syntax Support

ClickHouse is an open-source, column-oriented OLAP database designed for real-time analytical queries over very large datasets. Its SQL dialect extends standard SQL with ClickHouse-specific constructs such as table engines (for example, the MergeTree family), ARRAY JOIN, and FORMAT clauses.

General SQL Parser (GSP) parses ClickHouse SQL with a dedicated, hand-tuned grammar rather than a generic SQL grammar, so you get a full AST, offline syntax validation, SQL formatting, and column-level data lineage for ClickHouse statements. The parser is exercised by GSP's continuous unit-test suite and updated in the regular release cycle.

For details on which ClickHouse keywords can be used as unquoted identifiers, see the ClickHouse Keyword Compatibility Reference.