SQL dialect
ClickHouse SQL Parser for Java and .NET
General SQL Parser (GSP) parses ClickHouse with a dedicated, hand-tuned grammar — full AST access, offline syntax validation, formatting, rewriting, and column-level data lineage . One commercial SDK, 38 dialects, Java and .NET.
Example
ClickHouse SQL that GSP parses
CREATE TABLE hits (dt DateTime, uid UInt64)
ENGINE = MergeTree()
PARTITION BY toYYYYMM(dt)
ORDER BY (dt, uid);Parse it in Java
import gudusoft.gsqlparser.*;
TGSqlParser parser = new TGSqlParser(EDbVendor.dbvclickhouse);
parser.sqltext = sql; // the ClickHouse SQL above
if (parser.parse() == 0) {
System.out.println(parser.sqlstatements.size() + " statement(s) parsed");
} else {
System.out.println(parser.getErrormessage());
}The .NET edition exposes the same API in C# — see the C# quick start.
Coverage
What GSP handles in ClickHouse
- ENGINE = MergeTree clauses
- PREWHERE filtering
- ARRAY JOIN
- LIMIT BY and SAMPLE
- Materialized views ON CLUSTER
Beyond parsing, the same AST powers table/column extraction, validation, formatting, and column-level lineage for ClickHouse.
Actively maintained
Recent ClickHouse parser updates
- 2026-01-26 Fix 44 shift/reduce conflicts in ClickHouse parser
Full history in the release notes.
Go deeper
ClickHouse resources
- ClickHouse syntax reference — dialect documentation
- ClickHouse keyword compatibility — every keyword, and whether it can be an identifier
- Java quick start — Maven/Gradle setup and first parse
- C# quick start — NuGet setup for .NET
Common questions
Do I need a ClickHouse database connection to validate SQL?
No. GSP validates ClickHouse syntax completely offline. You get error line and column positions, the offending token, and a hint — with no server, driver, or credentials involved.
How complete is the ClickHouse grammar?
GSP uses a dedicated hand-tuned grammar for ClickHouse — not a generic SQL grammar with flags. The parser recognizes 554 ClickHouse keywords and knows which 526 of them can also be used as identifiers, which is exactly the kind of edge case that breaks generic parsers.
Can I use the ClickHouse parser from C# / .NET?
Yes. The .NET edition (NuGet package gudusoft.gsqlparser, .NET Standard 2.0) exposes the same API surface as the Java edition, so every ClickHouse parsing feature on this page works in C# and VB.NET.
Can GSP extract column-level lineage from ClickHouse SQL?
Yes. The built-in DataFlowAnalyzer produces column-level lineage, impact analysis, and call graphs from ClickHouse scripts — it is the engine behind Gudu SQLFlow and the lineage integrations for DataHub and OpenMetadata.