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