The SQL Language#
MuduDB uses a SQL dialect parsed by a tree-sitter grammar tailored to its storage and execution model. The dialect covers DDL for schema definition, DML for data mutation, and SELECT for single-table queries. This section describes each category, the syntax MuduDB accepts, and the limits of what is currently supported.
Compatibility and Pitfalls#
The following syntax is accepted by the grammar, but the v0.1 engine silently ignores its semantics (no error is raised and the meaning does not take effect):
CREATE TABLE IF NOT EXISTS—IF NOT EXISTSis ignored: creating an existing table still fails.Column-level
DEFAULTconstraints — parsed but ignored; no default value is filled in for the column.Table-level
FOREIGN KEY ... REFERENCESconstraints — parsed but not enforced.SELECT DISTINCT—DISTINCTis ignored; the result is not deduplicated.