SQL reference
Statement-by-statement reference for NYXDB — DDL, DML, streaming and temporal reads, data types, and function families.
NYXDB speaks SQL over an interface-first query path: the parser accepts function-shaped syntax, and the binder plus runtime registry resolve the active function version for each query.
SQL text -> ISqlParser -> IQueryBinder -> ILogicalPlanner -> IQueryOptimizer -> IQueryExecutorCREATE TABLE
Append, keyed, attribute tables; the settings bag.
CREATE TRANSFORM
Standing INTO-target pipelines.
ALTER
Add/drop columns and attributes; transform controls.
SELECT
Reads, plus STREAM / HISTORICAL / AS OF.
INSERT
Row-value inserts.
DROP
Drop tables and transforms.
Data types
Integers, decimals, datetime64, vector(N), and more.
Functions
865 native functions across families.
Identifier and type names are case-insensitive (UInt64 and uint64 are the
same type). Every snippet in this reference follows the engine's own test SQL;
unverified surface is marked TODO-verify.