# SQL Syntax

- [Data Formats (Serialization)](https://docs.deltastream.io/reference/sql-syntax/data-format-serialization.md)
- [Serializing with JSON](https://docs.deltastream.io/reference/sql-syntax/data-format-serialization/serde-with-json-data.md)
- [Serializing with Primitive Data Types](https://docs.deltastream.io/reference/sql-syntax/data-format-serialization/serde-with-primitive-data.md)
- [Serializing with Protobuf](https://docs.deltastream.io/reference/sql-syntax/data-format-serialization/serializing-with-protobuf.md)
- [Data Types](https://docs.deltastream.io/reference/sql-syntax/data-types.md)
- [Identifiers and Keywords](https://docs.deltastream.io/reference/sql-syntax/identifiers-and-keywords.md)
- [Command](https://docs.deltastream.io/reference/sql-syntax/command.md)
- [ACCEPT INVITATION](https://docs.deltastream.io/reference/sql-syntax/command/accept-invitation.md)
- [CAN I](https://docs.deltastream.io/reference/sql-syntax/command/can-i.md)
- [COPY DESCRIPTOR\_SOURCE](https://docs.deltastream.io/reference/sql-syntax/command/copy-descriptor_source.md)
- [COPY FUNCTION\_SOURCE](https://docs.deltastream.io/reference/sql-syntax/command/copy-function_source.md)
- [DESCRIBE ENTITY](https://docs.deltastream.io/reference/sql-syntax/command/describe-entity.md)
- [DESCRIBE QUERY](https://docs.deltastream.io/reference/sql-syntax/command/describe-query.md)
- [DESCRIBE QUERY METRICS](https://docs.deltastream.io/reference/sql-syntax/command/describe-query-metrics.md)
- [DESCRIBE QUERY EVENTS](https://docs.deltastream.io/reference/sql-syntax/command/describe-query-events.md)
- [DESCRIBE QUERY STATE](https://docs.deltastream.io/reference/sql-syntax/command/describe-query-state.md)
- [DESCRIBE RELATION](https://docs.deltastream.io/reference/sql-syntax/command/describe-relation.md)
- [DESCRIBE RELATION COLUMNS](https://docs.deltastream.io/reference/sql-syntax/command/describe-relation-columns.md)
- [DESCRIBE ROLE](https://docs.deltastream.io/reference/sql-syntax/command/describe-role.md)
- [DESCRIBE SECURITY INTEGRATION](https://docs.deltastream.io/reference/sql-syntax/command/describe-security-integration.md)
- [DESCRIBE \<statement>](https://docs.deltastream.io/reference/sql-syntax/command/describe-less-than-statement-greater-than.md)
- [DESCRIBE STORE](https://docs.deltastream.io/reference/sql-syntax/command/describe-store.md)
- [DESCRIBE USER](https://docs.deltastream.io/reference/sql-syntax/command/describe-user.md)
- [GENERATE STREAM DDL](https://docs.deltastream.io/reference/sql-syntax/command/generate-columns.md)
- [GENERATE CHANGELOG DDL](https://docs.deltastream.io/reference/sql-syntax/command/generate-changelog-ddl.md)
- [GENERATE TEMPLATE](https://docs.deltastream.io/reference/sql-syntax/command/generate-template.md)
- [GRANT OWNERSHIP](https://docs.deltastream.io/reference/sql-syntax/command/grant-ownership.md)
- [GRANT PRIVILEGES](https://docs.deltastream.io/reference/sql-syntax/command/grant-privileges.md)
- [GRANT ROLE](https://docs.deltastream.io/reference/sql-syntax/command/grant-role.md)
- [INVITE USER](https://docs.deltastream.io/reference/sql-syntax/command/invite-user.md)
- [LIST API\_TOKENS](https://docs.deltastream.io/reference/sql-syntax/command/list-api_tokens.md)
- [LIST COMPUTE\_POOLS](https://docs.deltastream.io/reference/sql-syntax/command/list-compute_pools.md)
- [LIST DATABASES](https://docs.deltastream.io/reference/sql-syntax/command/list-databases.md)
- [LIST DESCRIPTORS](https://docs.deltastream.io/reference/sql-syntax/command/list-descriptors.md)
- [LIST DESCRIPTOR\_SOURCES](https://docs.deltastream.io/reference/sql-syntax/command/list-descriptor_sources.md)
- [LIST ENTITIES](https://docs.deltastream.io/reference/sql-syntax/command/list-entities.md)
- [LIST FUNCTIONS](https://docs.deltastream.io/reference/sql-syntax/command/list-functions.md)
- [LIST FUNCTION\_SOURCES](https://docs.deltastream.io/reference/sql-syntax/command/list-function_sources.md)
- [LIST INVITATIONS](https://docs.deltastream.io/reference/sql-syntax/command/list-invitations.md)
- [LIST METRICS INTEGRATIONS](https://docs.deltastream.io/reference/sql-syntax/command/list-metrics-integrations.md)
- [LIST ORGANIZATIONS](https://docs.deltastream.io/reference/sql-syntax/command/list-organizations.md)
- [LIST QUERIES](https://docs.deltastream.io/reference/sql-syntax/command/list-queries.md)
- [LIST RELATIONS](https://docs.deltastream.io/reference/sql-syntax/command/list-relations.md)
- [LIST ROLES](https://docs.deltastream.io/reference/sql-syntax/command/list-roles.md)
- [LIST SCHEMAS](https://docs.deltastream.io/reference/sql-syntax/command/list-schemas.md)
- [LIST SCHEMA\_REGISTRIES](https://docs.deltastream.io/reference/sql-syntax/command/list-schema_registries.md)
- [LIST SECRETS](https://docs.deltastream.io/reference/sql-syntax/command/list-secrets.md)
- [LIST SECURITY INTEGRATIONS](https://docs.deltastream.io/reference/sql-syntax/command/list-security-integrations.md)
- [LIST STORES](https://docs.deltastream.io/reference/sql-syntax/command/list-stores.md)
- [LIST USERS](https://docs.deltastream.io/reference/sql-syntax/command/list-users.md)
- [PRINT ENTITY](https://docs.deltastream.io/reference/sql-syntax/command/print-entity.md)
- [REJECT INVITATION](https://docs.deltastream.io/reference/sql-syntax/command/reject-invitation.md)
- [REVOKE INVITATION](https://docs.deltastream.io/reference/sql-syntax/command/revoke-invitation.md)
- [REVOKE PRIVILEGES](https://docs.deltastream.io/reference/sql-syntax/command/revoke-privileges.md)
- [REVOKE ROLE](https://docs.deltastream.io/reference/sql-syntax/command/revoke-role.md)
- [SET DEFAULT](https://docs.deltastream.io/reference/sql-syntax/command/set-default.md)
- [USE](https://docs.deltastream.io/reference/sql-syntax/command/use.md)
- [START COMPUTE\_POOL](https://docs.deltastream.io/reference/sql-syntax/command/start-compute_pool.md)
- [STOP COMPUTE\_POOL](https://docs.deltastream.io/reference/sql-syntax/command/stop-compute_pool.md)
- [DDL](https://docs.deltastream.io/reference/sql-syntax/ddl.md)
- [ALTER API\_TOKEN](https://docs.deltastream.io/reference/sql-syntax/ddl/alter-api_token.md)
- [ALTER QUERY](https://docs.deltastream.io/reference/sql-syntax/ddl/alter-query.md)
- [ALTER SECURITY INTEGRATION](https://docs.deltastream.io/reference/sql-syntax/ddl/alter-security-integration.md)
- [CREATE API\_TOKEN](https://docs.deltastream.io/reference/sql-syntax/ddl/create-api_token.md)
- [CREATE CHANGELOG](https://docs.deltastream.io/reference/sql-syntax/ddl/create-changelog.md)
- [CREATE COMPUTE\_POOL](https://docs.deltastream.io/reference/sql-syntax/ddl/create-compute_pool.md)
- [CREATE DATABASE](https://docs.deltastream.io/reference/sql-syntax/ddl/create-database.md)
- [CREATE DESCRIPTOR\_SOURCE](https://docs.deltastream.io/reference/sql-syntax/ddl/create-descriptor_source.md)
- [CREATE ENTITY](https://docs.deltastream.io/reference/sql-syntax/ddl/create-entity.md)
- [CREATE FUNCTION\_SOURCE](https://docs.deltastream.io/reference/sql-syntax/ddl/create-function_source.md)
- [CREATE FUNCTION](https://docs.deltastream.io/reference/sql-syntax/ddl/create-function.md)
- [CREATE INDEX](https://docs.deltastream.io/reference/sql-syntax/ddl/create-index.md)
- [CREATE METRICS INTEGRATION](https://docs.deltastream.io/reference/sql-syntax/ddl/create-metrics-integration.md)
- [CREATE ORGANIZATION](https://docs.deltastream.io/reference/sql-syntax/ddl/create-organization.md)
- [CREATE ROLE](https://docs.deltastream.io/reference/sql-syntax/ddl/create-role.md)
- [CREATE SCHEMA\_REGISTRY](https://docs.deltastream.io/reference/sql-syntax/ddl/create-schema_registry.md)
- [CREATE SCHEMA](https://docs.deltastream.io/reference/sql-syntax/ddl/create-schema.md)
- [CREATE SECRET](https://docs.deltastream.io/reference/sql-syntax/ddl/create-secret.md)
- [CREATE SECURITY INTEGRATION](https://docs.deltastream.io/reference/sql-syntax/ddl/create-security-integration.md)
- [CREATE STORE](https://docs.deltastream.io/reference/sql-syntax/ddl/create-store.md)
- [CREATE STREAM](https://docs.deltastream.io/reference/sql-syntax/ddl/create-stream.md)
- [CREATE TABLE](https://docs.deltastream.io/reference/sql-syntax/ddl/create-table.md)
- [DROP API\_TOKEN](https://docs.deltastream.io/reference/sql-syntax/ddl/drop-api_token.md)
- [DROP CHANGELOG](https://docs.deltastream.io/reference/sql-syntax/ddl/drop-changelog.md)
- [DROP COMPUTE\_POOL](https://docs.deltastream.io/reference/sql-syntax/ddl/drop-compute_pool.md)
- [DROP DATABASE](https://docs.deltastream.io/reference/sql-syntax/ddl/drop-database.md)
- [DROP DESCRIPTOR\_SOURCE](https://docs.deltastream.io/reference/sql-syntax/ddl/drop-descriptor_source.md)
- [DROP ENTITY](https://docs.deltastream.io/reference/sql-syntax/ddl/drop-entity.md)
- [DROP FUNCTION\_SOURCE](https://docs.deltastream.io/reference/sql-syntax/ddl/drop-function_source.md)
- [DROP FUNCTION](https://docs.deltastream.io/reference/sql-syntax/ddl/drop-function.md)
- [DROP METRICS INTEGRATION](https://docs.deltastream.io/reference/sql-syntax/ddl/drop-metrics-integration.md)
- [DROP RELATION](https://docs.deltastream.io/reference/sql-syntax/ddl/drop-relation.md)
- [DROP ROLE](https://docs.deltastream.io/reference/sql-syntax/ddl/drop-role.md)
- [DROP SCHEMA](https://docs.deltastream.io/reference/sql-syntax/ddl/drop-schema.md)
- [DROP SCHEMA\_REGISTRY](https://docs.deltastream.io/reference/sql-syntax/ddl/drop-schema_registry.md)
- [DROP SECRET](https://docs.deltastream.io/reference/sql-syntax/ddl/drop-secret.md)
- [DROP SECURITY INTEGRATION](https://docs.deltastream.io/reference/sql-syntax/ddl/drop-security-integration.md)
- [DROP STORE](https://docs.deltastream.io/reference/sql-syntax/ddl/drop-store.md)
- [DROP STREAM](https://docs.deltastream.io/reference/sql-syntax/ddl/drop-stream.md)
- [DROP USER](https://docs.deltastream.io/reference/sql-syntax/ddl/drop-user.md)
- [START/STOP COMPUTE\_POOL](https://docs.deltastream.io/reference/sql-syntax/ddl/start-stop-compute_pool.md)
- [UPDATE COMPUTE\_POOL](https://docs.deltastream.io/reference/sql-syntax/ddl/update-compute_pool.md)
- [UPDATE ENTITY](https://docs.deltastream.io/reference/sql-syntax/ddl/update-entity.md)
- [UPDATE SCHEMA\_REGISTRY](https://docs.deltastream.io/reference/sql-syntax/ddl/update-schema_registry.md)
- [UPDATE SECRET](https://docs.deltastream.io/reference/sql-syntax/ddl/update-secret.md)
- [UPDATE STORE](https://docs.deltastream.io/reference/sql-syntax/ddl/update-store.md)
- [Query](https://docs.deltastream.io/reference/sql-syntax/query.md)
- [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)
- [Sandbox](https://docs.deltastream.io/reference/sql-syntax/sandbox.md)
- [START SANDBOX](https://docs.deltastream.io/reference/sql-syntax/sandbox/start-sandbox.md)
- [DESCRIBE SANDBOX](https://docs.deltastream.io/reference/sql-syntax/sandbox/describe-sandbox.md)
- [STOP SANDBOX](https://docs.deltastream.io/reference/sql-syntax/sandbox/stop-sandbox.md)
- [Row Key Definition](https://docs.deltastream.io/reference/sql-syntax/relation-key-definition.md)
- [System Tables](https://docs.deltastream.io/reference/sql-syntax/systables.md)
- [audit\_logs](https://docs.deltastream.io/reference/sql-syntax/systables/audit-logs.md)
- [compute\_pools](https://docs.deltastream.io/reference/sql-syntax/systables/compute-pools.md)
- [databases](https://docs.deltastream.io/reference/sql-syntax/systables/databases.md)
- [descriptor\_sources](https://docs.deltastream.io/reference/sql-syntax/systables/descriptor-sources.md)
- [function\_sources](https://docs.deltastream.io/reference/sql-syntax/systables/function-sources.md)
- [functions](https://docs.deltastream.io/reference/sql-syntax/systables/functions.md)
- [organization\_defaults](https://docs.deltastream.io/reference/sql-syntax/systables/organization-defaults.md)
- [organization\_subscriptions](https://docs.deltastream.io/reference/sql-syntax/systables/organization-subscriptions.md)
- [organizations](https://docs.deltastream.io/reference/sql-syntax/systables/organizations.md)
- [pgusers](https://docs.deltastream.io/reference/sql-syntax/systables/pgusers.md)
- [queries](https://docs.deltastream.io/reference/sql-syntax/systables/queries.md)
- [query\_tags](https://docs.deltastream.io/reference/sql-syntax/systables/query-tags.md)
- [relation\_columns](https://docs.deltastream.io/reference/sql-syntax/systables/relation-columns.md)
- [relations](https://docs.deltastream.io/reference/sql-syntax/systables/relations.md)
- [role\_privileges](https://docs.deltastream.io/reference/sql-syntax/systables/role-privileges.md)
- [roles](https://docs.deltastream.io/reference/sql-syntax/systables/roles.md)
- [schema\_registries](https://docs.deltastream.io/reference/sql-syntax/systables/schema-registries.md)
- [schemas](https://docs.deltastream.io/reference/sql-syntax/systables/schemas.md)
- [secrets](https://docs.deltastream.io/reference/sql-syntax/systables/secrets.md)
- [stores](https://docs.deltastream.io/reference/sql-syntax/systables/stores.md)
- [user\_grants](https://docs.deltastream.io/reference/sql-syntax/systables/user-grants.md)
- [userdatas](https://docs.deltastream.io/reference/sql-syntax/systables/userdatas.md)


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.deltastream.io/reference/sql-syntax.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.