SQL reference
SQL reference
Every statement family the NYXDB engine accepts, mapped to its reference page.
One request carries one statement, at most 64 KiB. Keywords are case-insensitive. Every example on these pages is copied from an engine test, and the line under each example names that test; an example marked "Grammar only" is proven by a parser test, not by execution.
Statement map
| Statements | Page |
|---|---|
Lexical rules, identifiers, literals, ? parameters | Syntax |
| Column types | Data types |
CREATE TABLE | CREATE TABLE |
INSERT, UPSERT, REPLACE | INSERT |
UPDATE, DELETE | UPDATE and DELETE |
ALTER TABLE | ALTER TABLE |
DROP TABLE, DROP INDEX, DROP VIEW, DROP TRANSFORMATION, DROP MATERIALIZED VIEW, DROP MATERIALIZATION | DROP |
SELECT, WITH, set operations, AS OF COMMIT | SELECT |
| Joins | Joins |
CREATE VIEW, CREATE MATERIALIZED VIEW, CREATE MATERIALIZATION | Views |
CREATE TRANSFORMATION | CREATE TRANSFORMATION |
STREAM SELECT, windows, EMIT | Streaming |
SETTINGS clause, SET, RESET, SHOW SETTINGS | Settings |
CREATE/ALTER/DROP USER, CREATE/ALTER/DROP API KEY | Users and API keys |
CREATE SOURCE, CREATE CREDENTIAL, CREATE APPLICATION ACCESS, GRANT … TO APPLICATION ACCESS | Federation |
SHOW TABLES, SHOW CREATE …, DESCRIBE | Introspection |
Statement atomicity; no BEGIN or COMMIT | Transactions |
Functions, casts, CASE, aggregates | Functions |
How statements are routed
- Credential statements (
USER,API KEY) and federation statements are recognised before the relational parser and handled by their own services. SET,RESETand federation statements run on a WebSocket session; see Protocol.GRANTandREVOKEmanage the rights of users and roles; see Governance.