動作保証されているSQL言語を以下に示します。
ステートメント(Statement)
ALTER TABLE statement
CREATE statements
DROP Statements
RENAME statements
SET statements
DELETE statement
FOR UPDATE clause
FROM clause
GROUP BY clause
HAVING clause
INNER JOIN
INSERT statement
JOIN operation
LEFT OUTER JOIN
ORDER BY clause
Query
RIGHT OUTER JOIN
ScalarSubquery
SelectExpression
SELECT statement
TableExpression
TableSubquery
UPDATE statement
VALUES expression
WHERE clause
組み込み関数(Built-in functions)
ABS or ABSVAL
AVG
Concatenation
COUNT
NULLIF and CASE expressions
CURRENT_DATE
CURRENT_TIME
CURRENT_TIMESTAMP
LENGTH
LOCATE
LCASE or LOWER
LTRIM
MAX
MIN
MOD
RTRIM
SQRT
SUBSTR
SUM
UCASE or UPPER
組み込みシステム関数(Built-in system functions)
なし
組み込みシステム・プロシジャ(Built-in system procedures)
なし
データ型(Data types)
BIGINT
BLOB
CHAR
CHAR FOR BIT DATA
CLOB
DATE
DECIMAL
DOUBLE
DOUBLE PRECISION
FLOAT
INTEGER
LONG VARCHAR
LONG VARCHAR FOR BIT DATA
NUMERIC
REAL
SMALLINT
TIME
TIMESTAMP
VARCHAR
VARCHAR FOR BIT DATA
式(Operator)
+、-、*、/、単項 + 式、単項 - 式
AND、OR、NOT
比較（ <、=、>、<=、>=、<> ）
IS NULL, IS NOT NULL
LIKE
BETWEEN
IN
EXISTS
限定比較(ALL、ANY、SOME)
