> 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.md). # 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 \](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)