Reference

Technical reference for the SQL surface and the on-disk/in-memory data model.

• Virtual Schema — the documents and blocks tables
• Built-in Functions — mq-db-specific, string, numeric, null-handling, and aggregate functions
• DDL Statements — CREATE TABLE, INSERT INTO, DROP TABLE, and friends
• Example Queries — hierarchy extraction, structural lint, and mixed mq/SQL queries
• Block Model — the Block struct and per-type properties
• Index Layers — zone maps, the interval index, and secondary indexes
• Storage Format — the on-disk page-file layout

For mq language syntax itself (selectors, control flow, pattern matching, …), see the mq documentation.