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, views, ATTACH/DETACH, and friends
• CTEs (WITH / WITH RECURSIVE): named subqueries and recursive queries
• Full-Text Search: match()/score()/bm25() and the find CLI shortcut
• EXPLAIN / EXPLAIN ANALYZE: inspect and profile a query’s index/join plan
• External Files: read_csv()/read_json() table functions
• Write-Back: INSERT/UPDATE/DELETE that edit the source Markdown file
• 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.