> ## 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.

# NQL Reference

> Complete reference documentation for Narrative Query Language

NQL (Narrative Query Language) is a SQL-like language with extensions for data collaboration. This reference covers all syntax, types, functions, and operators supported by NQL.

> [!NOTE]
>
> Looking to learn NQL? Start with [NQL Design Philosophy](https://docs.narrative.io/concepts/nql/design-philosophy.md) for concepts or [Filtering and Transforming Data](https://docs.narrative.io/guides/nql/filtering-transforming.md) for hands-on examples.

## SQL Commands

Write and execute queries and create stored datasets.

> [card] [SELECT](https://docs.narrative.io/nql/commands/select.md)
>
> Retrieve data from datasets

> [card] [CREATE MATERIALIZED VIEW](https://docs.narrative.io/nql/commands/create-materialized-view.md)
>
> Create stored datasets from queries

> [card] [Query Templates](https://docs.narrative.io/nql/commands/query-templates.md)
>
> Parameterized queries with placeholder syntax

## Data Types

> [card] [Data Types](https://docs.narrative.io/nql/data-types.md)
>
> Primitive types, complex types, type casting, and NULL handling

## Operators

> [card] [Operators](https://docs.narrative.io/nql/operators.md)
>
> Comparison, logical, arithmetic, string, and pattern matching operators

## Functions

Built-in and Narrative-specific functions organized by category.

> [card] [String](https://docs.narrative.io/nql/functions/string-functions.md)
>
> Text manipulation

> [card] [Date & Time](https://docs.narrative.io/nql/functions/date-time-functions.md)
>
> Temporal operations

> [card] [Numeric](https://docs.narrative.io/nql/functions/numeric-functions.md)
>
> Math and rounding

> [card] [Aggregate](https://docs.narrative.io/nql/functions/aggregate-functions.md)
>
> GROUP BY computations

> [card] [Array & Map](https://docs.narrative.io/nql/functions/array-map-functions.md)
>
> Collection operations

> [card] [Window](https://docs.narrative.io/nql/functions/window-functions.md)
>
> Ranking and analytics

> [card] [Geospatial](https://docs.narrative.io/nql/functions/geospatial-functions.md)
>
> Geographic calculations

> [card] [Narrative](https://docs.narrative.io/nql/functions/narrative-functions.md)
>
> Platform-specific functions

> [card] [Conditional](https://docs.narrative.io/nql/functions/conditional-functions.md)
>
> IF, COALESCE, NULLIF

## General Reference

> [card] [Syntax Overview](https://docs.narrative.io/nql/general/syntax.md)
>
> Statement types and grammar

> [card] [Explicit Columns](https://docs.narrative.io/nql/general/explicit-columns.md)
>
> Why wildcards are not supported

> [card] [Reserved Keywords](https://docs.narrative.io/nql/general/reserved-keywords.md)
>
> Keywords requiring quoting


This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.