Keywords

Keywords are reserved words that have significance in the StackQL grammar. Keywords can be entered in any case (upper, lower or mixed), they are capitalized in all of the examples by convention. Keywords in StackQL include:

ADD, AND, ARRAY, AS, ASC, AUTH, BETWEEN, BINARY, BY, CASE, COLLATE, CONVERT, CREATE, CUME_DIST, CURRENT_DATE, CURRENT_TIME, CURRENT_TIMESTAMP, DEFAULT, DELETE, DENSE_RANK, DESC, DESCRIBE, DISTINCT, DISTINCTROW, DIV, DROP, ELSE, END, ESCAPE, EXEC, EXISTS, EXPLAIN, EXTENDED, FIELDS, FIRST_VALUE, FOR, FORCE, FROM, GROUP, GROUPING, GROUPS, HAVING, IF, IGNORE, IN, INDEX, INNER, INSERT, INTERACTIVE, INTERVAL, INTO, IS, JOIN, JSON_TABLE, KEY, LAG, LAST_VALUE, LATERAL, LEAD, LEFT, LIKE, LIMIT, LOCALTIME, LOCALTIMESTAMP, LOCK, LOGIN, MATCH, MAXVALUE, MEMBER, METHODS, MOD, NATURAL, NEXT, NOT, NTH_VALUE, NTILE, NULL, OF, OFF, ON, OR, ORDER, OUTER, OVER, PERCENT_RANK, PROVIDERS, RANK, RECURSIVE, REGEXP, RENAME, REPLACE, RESOURCES, REVOKE, RIGHT, ROLLUP, ROW_NUMBER, SCHEMA, SELECT, SEPARATOR, SERVICES, SET, SHOW, STRAIGHT_JOIN, SUBSTR, SUBSTRING, SYSTEM, TABLE, THEN, TIMESTAMPADD, TIMESTAMPDIFF, TO, UNION, UNIQUE, UNLOCK, UPDATE, USE, USING, UTC_DATE, UTC_TIME, UTC_TIMESTAMP, VALUES, WHEN, WHERE, WINDOW, WITH, XOR, FALSE, TRUE