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