SQL keywords

SQL Compabillity

See list of Supported SQL statements

See also the full list of [AlaSQL reserved keywords](AlaSQL keywords).

The list of keywords used in AlaSQL (based on the table from here).

Keyword	SQL-92	SQL-99	SQL-2003	SQL-2008	SQL-2011	AlaSQL
ABS				√	√	√
ABSOLUTE	√	√
ACTION	√	√
ADD	√	√				√
AFTER		√				√
ALL	√	√	√	√	√	√
ALLOCATE	√	√	√	√	√
ALTER	√	√	√	√	√	√
AND	√	√	√	√	√	√
ANY	√	√	√	√	√	√
ARE	√	√	√	√	√
ARRAY		√	√	√	√
ARRAY_AGG				√	√
ARRAY_MAX_CARDINALITY					√
AS	√	√	√	√	√	√
ASC	√	√				√
ASENSITIVE		√	√	√	√
ASSERTION	√
ASYMMETRIC		√	√	√	√
AT	√	√	√	√	√	√
ATOMIC		√	√	√	√
AUTHORIZATION	√	√	√	√	√
AVG	√			√	√	√
BEFORE		√
BEGIN	√	√	√	√	√	√
BEGIN_FRAME					√
BEGIN_PARTITION					√
BETWEEN	√	√	√	√	√	√
BIGINT			√	√	√
BINARY		√	√	√	√
BIT	√	√
BIT_LENGTH	√
BLOB		√	√	√	√
BOOLEAN		√	√	√	√
BOTH	√	√	√	√	√
BREADTH		√
BY	√	√	√	√	√	√
CALL	√	√	√	√	√
CALLED			√	√	√
CARDINALITY				√	√
CASCADE	√	√	√	√	√
CASCADED	√	√	√	√	√
CASE	√	√	√	√	√	√
CAST	√	√	√	√	√	√
CATALOG	√	√
CEIL				√	√
CEILING				√	√
CHAR	√	√	√	√	√
CHAR_LENGTH	√			√	√
CHARACTER	√	√	√	√	√
CHARACTER_LENGTH	√			√	√
CHECK	√	√	√	√	√	√
CLOB		√	√	√	√
CLOSE	√	√	√	√	√	√
COALESCE	√			√	√	√
COLLATE	√	√	√	√	√
COLLATION	√	√
COLLECT				√	√
COLUMN	√	√	√	√	√	√
COMMIT	√	√	√	√	√	√
CONDITION	√	√	√	√	√
CONNECT	√	√	√	√	√
CONNECTION	√	√
CONSTRAINT	√	√	√	√	√	√
CONSTRAINTS	√	√				√
CONSTRUCTOR		√
CONTAINS	√
CONTINUE	√	√
CONVERT	√			√	√
CORR				√	√
CORRESPONDING	√	√	√	√	√	√
COUNT	√			√	√
COVAR_POP				√	√
COVAR_SAMP				√	√
CREATE	√	√	√	√	√	√
CROSS	√	√	√	√	√	√
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		√
DATE	√	√	√	√	√	√
DAY	√	√	√	√	√	√
DEALLOCATE	√	√	√	√	√
DEC	√	√	√	√	√
DECIMAL	√	√	√	√	√
DECLARE	√	√	√	√	√	√
DEFAULT	√	√	√	√	√	√
DEFERRABLE	√	√
DEFERRED	√	√
DELETE	√	√	√	√	√	√
DENSE_RANK				√	√
DEPTH		√
DEREF		√	√	√	√
DESC	√	√				√
DESCRIBE	√	√	√	√	√
DESCRIPTOR	√	√
DETERMINISTIC	√	√	√	√	√
DIAGNOSTICS	√	√
DISCONNECT	√	√	√	√	√
DISTINCT	√	√	√	√	√	√
DO	√	√	√	√	√
DOMAIN	√	√
[DOUBLE](Double Precision)	√	√	√	√	√	√
DROP	√	√	√	√	√	√
DYNAMIC		√	√	√	√
EACH		√	√	√	√
ELEMENT			√	√	√
ELSE	√	√	√	√	√	√
ELSEIF	√	√	√	√	√
END	√	√	√	√	√	√
END_FRAME					√
END_PARTITION					√
END_EXEC				√	√
EQUALS		√
ESCAPE	√	√	√	√	√	√
EVERY				√	√
EXCEPT	√	√	√	√	√	√
EXCEPTION	√	√
EXEC	√	√	√	√	√
EXECUTE	√	√	√	√	√	√
EXISTS	√	√	√	√	√	√
EXIT	√	√	√
EXTERNAL	√	√	√	√	√
EXTRACT	√			√	√
FALSE	√	√	√	√	√	√
FETCH	√	√	√	√	√
FILTER		√	√	√	√
FIRST	√	√				√
FIRST_VALUE					√
FLOAT	√	√	√	√	√
FOR	√	√	√	√	√
[FOREIGN](Foreign Key)	√	√	√	√	√	√
FOUND	√	√
FRAME_ROW					√
FREE		√	√	√	√
FROM	√	√	√	√	√	√
FULL	√	√	√	√	√	√
FUNCTION	√	√	√	√	√
FUSION	√	√	√
GENERAL		√
GET	√	√	√	√	√	√
GLOBAL	√	√	√	√	√	√
GO	√	√
GOTO	√	√
GRANT	√	√	√	√	√
GROUP	√	√	√	√	√	√
[GROUPING](Grouping Sets)		√	√	√	√	√
GROUPS					√
HANDLER	√	√	√	√	√
HAVING	√	√	√	√	√	√
HOLD		√	√	√	√
HOUR	√	√	√	√	√	√
IDENTITY	√	√	√	√	√	√
IF	√	√	√	√	√	√
IMMEDIATE	√	√	√
IN	√	√	√	√	√	√
INDICATOR	√	√	√	√	√
INITIALLY	√	√
INNER	√	√	√	√	√	√
INOUT	√	√	√	√	√
INPUT	√	√	√
INSENSITIVE	√	√	√	√	√
INSERT	√	√	√	√	√	√
INT	√	√	√	√	√
INTEGER	√	√	√	√	√
INTERSECT	√	√	√	√	√	√
INTERSECTION				√	√
INTERVAL	√	√	√	√	√
INTO	√	√	√	√	√	√
IS	√	√	√	√	√	√
ISOLATION	√	√
ITERATE		√	√	√	√
JOIN	√	√	√	√	√	√
KEY	√	√
LANGUAGE	√	√	√	√	√
LARGE		√	√	√	√
LAST	√	√
LAST_VALUE					√
LATERAL		√	√	√	√
LEAD					√
LEADING	√	√	√	√	√
LEAVE	√	√	√	√	√
LEFT	√	√	√	√	√	√
LEVEL	√	√
LIKE	√	√	√	√	√	√
LIKE_REGEX				√	√
LIMIT		√
LN				√	√
LOCAL	√	√	√	√	√
LOCALTIME		√	√	√	√
LOCALTIMESTAMP		√	√	√	√
LOCATOR		√
LOOP	√	√	√	√	√
LOWER	√			√	√
MAP		√
MATCH	√	√	√	√	√
MAX	√			√	√	√
MEMBER			√	√	√
MERGE			√	√	√
METHOD		√	√	√	√
MIN	√			√	√	√
MINUTE	√	√	√	√	√	√
MOD				√	√
MODIFIES		√	√	√	√
MODULE	√	√	√	√	√
MONTH	√	√	√	√	√	√
MULTISET			√	√	√
NAMES	√	√
NATIONAL	√	√	√	√	√
NATURAL	√	√	√	√	√	√
NCHAR	√	√	√	√	√
NCLOB		√	√	√	√
NEW		√	√	√	√	√
NEXT	√	√
NO	√	√	√	√	√
NONE		√	√	√	√
NORMALIZE				√	√
NOT	√	√	√	√	√	√
NTH_VALUE					√
NTILE					√
NULL	√	√	√	√	√	√
NULLIF	√			√	√	√
NUMERIC	√	√	√	√	√
OBJECT		√
OCTET_LENGTH	√			√	√
OF	√	√	√	√	√	√
OFFSET					√	√
OLD		√	√	√	√
ON	√	√	√	√	√	√
ONLY	√	√	√	√	√
OPEN	√	√	√	√	√
OPTION	√	√
OR	√	√	√	√	√	√
[ORDER](Order By)	√	√	√	√	√	√
ORDINALITY		√
OUT	√	√	√	√	√	√
OUTER	√	√	√	√	√	√
OUTPUT	√	√	√
OVER		√	√
OVERLAPS	√	√	√	√	√
OVERLAY				√	√
PAD	√	√
PARAMETER	√	√	√	√	√
PARTIAL	√	√
PARTITION		√	√	√	√
PATH	√	√
PERCENT					√	√
PERCENT_RANK				√	√
PERCENTILE_CONT				√	√
PERCENTILE_DISC				√	√
PERIOD					√
PORTION					√
POSITION	√			√	√
POSITION_REGEX				√	√
POWER				√	√
PRECEDES					√
PRECISION	√	√	√	√	√	√
PREPARE	√	√	√	√	√
PRESERVE	√	√
[PRIMARY](Primary Key)	√	√	√	√	√	√
PRIOR	√	√
PRIVILEGES	√	√
PROCEDURE	√	√	√	√	√
PUBLIC	√	√
RANGE	√		√	√	√	√
RANK				√	√
READ	√	√
READS		√	√	√	√
REAL	√	√	√	√	√
RECURSIVE		√	√	√	√
REF		√	√	√	√
REFERENCES	√	√	√	√	√	√
REFERENCING		√	√	√	√
REGR_AVGX				√	√
REGR_AVGY				√	√
REGR_COUNT				√	√
REGR_INTERCEPT				√	√
REGR_R2				√	√
REGR_SLOPE				√	√
REGR_SXX				√	√
REGR_SXYREGR_SYY				√	√
RELATIVE	√	√
RELEASE		√	√	√	√
REPEAT	√	√	√	√	√
RESIGNAL	√	√	√	√	√
RESTRICT	√	√
RESULT		√	√	√	√
RETURN	√	√	√	√	√	√
RETURNS	√	√	√	√	√	√
REVOKE	√	√	√	√	√
RIGHT	√	√	√	√	√	√
ROLE		√
ROLLBACK	√	√	√	√	√	√
ROLLUP		√	√	√	√	√
ROUTINE	√	√
ROW		√	√	√	√	√
ROW_NUMBER				√	√
ROWS	√	√	√	√	√
SAVEPOINT		√	√	√	√
SCHEMA	√	√				√
SCOPE		√	√	√	√
SCROLL	√	√	√	√	√
SEARCH		√	√	√	√	√
SECOND	√	√	√	√	√	√
SECTION	√	√
SELECT	√	√	√	√	√	√
SENSITIVE		√	√	√	√
SESSION	√	√
SESSION_USER	√	√	√	√	√
SET	√	√	√	√	√	√
[SETS](Grouping Sets)		√				√
SIGNAL		√	√	√	√
SIMILAR		√	√	√	√
SIZE	√	√
SMALLINT	√	√	√	√	√
SOME	√	√	√	√	√	√
SPACE	√	√
SPECIFIC	√	√	√	√	√
SPECIFICTYPE		√	√	√	√
SQL	√	√	√	√	√
SQLCODE	√
SQLERROR	√
SQLEXCEPTION	√	√	√	√	√
SQLSTATE	√	√	√	√	√
SQLWARNING	√	√	√	√	√
SQRT				√	√
START		√	√	√	√
STATE		√
STATIC		√	√	√	√
STDDEV_POP				√	√
STDDEV_SAMP				√	√
SUBMULTISET			√	√	√
SUBSTRING	√			√	√	√
SUBSTRING_REGEX				√	√
SUCCEEDS					√
SUM	√			√	√	√
SYMMETRIC		√	√	√	√
SYSTEM		√	√	√	√
SYSTEM_TIME					√
SYSTEM_USER	√	√	√	√	√
[TABLE](Create Table)	√	√	√	√	√	√
TABLESAMPLE			√	√	√
TEMPORARY	√	√				√
THEN	√	√	√	√	√	√
TIME	√	√	√	√	√	√
TIMESTAMP	√	√	√	√	√	√
TIMEZONE_HOUR	√	√	√	√	√
TIMEZONE_MINUTE	√	√	√	√	√
TO	√	√	√	√	√	√
TRAILING	√	√	√	√	√
TRANSACTION	√	√
TRANSLATE	√			√	√
TRANSLATE_REGEX				√	√
TRANSLATION	√	√	√	√	√
TREAT		√	√	√	√
TRIGGER		√	√	√	√
TRIM	√			√	√	√
TRIM_ARRAY					√
TRUE	√	√	√	√	√	√
TRUNCATE				√	√
UESCAPE				√	√
UNDER		√
UNDO	√	√	√	√	√
UNION	√	√	√	√	√	√
UNIQUE	√	√	√	√	√	√
UNKNOWN	√	√	√	√	√
UNNEST		√	√	√	√
UNTIL		√	√	√	√
UPDATE	√	√	√	√	√	√
UPPER	√			√	√	√
USAGE	√	√
USER	√	√	√	√	√
USING	√	√	√	√	√	√
VALUE	√	√	√	√	√	√
VALUES	√	√	√	√	√	√
VALUE_OF					√
VAR_POP				√	√	√
VAR_SAMP				√	√	√
VARBINARY				√	√
VARCHAR	√	√	√	√	√	√
VARYING	√	√	√	√	√
VERSIONING					√
[VIEW](Create View)	√	√				√
WHEN	√	√	√	√	√	√
WHENEVER	√	√	√	√	√
WHERE	√	√	√	√	√	√
WHILE	√	√	√	√	√	√
WIDTH_BUCKET				√	√
WINDOW		√	√	√	√
WITH	√	√	√	√	√	√
WITHIN		√	√	√	√
WITHOUT		√	√	√	√
WORK	√	√				√
WRITE	√	√
YEAR	√	√	√	√	√	√
ZONE	√	√