SQL Features Matrix

HarperDB provides access to most SQL functions, and we’re always expanding that list. Check below to see if we cover what you need. If not, feel free to add a Feature Request.

INSERT

VALUES – multiple values supported
Sub-SELECT

UPDATE

SET
Sub-SELECT
Conditions
Date Functions*
Math Functions

DELETE

SET
Sub-SELECT
Conditions

SELECT

Column SELECT
Aliases
Aggregator Functions
Date Functions*
Math Functions
Constant Values
Distinct
Sub-SELECT

FROM

Multi-table JOIN
INNER JOIN
LEFT OUTER JOIN
LEFT INNER JOIN
RIGHT OUTER JOIN
RIGHT INNER JOIN
FULL JOIN
UNION
Sub-SELECT
TOP

WHERE

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

Multi-Column GROUP BY

ORDER BY

Multi-Column ORDER BY
Aliases
Date Functions*
Math Functions

HAVING

HAVING is not currently supported