SQL Features Matrix

INSERT

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

 

UPDATE

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

 

DELETE

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

 

SELECT

Feature	Supported	In Development
Column SELECT	✔
Aliases	✔
Aggregator Functions	✔
Date Functions*	✔
Math 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	✔
Date Functions*	✔
Math Functions	✔
Sub-SELECT	✗

 

GROUP BY

Feature	Supported	In Development
Multi-Column GROUP BY	✔

 

ORDER BY

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

HAVING - is not currently supported

* Learn more about how Date Functions in HDB work here.