begriffs open source - ai-pg/blob - full-docs/txt/sql-keywords-appendix.txt

   1
   2 Appendix C. SQL Key Words
   3
   4    Table C.1 lists all tokens that are key words in the SQL standard and
   5    in PostgreSQL 18.0. Background information can be found in
   6    Section 4.1.1. (For space reasons, only the latest two versions of the
   7    SQL standard, and SQL-92 for historical comparison, are included. The
   8    differences between those and the other intermediate standard versions
   9    are small.)
  10
  11    SQL distinguishes between reserved and non-reserved key words.
  12    According to the standard, reserved key words are the only real key
  13    words; they are never allowed as identifiers. Non-reserved key words
  14    only have a special meaning in particular contexts and can be used as
  15    identifiers in other contexts. Most non-reserved key words are actually
  16    the names of built-in tables and functions specified by SQL. The
  17    concept of non-reserved key words essentially only exists to declare
  18    that some predefined meaning is attached to a word in some contexts.
  19
  20    In the PostgreSQL parser, life is a bit more complicated. There are
  21    several different classes of tokens ranging from those that can never
  22    be used as an identifier to those that have absolutely no special
  23    status in the parser, but are considered ordinary identifiers. (The
  24    latter is usually the case for functions specified by SQL.) Even
  25    reserved key words are not completely reserved in PostgreSQL, but can
  26    be used as column labels (for example, SELECT 55 AS CHECK, even though
  27    CHECK is a reserved key word).
  28
  29    In Table C.1 in the column for PostgreSQL we classify as “non-reserved”
  30    those key words that are explicitly known to the parser but are allowed
  31    as column or table names. Some key words that are otherwise
  32    non-reserved cannot be used as function or data type names and are
  33    marked accordingly. (Most of these words represent built-in functions
  34    or data types with special syntax. The function or type is still
  35    available but it cannot be redefined by the user.) Labeled “reserved”
  36    are those tokens that are not allowed as column or table names. Some
  37    reserved key words are allowable as names for functions or data types;
  38    this is also shown in the table. If not so marked, a reserved key word
  39    is only allowed as a column label. A blank entry in this column means
  40    that the word is treated as an ordinary identifier by PostgreSQL.
  41
  42    Furthermore, while most key words can be used as “bare” column labels
  43    without writing AS before them (as described in Section 7.3.2), there
  44    are a few that require a leading AS to avoid ambiguity. These are
  45    marked in the table as “requires AS”.
  46
  47    As a general rule, if you get spurious parser errors for commands that
  48    use any of the listed key words as an identifier, you should try
  49    quoting the identifier to see if the problem goes away.
  50
  51    It is important to understand before studying Table C.1 that the fact
  52    that a key word is not reserved in PostgreSQL does not mean that the
  53    feature related to the word is not implemented. Conversely, the
  54    presence of a key word does not indicate the existence of a feature.
  55
  56    Table C.1. SQL Key Words
  57    Key Word PostgreSQL SQL:2023 SQL:2016 SQL-92
  58    A   non-reserved non-reserved
  59    ABORT non-reserved
  60    ABS   reserved reserved
  61    ABSENT non-reserved reserved reserved
  62    ABSOLUTE non-reserved non-reserved non-reserved reserved
  63    ACCESS non-reserved
  64    ACCORDING   non-reserved non-reserved
  65    ACOS   reserved reserved
  66    ACTION non-reserved non-reserved non-reserved reserved
  67    ADA   non-reserved non-reserved non-reserved
  68    ADD non-reserved non-reserved non-reserved reserved
  69    ADMIN non-reserved non-reserved non-reserved
  70    AFTER non-reserved non-reserved non-reserved
  71    AGGREGATE non-reserved
  72    ALL reserved reserved reserved reserved
  73    ALLOCATE   reserved reserved reserved
  74    ALSO non-reserved
  75    ALTER non-reserved reserved reserved reserved
  76    ALWAYS non-reserved non-reserved non-reserved
  77    ANALYSE reserved
  78    ANALYZE reserved
  79    AND reserved reserved reserved reserved
  80    ANY reserved reserved reserved reserved
  81    ANY_VALUE   reserved
  82    ARE   reserved reserved reserved
  83    ARRAY reserved, requires AS reserved reserved
  84    ARRAY_AGG   reserved reserved
  85    ARRAY_MAX_CARDINALITY   reserved reserved
  86    AS reserved, requires AS reserved reserved reserved
  87    ASC reserved non-reserved non-reserved reserved
  88    ASENSITIVE non-reserved reserved reserved
  89    ASIN   reserved reserved
  90    ASSERTION non-reserved non-reserved non-reserved reserved
  91    ASSIGNMENT non-reserved non-reserved non-reserved
  92    ASYMMETRIC reserved reserved reserved
  93    AT non-reserved reserved reserved reserved
  94    ATAN   reserved reserved
  95    ATOMIC non-reserved reserved reserved
  96    ATTACH non-reserved
  97    ATTRIBUTE non-reserved non-reserved non-reserved
  98    ATTRIBUTES   non-reserved non-reserved
  99    AUTHORIZATION reserved (can be function or type) reserved reserved
 100    reserved
 101    AVG   reserved reserved reserved
 102    BACKWARD non-reserved
 103    BASE64   non-reserved non-reserved
 104    BEFORE non-reserved non-reserved non-reserved
 105    BEGIN non-reserved reserved reserved reserved
 106    BEGIN_FRAME   reserved reserved
 107    BEGIN_PARTITION   reserved reserved
 108    BERNOULLI   non-reserved non-reserved
 109    BETWEEN non-reserved (cannot be function or type) reserved reserved
 110    reserved
 111    BIGINT non-reserved (cannot be function or type) reserved reserved
 112    BINARY reserved (can be function or type) reserved reserved
 113    BIT non-reserved (cannot be function or type)     reserved
 114    BIT_LENGTH       reserved
 115    BLOB   reserved reserved
 116    BLOCKED   non-reserved non-reserved
 117    BOM   non-reserved non-reserved
 118    BOOLEAN non-reserved (cannot be function or type) reserved reserved
 119    BOTH reserved reserved reserved reserved
 120    BREADTH non-reserved non-reserved non-reserved
 121    BTRIM   reserved
 122    BY non-reserved reserved reserved reserved
 123    C   non-reserved non-reserved non-reserved
 124    CACHE non-reserved
 125    CALL non-reserved reserved reserved
 126    CALLED non-reserved reserved reserved
 127    CARDINALITY   reserved reserved
 128    CASCADE non-reserved non-reserved non-reserved reserved
 129    CASCADED non-reserved reserved reserved reserved
 130    CASE reserved reserved reserved reserved
 131    CAST reserved reserved reserved reserved
 132    CATALOG non-reserved non-reserved non-reserved reserved
 133    CATALOG_NAME   non-reserved non-reserved non-reserved
 134    CEIL   reserved reserved
 135    CEILING   reserved reserved
 136    CHAIN non-reserved non-reserved non-reserved
 137    CHAINING   non-reserved non-reserved
 138    CHAR non-reserved (cannot be function or type), requires AS reserved
 139    reserved reserved
 140    CHARACTER non-reserved (cannot be function or type), requires AS
 141    reserved reserved reserved
 142    CHARACTERISTICS non-reserved non-reserved non-reserved
 143    CHARACTERS   non-reserved non-reserved
 144    CHARACTER_LENGTH   reserved reserved reserved
 145    CHARACTER_SET_CATALOG   non-reserved non-reserved non-reserved
 146    CHARACTER_SET_NAME   non-reserved non-reserved non-reserved
 147    CHARACTER_SET_SCHEMA   non-reserved non-reserved non-reserved
 148    CHAR_LENGTH   reserved reserved reserved
 149    CHECK reserved reserved reserved reserved
 150    CHECKPOINT non-reserved
 151    CLASS non-reserved
 152    CLASSIFIER   reserved reserved
 153    CLASS_ORIGIN   non-reserved non-reserved non-reserved
 154    CLOB   reserved reserved
 155    CLOSE non-reserved reserved reserved reserved
 156    CLUSTER non-reserved
 157    COALESCE non-reserved (cannot be function or type) reserved reserved
 158    reserved
 159    COBOL   non-reserved non-reserved non-reserved
 160    COLLATE reserved reserved reserved reserved
 161    COLLATION reserved (can be function or type) non-reserved non-reserved
 162    reserved
 163    COLLATION_CATALOG   non-reserved non-reserved non-reserved
 164    COLLATION_NAME   non-reserved non-reserved non-reserved
 165    COLLATION_SCHEMA   non-reserved non-reserved non-reserved
 166    COLLECT   reserved reserved
 167    COLUMN reserved reserved reserved reserved
 168    COLUMNS non-reserved non-reserved non-reserved
 169    COLUMN_NAME   non-reserved non-reserved non-reserved
 170    COMMAND_FUNCTION   non-reserved non-reserved non-reserved
 171    COMMAND_FUNCTION_CODE   non-reserved non-reserved
 172    COMMENT non-reserved
 173    COMMENTS non-reserved
 174    COMMIT non-reserved reserved reserved reserved
 175    COMMITTED non-reserved non-reserved non-reserved non-reserved
 176    COMPRESSION non-reserved
 177    CONCURRENTLY reserved (can be function or type)
 178    CONDITION   reserved reserved
 179    CONDITIONAL non-reserved non-reserved non-reserved
 180    CONDITION_NUMBER   non-reserved non-reserved non-reserved
 181    CONFIGURATION non-reserved
 182    CONFLICT non-reserved
 183    CONNECT   reserved reserved reserved
 184    CONNECTION non-reserved non-reserved non-reserved reserved
 185    CONNECTION_NAME   non-reserved non-reserved non-reserved
 186    CONSTRAINT reserved reserved reserved reserved
 187    CONSTRAINTS non-reserved non-reserved non-reserved reserved
 188    CONSTRAINT_CATALOG   non-reserved non-reserved non-reserved
 189    CONSTRAINT_NAME   non-reserved non-reserved non-reserved
 190    CONSTRAINT_SCHEMA   non-reserved non-reserved non-reserved
 191    CONSTRUCTOR   non-reserved non-reserved
 192    CONTAINS   reserved reserved
 193    CONTENT non-reserved non-reserved non-reserved
 194    CONTINUE non-reserved non-reserved non-reserved reserved
 195    CONTROL   non-reserved non-reserved
 196    CONVERSION non-reserved
 197    CONVERT   reserved reserved reserved
 198    COPARTITION   non-reserved
 199    COPY non-reserved reserved reserved
 200    CORR   reserved reserved
 201    CORRESPONDING   reserved reserved reserved
 202    COS   reserved reserved
 203    COSH   reserved reserved
 204    COST non-reserved
 205    COUNT   reserved reserved reserved
 206    COVAR_POP   reserved reserved
 207    COVAR_SAMP   reserved reserved
 208    CREATE reserved, requires AS reserved reserved reserved
 209    CROSS reserved (can be function or type) reserved reserved reserved
 210    CSV non-reserved
 211    CUBE non-reserved reserved reserved
 212    CUME_DIST   reserved reserved
 213    CURRENT non-reserved reserved reserved reserved
 214    CURRENT_CATALOG reserved reserved reserved
 215    CURRENT_DATE reserved reserved reserved reserved
 216    CURRENT_DEFAULT_TRANSFORM_GROUP   reserved reserved
 217    CURRENT_PATH   reserved reserved
 218    CURRENT_ROLE reserved reserved reserved
 219    CURRENT_ROW   reserved reserved
 220    CURRENT_SCHEMA reserved (can be function or type) reserved reserved
 221    CURRENT_TIME reserved reserved reserved reserved
 222    CURRENT_TIMESTAMP reserved reserved reserved reserved
 223    CURRENT_TRANSFORM_GROUP_FOR_TYPE   reserved reserved
 224    CURRENT_USER reserved reserved reserved reserved
 225    CURSOR non-reserved reserved reserved reserved
 226    CURSOR_NAME   non-reserved non-reserved non-reserved
 227    CYCLE non-reserved reserved reserved
 228    DATA non-reserved non-reserved non-reserved non-reserved
 229    DATABASE non-reserved
 230    DATALINK   reserved reserved
 231    DATE   reserved reserved reserved
 232    DATETIME_INTERVAL_CODE   non-reserved non-reserved non-reserved
 233    DATETIME_INTERVAL_PRECISION   non-reserved non-reserved non-reserved
 234    DAY non-reserved, requires AS reserved reserved reserved
 235    DB   non-reserved non-reserved
 236    DEALLOCATE non-reserved reserved reserved reserved
 237    DEC non-reserved (cannot be function or type) reserved reserved
 238    reserved
 239    DECFLOAT   reserved reserved
 240    DECIMAL non-reserved (cannot be function or type) reserved reserved
 241    reserved
 242    DECLARE non-reserved reserved reserved reserved
 243    DEFAULT reserved reserved reserved reserved
 244    DEFAULTS non-reserved non-reserved non-reserved
 245    DEFERRABLE reserved non-reserved non-reserved reserved
 246    DEFERRED non-reserved non-reserved non-reserved reserved
 247    DEFINE   reserved reserved
 248    DEFINED   non-reserved non-reserved
 249    DEFINER non-reserved non-reserved non-reserved
 250    DEGREE   non-reserved non-reserved
 251    DELETE non-reserved reserved reserved reserved
 252    DELIMITER non-reserved
 253    DELIMITERS non-reserved
 254    DENSE_RANK   reserved reserved
 255    DEPENDS non-reserved
 256    DEPTH non-reserved non-reserved non-reserved
 257    DEREF   reserved reserved
 258    DERIVED   non-reserved non-reserved
 259    DESC reserved non-reserved non-reserved reserved
 260    DESCRIBE   reserved reserved reserved
 261    DESCRIPTOR   non-reserved non-reserved reserved
 262    DETACH non-reserved
 263    DETERMINISTIC   reserved reserved
 264    DIAGNOSTICS   non-reserved non-reserved reserved
 265    DICTIONARY non-reserved
 266    DISABLE non-reserved
 267    DISCARD non-reserved
 268    DISCONNECT   reserved reserved reserved
 269    DISPATCH   non-reserved non-reserved
 270    DISTINCT reserved reserved reserved reserved
 271    DLNEWCOPY   reserved reserved
 272    DLPREVIOUSCOPY   reserved reserved
 273    DLURLCOMPLETE   reserved reserved
 274    DLURLCOMPLETEONLY   reserved reserved
 275    DLURLCOMPLETEWRITE   reserved reserved
 276    DLURLPATH   reserved reserved
 277    DLURLPATHONLY   reserved reserved
 278    DLURLPATHWRITE   reserved reserved
 279    DLURLSCHEME   reserved reserved
 280    DLURLSERVER   reserved reserved
 281    DLVALUE   reserved reserved
 282    DO reserved
 283    DOCUMENT non-reserved non-reserved non-reserved
 284    DOMAIN non-reserved non-reserved non-reserved reserved
 285    DOUBLE non-reserved reserved reserved reserved
 286    DROP non-reserved reserved reserved reserved
 287    DYNAMIC   reserved reserved
 288    DYNAMIC_FUNCTION   non-reserved non-reserved non-reserved
 289    DYNAMIC_FUNCTION_CODE   non-reserved non-reserved
 290    EACH non-reserved reserved reserved
 291    ELEMENT   reserved reserved
 292    ELSE reserved reserved reserved reserved
 293    EMPTY non-reserved reserved reserved
 294    ENABLE non-reserved
 295    ENCODING non-reserved non-reserved non-reserved
 296    ENCRYPTED non-reserved
 297    END reserved reserved reserved reserved
 298    END-EXEC   reserved reserved reserved
 299    END_FRAME   reserved reserved
 300    END_PARTITION   reserved reserved
 301    ENFORCED non-reserved non-reserved non-reserved
 302    ENUM non-reserved
 303    EQUALS   reserved reserved
 304    ERROR non-reserved non-reserved non-reserved
 305    ESCAPE non-reserved reserved reserved reserved
 306    EVENT non-reserved
 307    EVERY   reserved reserved
 308    EXCEPT reserved, requires AS reserved reserved reserved
 309    EXCEPTION       reserved
 310    EXCLUDE non-reserved non-reserved non-reserved
 311    EXCLUDING non-reserved non-reserved non-reserved
 312    EXCLUSIVE non-reserved
 313    EXEC   reserved reserved reserved
 314    EXECUTE non-reserved reserved reserved reserved
 315    EXISTS non-reserved (cannot be function or type) reserved reserved
 316    reserved
 317    EXP   reserved reserved
 318    EXPLAIN non-reserved
 319    EXPRESSION non-reserved non-reserved non-reserved
 320    EXTENSION non-reserved
 321    EXTERNAL non-reserved reserved reserved reserved
 322    EXTRACT non-reserved (cannot be function or type) reserved reserved
 323    reserved
 324    FALSE reserved reserved reserved reserved
 325    FAMILY non-reserved
 326    FETCH reserved, requires AS reserved reserved reserved
 327    FILE   non-reserved non-reserved
 328    FILTER non-reserved, requires AS reserved reserved
 329    FINAL   non-reserved non-reserved
 330    FINALIZE non-reserved
 331    FINISH   non-reserved non-reserved
 332    FIRST non-reserved non-reserved non-reserved reserved
 333    FIRST_VALUE   reserved reserved
 334    FLAG   non-reserved non-reserved
 335    FLOAT non-reserved (cannot be function or type) reserved reserved
 336    reserved
 337    FLOOR   reserved reserved
 338    FOLLOWING non-reserved non-reserved non-reserved
 339    FOR reserved, requires AS reserved reserved reserved
 340    FORCE non-reserved
 341    FOREIGN reserved reserved reserved reserved
 342    FORMAT non-reserved non-reserved non-reserved
 343    FORTRAN   non-reserved non-reserved non-reserved
 344    FORWARD non-reserved
 345    FOUND   non-reserved non-reserved reserved
 346    FRAME_ROW   reserved reserved
 347    FREE   reserved reserved
 348    FREEZE reserved (can be function or type)
 349    FROM reserved, requires AS reserved reserved reserved
 350    FS   non-reserved non-reserved
 351    FULFILL   non-reserved non-reserved
 352    FULL reserved (can be function or type) reserved reserved reserved
 353    FUNCTION non-reserved reserved reserved
 354    FUNCTIONS non-reserved
 355    FUSION   reserved reserved
 356    G   non-reserved non-reserved
 357    GENERAL   non-reserved non-reserved
 358    GENERATED non-reserved non-reserved non-reserved
 359    GET   reserved reserved reserved
 360    GLOBAL non-reserved reserved reserved reserved
 361    GO   non-reserved non-reserved reserved
 362    GOTO   non-reserved non-reserved reserved
 363    GRANT reserved, requires AS reserved reserved reserved
 364    GRANTED non-reserved non-reserved non-reserved
 365    GREATEST non-reserved (cannot be function or type) reserved
 366    GROUP reserved, requires AS reserved reserved reserved
 367    GROUPING non-reserved (cannot be function or type) reserved reserved
 368    GROUPS non-reserved reserved reserved
 369    HANDLER non-reserved
 370    HAVING reserved, requires AS reserved reserved reserved
 371    HEADER non-reserved
 372    HEX   non-reserved non-reserved
 373    HIERARCHY   non-reserved non-reserved
 374    HOLD non-reserved reserved reserved
 375    HOUR non-reserved, requires AS reserved reserved reserved
 376    ID   non-reserved non-reserved
 377    IDENTITY non-reserved reserved reserved reserved
 378    IF non-reserved
 379    IGNORE   non-reserved non-reserved
 380    ILIKE reserved (can be function or type)
 381    IMMEDIATE non-reserved non-reserved non-reserved reserved
 382    IMMEDIATELY   non-reserved non-reserved
 383    IMMUTABLE non-reserved
 384    IMPLEMENTATION   non-reserved non-reserved
 385    IMPLICIT non-reserved
 386    IMPORT non-reserved reserved reserved
 387    IN reserved reserved reserved reserved
 388    INCLUDE non-reserved
 389    INCLUDING non-reserved non-reserved non-reserved
 390    INCREMENT non-reserved non-reserved non-reserved
 391    INDENT non-reserved non-reserved non-reserved
 392    INDEX non-reserved
 393    INDEXES non-reserved
 394    INDICATOR   reserved reserved reserved
 395    INHERIT non-reserved
 396    INHERITS non-reserved
 397    INITIAL   reserved reserved
 398    INITIALLY reserved non-reserved non-reserved reserved
 399    INLINE non-reserved
 400    INNER reserved (can be function or type) reserved reserved reserved
 401    INOUT non-reserved (cannot be function or type) reserved reserved
 402    INPUT non-reserved non-reserved non-reserved reserved
 403    INSENSITIVE non-reserved reserved reserved reserved
 404    INSERT non-reserved reserved reserved reserved
 405    INSTANCE   non-reserved non-reserved
 406    INSTANTIABLE   non-reserved non-reserved
 407    INSTEAD non-reserved non-reserved non-reserved
 408    INT non-reserved (cannot be function or type) reserved reserved
 409    reserved
 410    INTEGER non-reserved (cannot be function or type) reserved reserved
 411    reserved
 412    INTEGRITY   non-reserved non-reserved
 413    INTERSECT reserved, requires AS reserved reserved reserved
 414    INTERSECTION   reserved reserved
 415    INTERVAL non-reserved (cannot be function or type) reserved reserved
 416    reserved
 417    INTO reserved, requires AS reserved reserved reserved
 418    INVOKER non-reserved non-reserved non-reserved
 419    IS reserved (can be function or type) reserved reserved reserved
 420    ISNULL reserved (can be function or type), requires AS
 421    ISOLATION non-reserved non-reserved non-reserved reserved
 422    JOIN reserved (can be function or type) reserved reserved reserved
 423    JSON non-reserved (cannot be function or type) reserved
 424    JSON_ARRAY non-reserved (cannot be function or type) reserved reserved
 425
 426    JSON_ARRAYAGG non-reserved (cannot be function or type) reserved
 427    reserved
 428    JSON_EXISTS non-reserved (cannot be function or type) reserved reserved
 429
 430    JSON_OBJECT non-reserved (cannot be function or type) reserved reserved
 431
 432    JSON_OBJECTAGG non-reserved (cannot be function or type) reserved
 433    reserved
 434    JSON_QUERY non-reserved (cannot be function or type) reserved reserved
 435
 436    JSON_SCALAR non-reserved (cannot be function or type) reserved
 437    JSON_SERIALIZE non-reserved (cannot be function or type) reserved
 438    JSON_TABLE non-reserved (cannot be function or type) reserved reserved
 439
 440    JSON_TABLE_PRIMITIVE   reserved reserved
 441    JSON_VALUE non-reserved (cannot be function or type) reserved reserved
 442
 443    K   non-reserved non-reserved
 444    KEEP non-reserved non-reserved non-reserved
 445    KEY non-reserved non-reserved non-reserved reserved
 446    KEYS non-reserved non-reserved non-reserved
 447    KEY_MEMBER   non-reserved non-reserved
 448    KEY_TYPE   non-reserved non-reserved
 449    LABEL non-reserved
 450    LAG   reserved reserved
 451    LANGUAGE non-reserved reserved reserved reserved
 452    LARGE non-reserved reserved reserved
 453    LAST non-reserved non-reserved non-reserved reserved
 454    LAST_VALUE   reserved reserved
 455    LATERAL reserved reserved reserved
 456    LEAD   reserved reserved
 457    LEADING reserved reserved reserved reserved
 458    LEAKPROOF non-reserved
 459    LEAST non-reserved (cannot be function or type) reserved
 460    LEFT reserved (can be function or type) reserved reserved reserved
 461    LENGTH   non-reserved non-reserved non-reserved
 462    LEVEL non-reserved non-reserved non-reserved reserved
 463    LIBRARY   non-reserved non-reserved
 464    LIKE reserved (can be function or type) reserved reserved reserved
 465    LIKE_REGEX   reserved reserved
 466    LIMIT reserved, requires AS non-reserved non-reserved
 467    LINK   non-reserved non-reserved
 468    LISTAGG   reserved reserved
 469    LISTEN non-reserved
 470    LN   reserved reserved
 471    LOAD non-reserved
 472    LOCAL non-reserved reserved reserved reserved
 473    LOCALTIME reserved reserved reserved
 474    LOCALTIMESTAMP reserved reserved reserved
 475    LOCATION non-reserved non-reserved non-reserved
 476    LOCATOR   non-reserved non-reserved
 477    LOCK non-reserved
 478    LOCKED non-reserved
 479    LOG   reserved reserved
 480    LOG10   reserved reserved
 481    LOGGED non-reserved
 482    LOWER   reserved reserved reserved
 483    LPAD   reserved
 484    LTRIM   reserved
 485    M   non-reserved non-reserved
 486    MAP   non-reserved non-reserved
 487    MAPPING non-reserved non-reserved non-reserved
 488    MATCH non-reserved reserved reserved reserved
 489    MATCHED non-reserved non-reserved non-reserved
 490    MATCHES   reserved reserved
 491    MATCH_NUMBER   reserved reserved
 492    MATCH_RECOGNIZE   reserved reserved
 493    MATERIALIZED non-reserved
 494    MAX   reserved reserved reserved
 495    MAXVALUE non-reserved non-reserved non-reserved
 496    MEASURES   non-reserved non-reserved
 497    MEMBER   reserved reserved
 498    MERGE non-reserved reserved reserved
 499    MERGE_ACTION non-reserved (cannot be function or type)
 500    MESSAGE_LENGTH   non-reserved non-reserved non-reserved
 501    MESSAGE_OCTET_LENGTH   non-reserved non-reserved non-reserved
 502    MESSAGE_TEXT   non-reserved non-reserved non-reserved
 503    METHOD non-reserved reserved reserved
 504    MIN   reserved reserved reserved
 505    MINUTE non-reserved, requires AS reserved reserved reserved
 506    MINVALUE non-reserved non-reserved non-reserved
 507    MOD   reserved reserved
 508    MODE non-reserved
 509    MODIFIES   reserved reserved
 510    MODULE   reserved reserved reserved
 511    MONTH non-reserved, requires AS reserved reserved reserved
 512    MORE   non-reserved non-reserved non-reserved
 513    MOVE non-reserved
 514    MULTISET   reserved reserved
 515    MUMPS   non-reserved non-reserved non-reserved
 516    NAME non-reserved non-reserved non-reserved non-reserved
 517    NAMES non-reserved non-reserved non-reserved reserved
 518    NAMESPACE   non-reserved non-reserved
 519    NATIONAL non-reserved (cannot be function or type) reserved reserved
 520    reserved
 521    NATURAL reserved (can be function or type) reserved reserved reserved
 522    NCHAR non-reserved (cannot be function or type) reserved reserved
 523    reserved
 524    NCLOB   reserved reserved
 525    NESTED non-reserved non-reserved non-reserved
 526    NESTING   non-reserved non-reserved
 527    NEW non-reserved reserved reserved
 528    NEXT non-reserved non-reserved non-reserved reserved
 529    NFC non-reserved non-reserved non-reserved
 530    NFD non-reserved non-reserved non-reserved
 531    NFKC non-reserved non-reserved non-reserved
 532    NFKD non-reserved non-reserved non-reserved
 533    NIL   non-reserved non-reserved
 534    NO non-reserved reserved reserved reserved
 535    NONE non-reserved (cannot be function or type) reserved reserved
 536    NORMALIZE non-reserved (cannot be function or type) reserved reserved
 537    NORMALIZED non-reserved non-reserved non-reserved
 538    NOT reserved reserved reserved reserved
 539    NOTHING non-reserved
 540    NOTIFY non-reserved
 541    NOTNULL reserved (can be function or type), requires AS
 542    NOWAIT non-reserved
 543    NTH_VALUE   reserved reserved
 544    NTILE   reserved reserved
 545    NULL reserved reserved reserved reserved
 546    NULLABLE   non-reserved non-reserved non-reserved
 547    NULLIF non-reserved (cannot be function or type) reserved reserved
 548    reserved
 549    NULLS non-reserved non-reserved non-reserved
 550    NULL_ORDERING   non-reserved non-reserved
 551    NUMBER   non-reserved non-reserved non-reserved
 552    NUMERIC non-reserved (cannot be function or type) reserved reserved
 553    reserved
 554    OBJECT non-reserved non-reserved non-reserved
 555    OBJECTS non-reserved
 556    OCCURRENCE   non-reserved non-reserved
 557    OCCURRENCES_REGEX   reserved reserved
 558    OCTETS   non-reserved non-reserved
 559    OCTET_LENGTH   reserved reserved reserved
 560    OF non-reserved reserved reserved reserved
 561    OFF non-reserved non-reserved non-reserved
 562    OFFSET reserved, requires AS reserved reserved
 563    OIDS non-reserved
 564    OLD non-reserved reserved reserved
 565    OMIT non-reserved reserved reserved
 566    ON reserved, requires AS reserved reserved reserved
 567    ONE   reserved reserved
 568    ONLY reserved reserved reserved reserved
 569    OPEN   reserved reserved reserved
 570    OPERATOR non-reserved
 571    OPTION non-reserved non-reserved non-reserved reserved
 572    OPTIONS non-reserved non-reserved non-reserved
 573    OR reserved reserved reserved reserved
 574    ORDER reserved, requires AS reserved reserved reserved
 575    ORDERING   non-reserved non-reserved
 576    ORDINALITY non-reserved non-reserved non-reserved
 577    OTHERS non-reserved non-reserved non-reserved
 578    OUT non-reserved (cannot be function or type) reserved reserved
 579    OUTER reserved (can be function or type) reserved reserved reserved
 580    OUTPUT   non-reserved non-reserved reserved
 581    OVER non-reserved, requires AS reserved reserved
 582    OVERFLOW   non-reserved non-reserved
 583    OVERLAPS reserved (can be function or type), requires AS reserved
 584    reserved reserved
 585    OVERLAY non-reserved (cannot be function or type) reserved reserved
 586    OVERRIDING non-reserved non-reserved non-reserved
 587    OWNED non-reserved
 588    OWNER non-reserved
 589    P   non-reserved non-reserved
 590    PAD   non-reserved non-reserved reserved
 591    PARALLEL non-reserved
 592    PARAMETER non-reserved reserved reserved
 593    PARAMETER_MODE   non-reserved non-reserved
 594    PARAMETER_NAME   non-reserved non-reserved
 595    PARAMETER_ORDINAL_POSITION   non-reserved non-reserved
 596    PARAMETER_SPECIFIC_CATALOG   non-reserved non-reserved
 597    PARAMETER_SPECIFIC_NAME   non-reserved non-reserved
 598    PARAMETER_SPECIFIC_SCHEMA   non-reserved non-reserved
 599    PARSER non-reserved
 600    PARTIAL non-reserved non-reserved non-reserved reserved
 601    PARTITION non-reserved reserved reserved
 602    PASCAL   non-reserved non-reserved non-reserved
 603    PASS   non-reserved non-reserved
 604    PASSING non-reserved non-reserved non-reserved
 605    PASSTHROUGH   non-reserved non-reserved
 606    PASSWORD non-reserved
 607    PAST   non-reserved non-reserved
 608    PATH non-reserved non-reserved non-reserved
 609    PATTERN   reserved reserved
 610    PER   reserved reserved
 611    PERCENT   reserved reserved
 612    PERCENTILE_CONT   reserved reserved
 613    PERCENTILE_DISC   reserved reserved
 614    PERCENT_RANK   reserved reserved
 615    PERIOD non-reserved reserved reserved
 616    PERMISSION   non-reserved non-reserved
 617    PERMUTE   non-reserved non-reserved
 618    PIPE   non-reserved non-reserved
 619    PLACING reserved non-reserved non-reserved
 620    PLAN non-reserved non-reserved non-reserved
 621    PLANS non-reserved
 622    PLI   non-reserved non-reserved non-reserved
 623    POLICY non-reserved
 624    PORTION   reserved reserved
 625    POSITION non-reserved (cannot be function or type) reserved reserved
 626    reserved
 627    POSITION_REGEX   reserved reserved
 628    POWER   reserved reserved
 629    PRECEDES   reserved reserved
 630    PRECEDING non-reserved non-reserved non-reserved
 631    PRECISION non-reserved (cannot be function or type), requires AS
 632    reserved reserved reserved
 633    PREPARE non-reserved reserved reserved reserved
 634    PREPARED non-reserved
 635    PRESERVE non-reserved non-reserved non-reserved reserved
 636    PREV   non-reserved non-reserved
 637    PRIMARY reserved reserved reserved reserved
 638    PRIOR non-reserved non-reserved non-reserved reserved
 639    PRIVATE   non-reserved non-reserved
 640    PRIVILEGES non-reserved non-reserved non-reserved reserved
 641    PROCEDURAL non-reserved
 642    PROCEDURE non-reserved reserved reserved reserved
 643    PROCEDURES non-reserved
 644    PROGRAM non-reserved
 645    PRUNE   non-reserved non-reserved
 646    PTF   reserved reserved
 647    PUBLIC   non-reserved non-reserved reserved
 648    PUBLICATION non-reserved
 649    QUOTE non-reserved
 650    QUOTES non-reserved non-reserved non-reserved
 651    RANGE non-reserved reserved reserved
 652    RANK   reserved reserved
 653    READ non-reserved non-reserved non-reserved reserved
 654    READS   reserved reserved
 655    REAL non-reserved (cannot be function or type) reserved reserved
 656    reserved
 657    REASSIGN non-reserved
 658    RECOVERY   non-reserved non-reserved
 659    RECURSIVE non-reserved reserved reserved
 660    REF non-reserved reserved reserved
 661    REFERENCES reserved reserved reserved reserved
 662    REFERENCING non-reserved reserved reserved
 663    REFRESH non-reserved
 664    REGR_AVGX   reserved reserved
 665    REGR_AVGY   reserved reserved
 666    REGR_COUNT   reserved reserved
 667    REGR_INTERCEPT   reserved reserved
 668    REGR_R2   reserved reserved
 669    REGR_SLOPE   reserved reserved
 670    REGR_SXX   reserved reserved
 671    REGR_SXY   reserved reserved
 672    REGR_SYY   reserved reserved
 673    REINDEX non-reserved
 674    RELATIVE non-reserved non-reserved non-reserved reserved
 675    RELEASE non-reserved reserved reserved
 676    RENAME non-reserved
 677    REPEATABLE non-reserved non-reserved non-reserved non-reserved
 678    REPLACE non-reserved
 679    REPLICA non-reserved
 680    REQUIRING   non-reserved non-reserved
 681    RESET non-reserved
 682    RESPECT   non-reserved non-reserved
 683    RESTART non-reserved non-reserved non-reserved
 684    RESTORE   non-reserved non-reserved
 685    RESTRICT non-reserved non-reserved non-reserved reserved
 686    RESULT   reserved reserved
 687    RETURN non-reserved reserved reserved
 688    RETURNED_CARDINALITY   non-reserved non-reserved
 689    RETURNED_LENGTH   non-reserved non-reserved non-reserved
 690    RETURNED_OCTET_LENGTH   non-reserved non-reserved non-reserved
 691    RETURNED_SQLSTATE   non-reserved non-reserved non-reserved
 692    RETURNING reserved, requires AS non-reserved non-reserved
 693    RETURNS non-reserved reserved reserved
 694    REVOKE non-reserved reserved reserved reserved
 695    RIGHT reserved (can be function or type) reserved reserved reserved
 696    ROLE non-reserved non-reserved non-reserved
 697    ROLLBACK non-reserved reserved reserved reserved
 698    ROLLUP non-reserved reserved reserved
 699    ROUTINE non-reserved non-reserved non-reserved
 700    ROUTINES non-reserved
 701    ROUTINE_CATALOG   non-reserved non-reserved
 702    ROUTINE_NAME   non-reserved non-reserved
 703    ROUTINE_SCHEMA   non-reserved non-reserved
 704    ROW non-reserved (cannot be function or type) reserved reserved
 705    ROWS non-reserved reserved reserved reserved
 706    ROW_COUNT   non-reserved non-reserved non-reserved
 707    ROW_NUMBER   reserved reserved
 708    RPAD   reserved
 709    RTRIM   reserved
 710    RULE non-reserved
 711    RUNNING   reserved reserved
 712    SAVEPOINT non-reserved reserved reserved
 713    SCALAR non-reserved non-reserved non-reserved
 714    SCALE   non-reserved non-reserved non-reserved
 715    SCHEMA non-reserved non-reserved non-reserved reserved
 716    SCHEMAS non-reserved
 717    SCHEMA_NAME   non-reserved non-reserved non-reserved
 718    SCOPE   reserved reserved
 719    SCOPE_CATALOG   non-reserved non-reserved
 720    SCOPE_NAME   non-reserved non-reserved
 721    SCOPE_SCHEMA   non-reserved non-reserved
 722    SCROLL non-reserved reserved reserved reserved
 723    SEARCH non-reserved reserved reserved
 724    SECOND non-reserved, requires AS reserved reserved reserved
 725    SECTION   non-reserved non-reserved reserved
 726    SECURITY non-reserved non-reserved non-reserved
 727    SEEK   reserved reserved
 728    SELECT reserved reserved reserved reserved
 729    SELECTIVE   non-reserved non-reserved
 730    SELF   non-reserved non-reserved
 731    SEMANTICS   non-reserved non-reserved
 732    SENSITIVE   reserved reserved
 733    SEQUENCE non-reserved non-reserved non-reserved
 734    SEQUENCES non-reserved
 735    SERIALIZABLE non-reserved non-reserved non-reserved non-reserved
 736    SERVER non-reserved non-reserved non-reserved
 737    SERVER_NAME   non-reserved non-reserved non-reserved
 738    SESSION non-reserved non-reserved non-reserved reserved
 739    SESSION_USER reserved reserved reserved reserved
 740    SET non-reserved reserved reserved reserved
 741    SETOF non-reserved (cannot be function or type)
 742    SETS non-reserved non-reserved non-reserved
 743    SHARE non-reserved
 744    SHOW non-reserved reserved reserved
 745    SIMILAR reserved (can be function or type) reserved reserved
 746    SIMPLE non-reserved non-reserved non-reserved
 747    SIN   reserved reserved
 748    SINH   reserved reserved
 749    SIZE   non-reserved non-reserved reserved
 750    SKIP non-reserved reserved reserved
 751    SMALLINT non-reserved (cannot be function or type) reserved reserved
 752    reserved
 753    SNAPSHOT non-reserved
 754    SOME reserved reserved reserved reserved
 755    SORT_DIRECTION   non-reserved non-reserved
 756    SOURCE non-reserved non-reserved non-reserved
 757    SPACE   non-reserved non-reserved reserved
 758    SPECIFIC   reserved reserved
 759    SPECIFICTYPE   reserved reserved
 760    SPECIFIC_NAME   non-reserved non-reserved
 761    SQL non-reserved reserved reserved reserved
 762    SQLCODE       reserved
 763    SQLERROR       reserved
 764    SQLEXCEPTION   reserved reserved
 765    SQLSTATE   reserved reserved reserved
 766    SQLWARNING   reserved reserved
 767    SQRT   reserved reserved
 768    STABLE non-reserved
 769    STANDALONE non-reserved non-reserved non-reserved
 770    START non-reserved reserved reserved
 771    STATE   non-reserved non-reserved
 772    STATEMENT non-reserved non-reserved non-reserved
 773    STATIC   reserved reserved
 774    STATISTICS non-reserved
 775    STDDEV_POP   reserved reserved
 776    STDDEV_SAMP   reserved reserved
 777    STDIN non-reserved
 778    STDOUT non-reserved
 779    STORAGE non-reserved
 780    STORED non-reserved
 781    STRICT non-reserved
 782    STRING non-reserved non-reserved non-reserved
 783    STRIP non-reserved non-reserved non-reserved
 784    STRUCTURE   non-reserved non-reserved
 785    STYLE   non-reserved non-reserved
 786    SUBCLASS_ORIGIN   non-reserved non-reserved non-reserved
 787    SUBMULTISET   reserved reserved
 788    SUBSCRIPTION non-reserved
 789    SUBSET   reserved reserved
 790    SUBSTRING non-reserved (cannot be function or type) reserved reserved
 791    reserved
 792    SUBSTRING_REGEX   reserved reserved
 793    SUCCEEDS   reserved reserved
 794    SUM   reserved reserved reserved
 795    SUPPORT non-reserved
 796    SYMMETRIC reserved reserved reserved
 797    SYSID non-reserved
 798    SYSTEM non-reserved reserved reserved
 799    SYSTEM_TIME   reserved reserved
 800    SYSTEM_USER reserved reserved reserved reserved
 801    T   non-reserved non-reserved
 802    TABLE reserved reserved reserved reserved
 803    TABLES non-reserved
 804    TABLESAMPLE reserved (can be function or type) reserved reserved
 805    TABLESPACE non-reserved
 806    TABLE_NAME   non-reserved non-reserved non-reserved
 807    TAN   reserved reserved
 808    TANH   reserved reserved
 809    TARGET non-reserved
 810    TEMP non-reserved
 811    TEMPLATE non-reserved
 812    TEMPORARY non-reserved non-reserved non-reserved reserved
 813    TEXT non-reserved
 814    THEN reserved reserved reserved reserved
 815    THROUGH   non-reserved non-reserved
 816    TIES non-reserved non-reserved non-reserved
 817    TIME non-reserved (cannot be function or type) reserved reserved
 818    reserved
 819    TIMESTAMP non-reserved (cannot be function or type) reserved reserved
 820    reserved
 821    TIMEZONE_HOUR   reserved reserved reserved
 822    TIMEZONE_MINUTE   reserved reserved reserved
 823    TO reserved, requires AS reserved reserved reserved
 824    TOKEN   non-reserved non-reserved
 825    TOP_LEVEL_COUNT   non-reserved non-reserved
 826    TRAILING reserved reserved reserved reserved
 827    TRANSACTION non-reserved non-reserved non-reserved reserved
 828    TRANSACTIONS_COMMITTED   non-reserved non-reserved
 829    TRANSACTIONS_ROLLED_BACK   non-reserved non-reserved
 830    TRANSACTION_ACTIVE   non-reserved non-reserved
 831    TRANSFORM non-reserved non-reserved non-reserved
 832    TRANSFORMS   non-reserved non-reserved
 833    TRANSLATE   reserved reserved reserved
 834    TRANSLATE_REGEX   reserved reserved
 835    TRANSLATION   reserved reserved reserved
 836    TREAT non-reserved (cannot be function or type) reserved reserved
 837    TRIGGER non-reserved reserved reserved
 838    TRIGGER_CATALOG   non-reserved non-reserved
 839    TRIGGER_NAME   non-reserved non-reserved
 840    TRIGGER_SCHEMA   non-reserved non-reserved
 841    TRIM non-reserved (cannot be function or type) reserved reserved
 842    reserved
 843    TRIM_ARRAY   reserved reserved
 844    TRUE reserved reserved reserved reserved
 845    TRUNCATE non-reserved reserved reserved
 846    TRUSTED non-reserved
 847    TYPE non-reserved non-reserved non-reserved non-reserved
 848    TYPES non-reserved
 849    UESCAPE non-reserved reserved reserved
 850    UNBOUNDED non-reserved non-reserved non-reserved
 851    UNCOMMITTED non-reserved non-reserved non-reserved non-reserved
 852    UNCONDITIONAL non-reserved non-reserved non-reserved
 853    UNDER   non-reserved non-reserved
 854    UNENCRYPTED non-reserved
 855    UNION reserved, requires AS reserved reserved reserved
 856    UNIQUE reserved reserved reserved reserved
 857    UNKNOWN non-reserved reserved reserved reserved
 858    UNLINK   non-reserved non-reserved
 859    UNLISTEN non-reserved
 860    UNLOGGED non-reserved
 861    UNMATCHED   non-reserved non-reserved
 862    UNNAMED   non-reserved non-reserved non-reserved
 863    UNNEST   reserved reserved
 864    UNTIL non-reserved
 865    UNTYPED   non-reserved non-reserved
 866    UPDATE non-reserved reserved reserved reserved
 867    UPPER   reserved reserved reserved
 868    URI   non-reserved non-reserved
 869    USAGE   non-reserved non-reserved reserved
 870    USER reserved reserved reserved reserved
 871    USER_DEFINED_TYPE_CATALOG   non-reserved non-reserved
 872    USER_DEFINED_TYPE_CODE   non-reserved non-reserved
 873    USER_DEFINED_TYPE_NAME   non-reserved non-reserved
 874    USER_DEFINED_TYPE_SCHEMA   non-reserved non-reserved
 875    USING reserved reserved reserved reserved
 876    UTF16   non-reserved non-reserved
 877    UTF32   non-reserved non-reserved
 878    UTF8   non-reserved non-reserved
 879    VACUUM non-reserved
 880    VALID non-reserved non-reserved non-reserved
 881    VALIDATE non-reserved
 882    VALIDATOR non-reserved
 883    VALUE non-reserved reserved reserved reserved
 884    VALUES non-reserved (cannot be function or type) reserved reserved
 885    reserved
 886    VALUE_OF   reserved reserved
 887    VARBINARY   reserved reserved
 888    VARCHAR non-reserved (cannot be function or type) reserved reserved
 889    reserved
 890    VARIADIC reserved
 891    VARYING non-reserved, requires AS reserved reserved reserved
 892    VAR_POP   reserved reserved
 893    VAR_SAMP   reserved reserved
 894    VERBOSE reserved (can be function or type)
 895    VERSION non-reserved non-reserved non-reserved
 896    VERSIONING   reserved reserved
 897    VIEW non-reserved non-reserved non-reserved reserved
 898    VIEWS non-reserved
 899    VIRTUAL non-reserved
 900    VOLATILE non-reserved
 901    WHEN reserved reserved reserved reserved
 902    WHENEVER   reserved reserved reserved
 903    WHERE reserved, requires AS reserved reserved reserved
 904    WHITESPACE non-reserved non-reserved non-reserved
 905    WIDTH_BUCKET   reserved reserved
 906    WINDOW reserved, requires AS reserved reserved
 907    WITH reserved, requires AS reserved reserved reserved
 908    WITHIN non-reserved, requires AS reserved reserved
 909    WITHOUT non-reserved, requires AS reserved reserved
 910    WORK non-reserved non-reserved non-reserved reserved
 911    WRAPPER non-reserved non-reserved non-reserved
 912    WRITE non-reserved non-reserved non-reserved reserved
 913    XML non-reserved reserved reserved
 914    XMLAGG   reserved reserved
 915    XMLATTRIBUTES non-reserved (cannot be function or type) reserved
 916    reserved
 917    XMLBINARY   reserved reserved
 918    XMLCAST   reserved reserved
 919    XMLCOMMENT   reserved reserved
 920    XMLCONCAT non-reserved (cannot be function or type) reserved reserved
 921    XMLDECLARATION   non-reserved non-reserved
 922    XMLDOCUMENT   reserved reserved
 923    XMLELEMENT non-reserved (cannot be function or type) reserved reserved
 924
 925    XMLEXISTS non-reserved (cannot be function or type) reserved reserved
 926    XMLFOREST non-reserved (cannot be function or type) reserved reserved
 927    XMLITERATE   reserved reserved
 928    XMLNAMESPACES non-reserved (cannot be function or type) reserved
 929    reserved
 930    XMLPARSE non-reserved (cannot be function or type) reserved reserved
 931    XMLPI non-reserved (cannot be function or type) reserved reserved
 932    XMLQUERY   reserved reserved
 933    XMLROOT non-reserved (cannot be function or type)
 934    XMLSCHEMA   non-reserved non-reserved
 935    XMLSERIALIZE non-reserved (cannot be function or type) reserved
 936    reserved
 937    XMLTABLE non-reserved (cannot be function or type) reserved reserved
 938    XMLTEXT   reserved reserved
 939    XMLVALIDATE   reserved reserved
 940    YEAR non-reserved, requires AS reserved reserved reserved
 941    YES non-reserved non-reserved non-reserved
 942    ZONE non-reserved non-reserved non-reserved reserved