Expand description
This module defines
-
a list of constants for every keyword
-
an
ALL_KEYWORDS
array with every keyword in it This is not a list of reserved keywords: some of these can be parsed as identifiers if the parser decides so. This means that new keywords can be added here without affecting the parse result.As a matter of fact, most of these keywords are not used at all and could be removed.
-
a
RESERVED_FOR_TABLE_ALIAS
array with keywords reserved in a “table alias” context.
Enums§
Constants§
- ABORT
- ABS
- ABSENT
- ABSOLUTE
- ACCESS
- ACCOUNT
- ACTION
- ADD
- ADMIN
- AFTER
- AGAINST
- AGGREGATION
- ALERT
- ALGORITHM
- ALIAS
- ALL
- ALLOCATE
- ALL_
KEYWORDS - ALL_
KEYWORDS_ INDEX - ALTER
- ALWAYS
- ANALYZE
- AND
- ANTI
- ANY
- APPLICATION
- APPLY
- APPLYBUDGET
- ARCHIVE
- ARE
- ARRAY
- ARRAY_
MAX_ CARDINALITY - AS
- ASC
- ASENSITIVE
- ASOF
- ASSERT
- ASYMMETRIC
- AT
- ATOMIC
- ATTACH
- AUDIT
- AUTHENTICATION
- AUTHORIZATION
- AUTO
- AUTOINCREMENT
- AUTO_
INCREMENT - AVG
- AVRO
- BACKWARD
- BASE64
- BASE_
LOCATION - BEFORE
- BEGIN
- BEGIN_
FRAME - BEGIN_
PARTITION - BERNOULLI
- BETWEEN
- BIGDECIMAL
- BIGINT
- BIGNUMERIC
- BINARY
- BIND
- BINDING
- BIT
- BLOB
- BLOCK
- BLOOM
- BLOOMFILTER
- BOOL
- BOOLEAN
- BOTH
- BOX
- BRIN
- BROWSE
- BTREE
- BUCKET
- BUCKETS
- BY
- BYPASSRLS
- BYTEA
- BYTES
- CACHE
- CALL
- CALLED
- CARDINALITY
- CASCADE
- CASCADED
- CASE
- CASES
- CAST
- CATALOG
- CATALOG_
SYNC - CATCH
- CEIL
- CEILING
- CENTURY
- CHAIN
- CHANGE
- CHANGE_
TRACKING - CHANNEL
- CHAR
- CHARACTER
- CHARACTERISTICS
- CHARACTERS
- CHARACTER_
LENGTH - CHARSET
- CHAR_
LENGTH - CHECK
- CIRCLE
- CLEAR
- CLOB
- CLONE
- CLOSE
- CLUSTER
- CLUSTERED
- CLUSTERING
- COALESCE
- COLLATE
- COLLATION
- COLLECT
- COLLECTION
- COLUMN
- COLUMNS
- COLUMNSTORE
- COMMENT
- COMMIT
- COMMITTED
- COMPATIBLE
- COMPRESSION
- COMPUTE
- CONCURRENTLY
- CONDITION
- CONFLICT
- CONNECT
- CONNECTION
- CONNECTOR
- CONNECT_
BY_ ROOT - CONSTRAINT
- CONTAINS
- CONTINUE
- CONVERT
- COPY
- COPY_
OPTIONS - CORR
- CORRESPONDING
- COUNT
- COVAR_
POP - COVAR_
SAMP - CREATE
- CREATEDB
- CREATEROLE
- CREDENTIALS
- CROSS
- CSV
- CUBE
- CUME_
DIST - CURRENT
- CURRENT_
CATALOG - CURRENT_
DATE - CURRENT_
DEFAULT_ TRANSFORM_ GROUP - CURRENT_
PATH - CURRENT_
ROLE - CURRENT_
ROW - CURRENT_
SCHEMA - CURRENT_
TIME - CURRENT_
TIMESTAMP - CURRENT_
TRANSFORM_ GROUP_ FOR_ TYPE - CURRENT_
USER - CURSOR
- CYCLE
- DATA
- DATABASE
- DATABASES
- DATA_
RETENTION_ TIME_ IN_ DAYS - DATE
- DATE32
- DATETIME
- DATETIM
E64 - DAY
- DAYOFWEEK
- DAYOFYEAR
- DAYS
- DCPROPERTIES
- DEALLOCATE
- DEC
- DECADE
- DECIMAL
- DECLARE
- DEDUPLICATE
- DEFAULT
- DEFAULT_
DDL_ COLLATION - DEFERRABLE
- DEFERRED
- DEFINE
- DEFINED
- DEFINER
- DELAYED
- DELETE
- DELIMITED
- DELIMITER
- DELTA
- DENSE_
RANK - DEREF
- DESC
- DESCRIBE
- DETACH
- DETAIL
- DETERMINISTIC
- DIRECTORY
- DISABLE
- DISCARD
- DISCONNECT
- DISTINCT
- DISTRIBUTE
- DIV
- DO
- DOUBLE
- DOW
- DOY
- DROP
- DRY
- DUPLICATE
- DYNAMIC
- EACH
- ELEMENT
- ELEMENTS
- ELSE
- ELSEIF
- EMPTY
- ENABLE
- ENABLE_
SCHEMA_ EVOLUTION - ENCODING
- ENCRYPTION
- END
- ENDPOINT
- END_
EXEC - END_
FRAME - END_
PARTITION - ENFORCED
- ENGINE
- ENUM
- ENUM8
- ENUM16
- EPHEMERAL
- EPOCH
- EQUALS
- ERROR
- ESCAPE
- ESCAPED
- ESTIMATE
- EVENT
- EVERY
- EVOLVE
- EXCEPT
- EXCEPTION
- EXCHANGE
- EXCLUDE
- EXCLUSIVE
- EXEC
- EXECUTE
- EXECUTION
- EXISTS
- EXP
- EXPANSION
- EXPLAIN
- EXPLICIT
- EXPORT
- EXTENDED
- EXTENSION
- EXTERNAL
- EXTERNAL_
VOLUME - EXTRACT
- FAIL
- FAILOVER
- FALSE
- FETCH
- FIELDS
- FILE
- FILES
- FILE_
FORMAT - FILL
- FILTER
- FINAL
- FIRST
- FIRST_
VALUE - FIXEDSTRING
- FLOAT
- FLOAT4
- FLOAT8
- FLOAT32
- FLOAT64
- FLOOR
- FLUSH
- FN
- FOLLOWING
- FOR
- FORCE
- FORCE_
NOT_ NULL - FORCE_
NULL - FORCE_
QUOTE - FOREIGN
- FORMAT
- FORMATTED
- FORWARD
- FRAME_
ROW - FREE
- FREEZE
- FROM
- FSCK
- FULFILLMENT
- FULL
- FULLTEXT
- FUNCTION
- FUNCTIONS
- FUSION
- GENERAL
- GENERATE
- GENERATED
- GEOGRAPHY
- GET
- GIN
- GIST
- GLOBAL
- GRANT
- GRANTED
- GRANTS
- GRAPHVIZ
- GROUP
- GROUPING
- GROUPS
- HASH
- HAVING
- HEADER
- HEAP
- HIGH_
PRIORITY - HISTORY
- HIVEVAR
- HOLD
- HOSTS
- HOUR
- HOURS
- HUGEINT
- ICEBERG
- ID
- IDENTITY
- IDENTITY_
INSERT - IF
- IGNORE
- ILIKE
- IMMEDIATE
- IMMUTABLE
- IMPORT
- IMPORTED
- IN
- INCLUDE
- INCLUDE_
NULL_ VALUES - INCREMENT
- INDEX
- INDICATOR
- INHERIT
- INHERITS
- INITIALLY
- INNER
- INOUT
- INPATH
- INPLACE
- INPUT
- INPUTFORMAT
- INSENSITIVE
- INSERT
- INSTALL
- INSTANT
- INSTEAD
- INT
- INT2
- INT4
- INT8
- INT16
- INT32
- INT64
- INT128
- INT256
- INTEGER
- INTEGRATION
- INTERPOLATE
- INTERSECT
- INTERSECTION
- INTERVAL
- INTO
- INVOKER
- IO
- IS
- ISODOW
- ISOLATION
- ISOWEEK
- ISOYEAR
- ITEMS
- JAR
- JOIN
- JSON
- JSONB
- JSONFILE
- JSON_
TABLE - JULIAN
- KEY
- KEYS
- KILL
- LAG
- LANGUAGE
- LARGE
- LAST
- LAST_
VALUE - LATERAL
- LEAD
- LEADING
- LEFT
- LEVEL
- LIKE
- LIKE_
REGEX - LIMIT
- LINE
- LINES
- LIST
- LISTEN
- LISTING
- LN
- LOAD
- LOCAL
- LOCALTIME
- LOCALTIMESTAMP
- LOCATION
- LOCK
- LOCKED
- LOG
- LOGIN
- LOGS
- LONGBLOB
- LONGTEXT
- LOWCARDINALITY
- LOWER
- LOW_
PRIORITY - LS
- LSEG
- MACRO
- MANAGE
- MANAGED
- MANAGEDLOCATION
- MAP
- MASKING
- MATCH
- MATCHED
- MATCHES
- MATCH_
CONDITION - MATCH_
RECOGNIZE - MATERIALIZE
- MATERIALIZED
- MAX
- MAXVALUE
- MAX_
DATA_ EXTENSION_ TIME_ IN_ DAYS - MEASURES
- MEDIUMBLOB
- MEDIUMINT
- MEDIUMTEXT
- MEMBER
- MERGE
- MESSAGE
- METADATA
- METHOD
- METRIC
- MICROSECOND
- MICROSECONDS
- MILLENIUM
- MILLENNIUM
- MILLISECOND
- MILLISECONDS
- MIN
- MINUS
- MINUTE
- MINUTES
- MINVALUE
- MOD
- MODE
- MODIFIES
- MODIFY
- MODULE
- MONITOR
- MONTH
- MONTHS
- MSCK
- MULTISET
- MUTATION
- NAME
- NAMES
- NANOSECOND
- NANOSECONDS
- NATIONAL
- NATURAL
- NCHAR
- NCLOB
- NESTED
- NETWORK
- NEW
- NEXT
- NFC
- NFD
- NFKC
- NFKD
- NO
- NOBYPASSRLS
- NOCREATEDB
- NOCREATEROLE
- NOINHERIT
- NOLOGIN
- NONE
- NOORDER
- NOREPLICATION
- NORMALIZE
- NORMALIZED
- NOSCAN
- NOSUPERUSER
- NOT
- NOTHING
- NOTIFY
- NOWAIT
- NO_
WRITE_ TO_ BINLOG - NTH_
VALUE - NTILE
- NULL
- NULLABLE
- NULLIF
- NULLS
- NUMERIC
- NVARCHAR
- OBJECT
- OBJECTS
- OCCURRENCES_
REGEX - OCTETS
- OCTET_
LENGTH - OF
- OFF
- OFFSET
- OFFSETS
- OLD
- OMIT
- ON
- ONE
- ONLY
- OPEN
- OPENJSON
- OPERATE
- OPERATOR
- OPTIMIZATION
- OPTIMIZE
- OPTIMIZED
- OPTIMIZER_
COSTS - OPTION
- OPTIONS
- OR
- ORC
- ORDER
- ORDINALITY
- ORGANIZATION
- OUT
- OUTER
- OUTPUT
- OUTPUTFORMAT
- OVER
- OVERFLOW
- OVERLAPS
- OVERLAY
- OVERRIDE
- OVERWRITE
- OWNED
- OWNER
- OWNERSHIP
- PACKAGE
- PACKAGES
- PARALLEL
- PARAMETER
- PARQUET
- PART
- PARTITION
- PARTITIONED
- PARTITIONS
- PASSING
- PASSWORD
- PAST
- PATH
- PATTERN
- PER
- PERCENT
- PERCENTILE_
CONT - PERCENTILE_
DISC - PERCENT_
RANK - PERIOD
- PERMISSIVE
- PERSISTENT
- PIVOT
- PLACING
- PLAN
- PLANS
- POINT
- POLICY
- POLYGON
- POOL
- PORTION
- POSITION
- POSITION_
REGEX - POWER
- PRAGMA
- PRECEDES
- PRECEDING
- PRECISION
- PREPARE
- PRESERVE
- PREWHERE
- PRIMARY
- PRIOR
- PRIVILEGES
- PROCEDURE
- PROFILE
- PROGRAM
- PROJECTION
- PUBLIC
- PURCHASE
- PURGE
- QUALIFY
- QUARTER
- QUERY
- QUOTE
- RAISE
- RAISERROR
- RANGE
- RANK
- RAW
- RCFILE
- READ
- READS
- READ_
ONLY - REAL
- RECLUSTER
- RECURSIVE
- REF
- REFERENCES
- REFERENCING
- REGCLASS
- REGEXP
- REGR_
AVGX - REGR_
AVGY - REGR_
COUNT - REGR_
INTERCEPT - REGR_R2
- REGR_
SLOPE - REGR_
SXX - REGR_
SXY - REGR_
SYY - RELATIVE
- RELAY
- RELEASE
- RELEASES
- REMOTE
- REMOVE
- RENAME
- REORG
- REPAIR
- REPEATABLE
- REPLACE
- REPLICA
- REPLICATE
- REPLICATION
- RESERVED_
FOR_ COLUMN_ ALIAS - Can’t be used as a column alias, so that
SELECT <expr> alias
can be parsed unambiguously without looking ahead. - RESERVED_
FOR_ IDENTIFIER - Global list of reserved keywords that cannot be parsed as identifiers
without special handling like quoting. Parser should call
Dialect::is_reserved_for_identifier
to allow for each dialect to customize the list. - RESERVED_
FOR_ TABLE_ ALIAS - These keywords can’t be used as a table alias, so that
FROM table_name alias
can be parsed unambiguously without looking ahead. - RESERVED_
FOR_ TABLE_ FACTOR - RESET
- RESOLVE
- RESOURCE
- RESPECT
- RESTART
- RESTRICT
- RESTRICTED
- RESTRICTIONS
- RESTRICTIVE
- RESULT
- RESULTSET
- RESUME
- RETAIN
- RETURN
- RETURNING
- RETURNS
- REVOKE
- RIGHT
- RLIKE
- RM
- ROLE
- ROLES
- ROLLBACK
- ROLLUP
- ROOT
- ROW
- ROWID
- ROWS
- ROW_
NUMBER - RULE
- RUN
- SAFE
- SAFE_
CAST - SAMPLE
- SAVEPOINT
- SCHEMA
- SCHEMAS
- SCOPE
- SCROLL
- SEARCH
- SECOND
- SECONDARY
- SECONDS
- SECRET
- SECURITY
- SEED
- SELECT
- SEMI
- SENSITIVE
- SEPARATOR
- SEQUENCE
- SEQUENCEFILE
- SEQUENCES
- SERDE
- SERDEPROPERTIES
- SERIALIZABLE
- SERVICE
- SESSION
- SESSION_
USER - SET
- SETERROR
- SETS
- SETTINGS
- SHARE
- SHARED
- SHARING
- SHOW
- SIGNED
- SIMILAR
- SKIP
- SLOW
- SMALLINT
- SNAPSHOT
- SOME
- SORT
- SORTED
- SOURCE
- SPATIAL
- SPECIFIC
- SPECIFICTYPE
- SPGIST
- SQL
- SQLEXCEPTION
- SQLSTATE
- SQLWARNING
- SQRT
- STABLE
- STAGE
- START
- STARTS
- STATEMENT
- STATIC
- STATISTICS
- STATUS
- STDDEV_
POP - STDDEV_
SAMP - STDIN
- STDOUT
- STEP
- STORAGE_
INTEGRATION - STORAGE_
SERIALIZATION_ POLICY - STORED
- STRAIGHT_
JOIN - STRICT
- STRING
- STRUCT
- SUBMULTISET
- SUBSTR
- SUBSTRING
- SUBSTRING_
REGEX - SUCCEEDS
- SUM
- SUPER
- SUPERUSER
- SUPPORT
- SUSPEND
- SWAP
- SYMMETRIC
- SYNC
- SYSTEM
- SYSTEM_
TIME - SYSTEM_
USER - TABLE
- TABLES
- TABLESAMPLE
- TAG
- TARGET
- TASK
- TBLPROPERTIES
- TEMP
- TEMPORARY
- TEMPTABLE
- TERMINATED
- TERSE
- TEXT
- TEXTFILE
- THEN
- TIES
- TIME
- TIMESTAMP
- TIMESTAMPTZ
- TIMESTAMP_
NTZ - TIMETZ
- TIMEZONE
- TIMEZONE_
ABBR - TIMEZONE_
HOUR - TIMEZONE_
MINUTE - TIMEZONE_
REGION - TINYBLOB
- TINYINT
- TINYTEXT
- TO
- TOP
- TOTALS
- TRACE
- TRAILING
- TRANSACTION
- TRANSIENT
- TRANSLATE
- TRANSLATE_
REGEX - TRANSLATION
- TREAT
- TRIGGER
- TRIM
- TRIM_
ARRAY - TRUE
- TRUNCATE
- TRY
- TRY_
CAST - TRY_
CONVERT - TUPLE
- TYPE
- UBIGINT
- UESCAPE
- UHUGEINT
- UINT8
- UINT16
- UINT32
- UINT64
- UINT128
- UINT256
- UNBOUNDED
- UNCACHE
- UNCOMMITTED
- UNDEFINED
- UNFREEZE
- UNION
- UNIQUE
- UNKNOWN
- UNLISTEN
- UNLOAD
- UNLOCK
- UNLOGGED
- UNMATCHED
- UNNEST
- UNPIVOT
- UNSAFE
- UNSET
- UNSIGNED
- UNTIL
- UPDATE
- UPPER
- URL
- USAGE
- USE
- USER
- USER_
RESOURCES - USING
- USMALLINT
- UTINYINT
- UUID
- VACUUM
- VALID
- VALIDATION_
MODE - VALUE
- VALUES
- VALUE_
OF - VARBINARY
- VARBIT
- VARCHAR
- VARIABLES
- VARYING
- VAR_POP
- VAR_
SAMP - VERBOSE
- VERSION
- VERSIONING
- VERSIONS
- VIEW
- VIEWS
- VIRTUAL
- VOLATILE
- VOLUME
- WAREHOUSE
- WAREHOUSES
- WEEK
- WEEKS
- WHEN
- WHENEVER
- WHERE
- WIDTH_
BUCKET - WINDOW
- WITH
- WITHIN
- WITHOUT
- WITHOUT_
ARRAY_ WRAPPER - WORK
- WRITE
- XML
- XMLNAMESPACES
- XMLTABLE
- XOR
- YEAR
- YEARS
- ZONE
- ZORDER