Please use the form below to provide your feedback. Because your feedback is valuable to us, the information you submit in this form is recorded in our issue tracking system (JIRA), which is publicly available. You can track the status of your feedback using the ticket number displayed in the dialog once you submit the form.

A newer version of this documentation is available.

View Latest

Reserved Words

  • reference
    +
    SQL++ defines an extensive list of keywords that are reserved words. You cannot use these keywords as identifiers unless you escape them. All of the SQL++ keywords are case-insensitive.

    Some keywords are not currently implemented but are reserved for future use.

    Using Reserved Words as Identifiers

    SQL++ allows escaped identifiers to overlap with keywords. To use a reserved word as an identifier, you must escape it by enclosing the reserved word inside backticks (``). For example, if your JSON document contains a field named index, you can use it in your queries by escaping it like this:

    {
    "age": "42",
    "index": 27,
    "name": "Elvis"
}
    CREATE INDEX myindex ON default(`index`) USING GSI;

    SQL++ Reserved Words

    The following keywords are reserved and cannot be used as unescaped identifiers:

    Symbols

    _INDEX_CONDITION
    _INDEX_KEY

    A

    ADVISE
    ALL
    ALTER
    ANALYZE
    AND
    ANY
    ARRAY
    AS
    ASC
    AT

    B

    BEGIN
    BETWEEN
    BINARY
    BOOLEAN
    BREAK
    BUCKET
    BUILD
    BY

    C

    CACHE
    CALL
    CASE
    CAST
    CLUSTER
    COLLATE
    COLLECTION
    COMMIT
    COMMITTED
    CONNECT
    CONTINUE
    CORRELATED
    COVER
    CREATE
    CURRENT
    CYCLE

    D

    DATABASE
    DATASET
    DATASTORE
    DECLARE
    DECREMENT
    DEFAULT
    DELETE
    DERIVED
    DESC
    DESCRIBE
    DISTINCT
    DO
    DROP

    E

    EACH
    ELEMENT
    ELSE
    END
    ESCAPE
    EVERY
    EXCEPT
    EXCLUDE
    EXECUTE
    EXISTS
    EXPLAIN

    F

    FALSE
    FETCH
    FILTER
    FIRST
    FLATTEN
    FLATTEN_KEYS
    FLUSH
    FOLLOWING
    FOR
    FORCE
    FROM
    FTS
    FUNCTION

    G

    GOLANG
    GRANT
    GROUP
    GROUPS
    GSI

    H

    HASH
    HAVING

    I

    IF
    IGNORE
    ILIKE
    IN
    INCLUDE
    INCREMENT
    INDEX
    INFER
    INLINE
    INNER
    INSERT
    INTERSECT
    INTO
    IS
    ISOLATION

    J

    JAVASCRIPT
    JOIN

    K

    KEY
    KEYS
    KEYSPACE
    KNOWN

    L

    LANGUAGE
    LAST
    LATERAL
    LEFT
    LET
    LETTING
    LEVEL
    LIKE
    LIMIT
    LSM

    M

    MAP
    MAPPING
    MATCHED
    MATERIALIZED
    MAXVALUE
    MERGE
    MINVALUE
    MISSING

    N

    NAMESPACE
    NEST
    NEXT
    NEXTVAL
    NL
    NO
    NOT
    NTH_VALUE
    NULL
    NULLS
    NUMBER

    O

    OBJECT
    OFFSET
    ON
    OPTION
    OPTIONS
    OR
    ORDER
    OTHERS
    OUTER
    OVER

    P

    PARSE
    PARTITION
    PASSWORD
    PATH
    POOL
    PRECEDING
    PREPARE
    PREV
    PREVIOUS
    PREVVAL
    PRIMARY
    PRIVATE
    PRIVILEGE
    PROBE
    PROCEDURE
    PUBLIC

    R

    RANGE
    RAW
    READ
    REALM
    RECURSIVE
    REDUCE
    RENAME
    REPLACE
    RESPECT
    RESTART
    RESTRICT
    RETURN
    RETURNING
    REVOKE
    RIGHT
    ROLE
    ROLLBACK
    ROW
    ROWS

    S

    SATISFIES
    SAVEPOINT
    SCHEMA
    SCOPE
    SELECT
    SELF
    SEQUENCE
    SET
    SHOW
    SOME
    START
    STATISTICS
    STRING
    SYSTEM

    T

    THEN
    TIES
    TO
    TRAN
    TRANSACTION
    TRIGGER
    TRUE
    TRUNCATE

    U

    UNBOUNDED
    UNDER
    UNION
    UNIQUE
    UNKNOWN
    UNNEST
    UNSET
    UPDATE
    UPSERT
    USE
    USER
    USERS
    USING

    V

    VALIDATE
    VALUE
    VALUED
    VALUES
    VECTOR
    VIA
    VIEW

    W

    WHEN
    WHERE
    WHILE
    WINDOW
    WITH
    WITHIN
    WORK

    X

    XOR