> For the complete documentation index, see [llms.txt](https://docs.deltastream.io/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.deltastream.io/reference/sql-syntax/query.md).

# Query

- [APPLICATION](https://docs.deltastream.io/reference/sql-syntax/query/application.md)
- [CREATE CHANGELOG AS SELECT](https://docs.deltastream.io/reference/sql-syntax/query/create-changelog-as.md)
- [CREATE STREAM AS SELECT](https://docs.deltastream.io/reference/sql-syntax/query/create-stream-as.md)
- [CREATE TABLE AS SELECT](https://docs.deltastream.io/reference/sql-syntax/query/create-table-as.md)
- [Function](https://docs.deltastream.io/reference/sql-syntax/query/functions.md)
- [Built-in Functions](https://docs.deltastream.io/reference/sql-syntax/query/functions/built-in-functions.md)
- [Row Metadata Functions](https://docs.deltastream.io/reference/sql-syntax/query/functions/row-functions.md)
- [INSERT INTO](https://docs.deltastream.io/reference/sql-syntax/query/insert-into.md)
- [INSERT INTO ENTITY](https://docs.deltastream.io/reference/sql-syntax/query/insert-into-entity.md)
- [Materialized View](https://docs.deltastream.io/reference/sql-syntax/query/materialized-view.md)
- [CREATE MATERIALIZED VIEW AS](https://docs.deltastream.io/reference/sql-syntax/query/materialized-view/create-materialized-view-as.md)
- [SELECT (FROM MATERIALIZED VIEW)](https://docs.deltastream.io/reference/sql-syntax/query/materialized-view/select-from-materialized-view.md)
- [Query Name and Version](https://docs.deltastream.io/reference/sql-syntax/query/named-queries.md)
- [Resume Query](https://docs.deltastream.io/reference/sql-syntax/query/resume-query.md)
- [RESTART QUERY](https://docs.deltastream.io/reference/sql-syntax/query/restart-query.md)
- [SELECT](https://docs.deltastream.io/reference/sql-syntax/query/select.md)
- [FROM](https://docs.deltastream.io/reference/sql-syntax/query/select/from.md)
- [JOIN](https://docs.deltastream.io/reference/sql-syntax/query/select/join.md)
- [MATCH\_RECOGNIZE](https://docs.deltastream.io/reference/sql-syntax/query/select/match_recognize.md)
- [WITH (Common Table Expression)](https://docs.deltastream.io/reference/sql-syntax/query/select/with-common-table-expression.md)
- [TERMINATE QUERY](https://docs.deltastream.io/reference/sql-syntax/query/terminate-query.md)
- [Change Data Capture (CDC)](https://docs.deltastream.io/reference/sql-syntax/query/change-data-capture-cdc.md)
- [PostgreSQL](https://docs.deltastream.io/reference/sql-syntax/query/change-data-capture-cdc/postgresql.md)
- [MongoDB](https://docs.deltastream.io/reference/sql-syntax/query/change-data-capture-cdc/mongodb.md)
- [Oracle](https://docs.deltastream.io/reference/sql-syntax/query/change-data-capture-cdc/oracle.md)