Appendix: Reserved Keywords

Appendix: Reserved Keywords

    Identifiers starting with the underscore (_) character, must be escaped by enclosing them inside backticks (`).

    For example, SELECT COUNT(`_id`) AS COUNT_EMPLOYEE FROM default_shadow;

    All reserved keywords are listed in the following table:

    ALL AND ANY APPLY AS ASC
    AT AUTOGENERATED BETWEEN BTREE BUCKET BY
    CASE CLOSED CREATE COMPACTION COMPACT CONNECT
    CONNECTED CORRELATE COLLECTION DATASET DATAVERSE DECLARE
    DEFINITION DECLARE DEFINITION DELETE DESC DISCONNECT
    DISTINCT DROP ELEMENT EXPLAIN ELSE ENFORCED
    END EVERY EXCEPT EXISTS EXTERNAL FEED
    FILTER FLATTEN FOR FROM FULL FUNCTION
    GROUP HAVING HINTS IF INTO IN
    INDEX INGESTION INNER INSERT INTERNAL INTERSECT
    IS JOIN KEYWORD KEY LEFT LETTING
    LET LIKE LIMIT LOAD NODEGROUP NGRAM
    NOT OFFSET ON OPEN OR ORDER
    OUTER OUTPUT PATH POLICY PRE-SORTED PRIMARY
    RAW REFRESH RETURN RTREE RUN SATISFIES
    SECONDARY SELECT SET SHADOW SOME TEMPORARY
    THEN TYPE TO UNION UNKNOWN UNNEST
    UPDATE USE USING VALUE WHEN WHERE
    WITH WRITE