Identifiers and Keywords

DeltaStream SQL uses a lexical policy for identifiers (such as tables, columns, and function names) similar to SQL:

• The case of identifiers is not preserved unless they are quoted.

• Double-quotes " and back-ticks ` allow identifiers to contain non-alphanumeric characters, such as SELECT a AS `my field` FROM t.

String literals must be enclosed in single quotes ', such as 'Joe Smith'. Duplicate a single quote for escaping, such as SELECT 'It''s me'.

Reserved Keywords

The following is a list of reserved keywords in DeltaStream SQL:

A	ABS	ABSOLUTE
ACCEPT	ACTION	ADA
ADD	ADMIN	ADVANCE
AFTER	ALL	ALLOCATE
ALLOW	ALTER	ALWAYS
ANALYZE	AND	ANY
API_TOKEN	API_TOKENS	APPLICATION
APPROXIMATE	ARE	ARRAY
AS	ASC	ASENSITIVE
ASSERTION	ASSIGNMENT	ASYMMETRIC
AT	ATOMIC	ATTRIBUTE
ATTRIBUTES	AUTHORIZATION	AVG
AWS	BEFORE	BEGIN
BEGINNING	BERNOULLI	BETWEEN
BIGINT	BINARY	BIT
BLOB	BOOLEAN	BOTH
BREADTH	BY	BYTES
C	CALL	CALLED
CAN	CARDINALITY	CASCADE
CASCADED	CASE	CAST
CATALOG	CATALOGS	CATALOG_NAME
CEIL	CEILING	CENTURY
CHAIN	CHANGELOG	CHANGELOGS
CHAR	CHARACTER	CHARACTERISTICS
CHARACTERS	CHARACTER_LENGTH	CHARACTER_SET_CATALOG
CHARACTER_SET_NAME	CHARACTER_SET_SCHEMA	CHAR_LENGTH
CHECK	CLASS_ORIGIN	CLICKHOUSE
CLOB	CLOSE	COALESCE
COBOL	COLLATE	COLLATION
COLLATION_CATALOG	COLLATION_NAME	COLLATION_SCHEMA
COLLECT	COLUMN	COLUMNS
COLUMN_NAME	COMMAND_FUNCTION	COMMAND_FUNCTION_CODE
COMMIT	COMMITTED	COMPUTE_POOL
COMPUTE_POOLS	CONDITION	CONDITIONAL
CONDITION_NUMBER	CONFIDENCE	CONFLUENT
CONNECT	CONNECTION	CONNECTION_NAME
CONNECTOR	CONNECTORS	CONSTRAINT
CONSTRAINTS	CONSTRAINT_CATALOG	CONSTRAINT_NAME
CONSTRAINT_SCHEMA	CONSTRUCTOR	CONTACT
CONTAINS	CONTINUE	CONVERT
COPY	CORR	CORRESPONDING
COUNT	COVAR_POP	COVAR_SAMP
CREATE	CREDENTIAL	CROSS
CSTREAM	CUBE	CUME_DIST
CUMULATE	CURRENT	CURRENT_CATALOG
CURRENT_DATE	CURRENT_DEFAULT_TRANSFORM_GROUP	CURRENT_PATH
CURRENT_ROLE	CURRENT_SCHEMA	CURRENT_TIME
CURRENT_TIMESTAMP	CURRENT_TRANSFORM_GROUP_FOR_TYPE	CURRENT_USER
CURSOR	CURSOR_NAME	CYCLE
DATA	DATABASE	DATABASES
DATABRICKS	DATE	DATETIME_INTERVAL_CODE
DATETIME_INTERVAL_PRECISION	DAY	DAYS
DDL	DEALLOCATE	DEC
DECADE	DECIMAL	DECLARE
DEFAULT	DEFAULTS	DEFERRABLE
DEFERRED	DEFINE	DEFINED
DEFINER	DEGREE	DELETE
DENSE_RANK	DEPTH	DEREF
DERIVED	DESC	DESCRIBE
DESCRIPTION	DESCRIPTOR	DESCRIPTORS
DESCRIPTOR_SOURCE	DESCRIPTOR_SOURCES	DETERMINISTIC
DIAGNOSTICS	DISALLOW	DISCONNECT
DISPATCH	DISTINCT	DISTRIBUTED
DOMAIN	DOUBLE	DOW
DOY	DROP	DYNAMIC
DYNAMIC_FUNCTION	DYNAMIC_FUNCTION_CODE	EACH
ELEMENT	ELSE	EMPTY
ENCODING	END	END-EXEC
ENTITIES	ENTITY	EPOCH
EQUALS	ERROR	ESCAPE
EVENTS	EVERY	EXCEPT
EXCEPTION	EXCLUDE	EXCLUDING
EXEC	EXECUTE	EXISTS
EXIT	EXP	EXPLAIN
EXPORT	EXTEND	EXTENDED
EXTERNAL	EXTRACT	FAILED
FALSE	FETCH	FILE
FILTER	FINAL	FIRST
FIRST_VALUE	FLOAT	FLOOR
FOLLOWING	FOR	FOREIGN
FORMAT	FORTRAN	FOUND
FRAC_SECOND	FREE	FROM
FULL	FUNCTION	FUNCTIONS
FUNCTION_SOURCE	FUNCTION_SOURCES	FUSION
G	GAP	GENERAL
GENERATE	GENERATED	GET
GLOBAL	GO	GOTO
GRANT	GRANTED	GRAPHVIZ
GROUP	GROUPING	HAVING
HIERARCHY	HISTORY	HOLD
HOP	HOPPING	HOUR
HOURS	ICEBERG_GLUE	ICEBERG_REST
IDENTITY	IF	IMMEDIATE
IMPLEMENTATION	IMPORT	IN
INCLUDING	INCREMENT	INDEX
INDEXES	INDICATOR	INITIALLY
INNER	INOUT	INPUT
INSENSITIVE	INSERT	INSTANCE
INSTANTIABLE	INT	INTEGER
INTEGRATION	INTEGRATIONS	INTERACTIVE
INTERSECT	INTERSECTION	INTERVAL
INTO	INVITATION	INVITATIONS
INVITE	INVOKER	IS
ISOLATION	JAVA	JOIN
JSON	JSON_QUERY	JSON_VALUE
K	KAFKA	KEEP
KEY	KEY_MEMBER	KEY_TYPE
KINESIS	LABEL	LANGUAGE
LARGE	LAST	LAST_VALUE
LATERAL	LEADING	LEFT
LENGTH	LEVEL	LIBRARY
LIKE	LIMIT	LINK
LINKS	LIST	LN
LOAD	LOCAL	LOCALTIME
LOCALTIMESTAMP	LOCATOR	LOGICAL
LOGOUT	LOWER	M
MAP	MATCH	MATCHED
MATCH_RECOGNIZE	MATERIALIZED	MAX
MAXVALUE	MEASURES	MEDIUM
MEMBER	MERGE	MESSAGE_LENGTH
MESSAGE_OCTET_LENGTH	MESSAGE_TEXT	METADATA
METHOD	METRICS	MICROSECOND
MILLENNIUM	MILLISECOND	MILLISECONDS
MIN	MINUTE	MINUTES
MINVALUE	MOD	MODIFIES
MODULE	MODULES	MONGODB
MONTH	MONTHS	MORE
MULTISET	MUMPS	NAME
NAMES	NATIONAL	NATURAL
NCHAR	NCLOB	NESTING
NEW	NEXT	NFC
NFD	NFKC	NFKD
NO	NONE	NORMALIZE
NORMALIZED	NOT	NOTIFICATION
NULL	NULLABLE	NULLIF
NULLS	NUMBER	NUMERIC
OBJECT	OCTETS	OCTET_LENGTH
OF	OFFSET	OKTA
OLD	OMIT	ON
ONLY	OPEN	OPTION
OPTIONS	OR	ORACLE
ORDER	ORDERING	ORDINALITY
ORGANIZATION	ORGANIZATIONS	OTHERS
OUT	OUTER	OUTPUT
OVER	OVERLAPS	OVERLAY
OVERRIDING	OWNER	OWNERSHIP
PAD	PARAMETER	PARAMETER_MODE
PARAMETER_NAME	PARAMETER_ORDINAL_POSITION	PARAMETER_SPECIFIC_CATALOG
PARAMETER_SPECIFIC_NAME	PARAMETER_SPECIFIC_SCHEMA	PARTIAL
PARTITION	PARTITIONS	PASCAL
PASSING	PASSTHROUGH	PASSWORD
PATH	PATTERN	PENDING
PERCENTILE_CONT	PERCENTILE_DISC	PERCENT_RANK
PERMUTE	PLACING	PLAIN
PLAN	PLI	POISSONIZED
PORT	POSITION	POSTGRES
POSTGRESQL	POWER	PRECEDING
PRECISION	PREPARE	PRESERVE
PRIMARY	PRINT	PRIOR
PRIVATE	PRIVILEGES	PROCEDURE
PROPERTIES	PUBLIC	PYTHON
QUARTER	QUERIES	QUERY
QUIT	QUOTES	RANGE
RANK	RAW	READ
READS	REAL	RECURSIVE
REF	REFERENCES	REFERENCING
REGION	REGISTER	REGISTERED
REGR_AVGX	REGR_AVGY	REGR_COUNT
REGR_INTERCEPT	REGR_R2	REGR_SLOPE
REGR_SXX	REGR_SXY	REGR_SYY
REJECT	RELATION	RELATIONS
RELATIVE	RELEASE	RENAME
RENEW	REPEATABLE	REPLACE
REPLICAS	RESCALED	RESET
RESTART	RESTRICT	RESULT
RETURN	RETURNED_CARDINALITY	RETURNED_LENGTH
RETURNED_OCTET_LENGTH	RETURNED_SQLSTATE	RETURNING
RETURNS	REVOKE	RIGHT
ROLE	ROLES	ROLLBACK
ROLLUP	ROUTINE	ROUTINE_CATALOG
ROUTINE_NAME	ROUTINE_SCHEMA	ROW
ROWS	ROW_COUNT	ROW_NUMBER
RUN	SALES	SAMPLE
SANDBOX	SAVEPOINT	SCALAR
SCALE	SCHEMA	SCHEMAS
SCHEMA_NAME	SCHEMA_REGISTRIES	SCHEMA_REGISTRY
SCIM	SCOPE	SCOPE_CATALOGS
SCOPE_NAME	SCOPE_SCHEMA	SCRIPT
SCROLL	SEARCH	SECOND
SECONDS	SECRET	SECRETS
SECTION	SECURITY	SELECT
SELF	SENSITIVE	SEQUENCE
SERIALIZABLE	SERVER	SERVER_NAME
SESSION	SESSION_USER	SET
SETS	SHOW	SIMILAR
SIMPLE	SIZE	SMALL
SMALLINT	SNOWFLAKE	SOME
SOURCE	SPACE	SPECIFIC
SPECIFICTYPE	SPECIFIC_NAME	SQL
SQLEXCEPTION	SQLSTATE	SQLWARNING
SQL_TSI_DAY	SQL_TSI_FRAC_SECOND	SQL_TSI_HOUR
SQL_TSI_MICROSECOND	SQL_TSI_MINUTE	SQL_TSI_MONTH
SQL_TSI_QUARTER	SQL_TSI_SECOND	SQL_TSI_WEEK
SQL_TSI_YEAR	SQRT	START
STATE	STATEMENT	STATIC
STDDEV_POP	STDDEV_SAMP	STEP
STOP	STORE	STORES
STRATIFY	STREAM	STREAMS
STRING	STRUCT	STRUCTURE
STYLE	SUBCLASS_ORIGIN	SUBMULTISET
SUBSET	SUBSTITUTE	SUBSTRING
SUM	SYMMETRIC	SYSTEM
SYSTEM_USER	TABLE	TABLES
TABLESAMPLE	TABLE_NAME	TAG
TEMPLATE	TEMPORARY	TERMINATE
TEXT	THEN	TIES
TIME	TIMESTAMP	TIMESTAMPADD
TIMESTAMPDIFF	TIMESTAMP_LTZ	TIMEZONE_HOUR
TIMEZONE_MINUTE	TINYINT	TO
TOKEN	TOP_LEVEL_COUNT	TRAILING
TRANSACTION	TRANSACTIONS_ACTIVE	TRANSACTIONS_COMMITTED
TRANSACTIONS_ROLLED_BACK	TRANSFORM	TRANSFORMS
TRANSLATE	TRANSLATION	TREAT
TRIGGER	TRIGGER_CATALOG	TRIGGER_NAME
TRIGGER_SCHEMA	TRIM	TRUE
TRY	TRY_CAST	TUMBLE
TUMBLING	TYPE	UESCAPE
UNBOUNDED	UNCOMMITTED	UNCONDITIONAL
UNDER	UNION	UNIQUE
UNKNOWN	UNNAMED	UNNEST
UNSET	UPDATE	UPPER
UPSERT	USAGE	USE
USER	USERDATA	USERNAME
USERS	USER_DEFINED_TYPE_CATALOG	USER_DEFINED_TYPE_CODE
USER_DEFINED_TYPE_NAME	USER_DEFINED_TYPE_SCHEMA	USING
VALUE	VALUES	VARBINARY
VARCHAR	VARYING	VAR_POP
VAR_SAMP	VERSION	VIEW
VIEWS	VIRTUAL	WEEK
WHEN	WHENEVER	WHERE
WIDTH_BUCKET	WINDOW	WITH
WITHIN	WITHOUT	WORK
WRAPPER	WRITE	XML
YEAR	YEARS	ZONE