Apache Doris SQL Syntax Support

Apache Doris is an open-source, MPP-based real-time analytical database that speaks a largely MySQL-compatible SQL dialect while adding its own DDL for data models, partitioning, and materialized views.

General SQL Parser (GSP) parses Apache Doris SQL with a dedicated grammar, producing a full AST that supports offline syntax validation, SQL formatting, and column-level data lineage for Doris queries and DDL. Because Doris syntax diverges from stock MySQL in areas like CREATE TABLE distribution clauses, using the dedicated Doris dialect gives more accurate results than parsing as MySQL.

See the Apache Doris Keyword Compatibility Reference for which keywords can appear as unquoted identifiers.