SQL Commands

NQL supports statement types for querying, forecasting, creating stored datasets, and modifying data in existing datasets.

Statement	Purpose	Reference
`SELECT`	Execute a query and return results	SELECT
`INSERT`	Add rows to an existing dataset	INSERT
`UPDATE`	Modify existing rows in a dataset	UPDATE
`DELETE`	Remove rows from a dataset	DELETE
`EXPLAIN`	Forecast data availability and cost without executing	EXPLAIN
`CREATE MATERIALIZED VIEW`	Create a stored dataset from a query	CREATE MATERIALIZED VIEW

Query Templates

NQL also supports parameterized queries through query templates, which allow you to define reusable queries with placeholder variables.

Primitive and complex types supported in NQL

Built-in and Narrative-specific functions

⌘I