> ## Documentation Index
> Fetch the complete documentation index at: https://docs.narrative.io/llms.txt
> Use this file to discover all available pages before exploring further.

# SQL Commands

> Reference for NQL statement types and command syntax

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

| Statement                  | Purpose                              | Reference                                                          |
| -------------------------- | ------------------------------------ | ------------------------------------------------------------------ |
| `SELECT`                   | Execute a query and return results   | [SELECT](/nql/commands/select)                                     |
| `INSERT`                   | Add rows to an existing dataset      | [INSERT](/nql/commands/insert)                                     |
| `UPDATE`                   | Modify existing rows in a dataset    | [UPDATE](/nql/commands/update)                                     |
| `DELETE`                   | Remove rows from a dataset           | [DELETE](/nql/commands/delete)                                     |
| `CREATE MATERIALIZED VIEW` | Create a stored dataset from a query | [CREATE MATERIALIZED VIEW](/nql/commands/create-materialized-view) |

## Query Templates

NQL also supports parameterized queries through [query templates](/nql/commands/query-templates), which allow you to define reusable queries with placeholder variables.

## Related content

<CardGroup cols={2}>
  <Card title="Data Types" icon="shapes" href="/nql/data-types">
    Primitive and complex types supported in NQL
  </Card>

  <Card title="Functions" icon="function" href="/nql/functions/index">
    Built-in and Narrative-specific functions
  </Card>
</CardGroup>