SQL Features Matrix

INSERT

Feature	Supported	In Development
VALUES - multiple values supported	✔
Sub-SELECT	✗

UPDATE

Feature	Supported	In Development
SET	✔
Sub-SELECT	✗
Conditions	✔
Math functions	✗	✔
Date Functions	✗	✔

DELETE

Feature	Supported	In Development
SET	✔
Sub-SELECT	✗
Conditions	✔

SELECT

Feature	Supported	In Development
Column SELECT	✔
Aliases	✔
Math Functions	✔
Aggregate Functions	✔
Date Functions	✗	✔
Constant Values	✗
Distinct	✗
Sub-SELECT	✗

FROM

Feature	Supported	In Development
Multi-table JOIN	✔
INNER JOIN	✔
LEFT OUTER JOIN	✔
LEFT INNER JOIN	✔
RIGHT OUTER JOIN	✗
RIGHT INNER JOIN	✗
FULL JOIN	✗
UNION	✗
Sub-SELECT	✗
TOP	✗

WHERE

Feature	Supported	In Development
Multi-Conditions	✔
Wildcards	✔
IN	✔
LIKE	✔
Bit-wise Operators AND, OR	✔
Bit-wise Operators NOT	✗
NULL	✗
BETWEEN	✗
EXISTS,ANY,ALL	✗
Compare columns	✗
Compare constants	✔
Math Functions	✗	✔
Date Functions	✗	✔
Sub-SELECT	✗

GROUP BY

Feature	Supported	In Development
Multi-Column GROUP BY	✔

ORDER BY

Feature	Supported	In Development
Multi-Column ORDER BY	✔
Aliases	✔
Math Functions	✗	✔
Date Functions	✗	✔

HAVING - is not currently supported