Docs/SQL Support Reference

SQL Support Reference Manual

MagnumDB supports standard DDL, DML, JOIN, GROUP BY, HAVING, ORDER BY, LIMIT, Subqueries, CTEs, Window Functions, and Transaction Control statements.

Foreign Key Disclaimer:

FOREIGN KEY syntax is parsed by the lexer, but referential integrity constraints are NOT currently enforced.

syntax_manual.sql

sql

-- DDL Table Definition
CREATE TABLE accounts (
    id INT PRIMARY KEY,
    owner TEXT NOT NULL,
    balance FLOAT DEFAULT 0.0
);

-- DML & Transaction
BEGIN;
INSERT INTO accounts VALUES (1, 'Alice', 250.0);
UPDATE accounts SET balance = balance + 50.0 WHERE id = 1;
COMMIT;

SQL Reference Manual Transactions