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 | |
|---|---|
| UPDATE | |
|---|---|
| DELETE | |
|---|---|
| SELECT | |
|---|---|
| FROM | |
|---|---|
| WHERE | |
|---|---|
| GROUP BY | |
|---|---|
| HAVING | |
|---|---|
| ORDER BY | |
|---|---|
Values - multiple values supported
✔
Sub-SELECT
✗
SET
✔
Sub-SELECT
✗
Conditions
✔
Date Functions*
✔
Math Functions
✔
FROM
✔
Sub-SELECT
✗
Conditions
✔
Column SELECT
✔
Aliases
✔
Aggregator Functions
✔
Date Functions*
✔
Math Functions
✔
Constant Values
✔
Distinct
✔
Sub-SELECT
✗
Multi-table JOIN
✔
INNER JOIN
✔
LEFT OUTER JOIN
✔
LEFT INNER JOIN
✔
RIGHT OUTER JOIN
✔
RIGHT INNER JOIN
✔
FULL JOIN
✔
UNION
✗
Sub-SELECT
✗
TOP
✔
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
✗
Multi-Column GROUP BY
✔
Aggregate function conditions
✔
Multi-Column ORDER BY
✔
Aliases
✔
Date Functions*
✔
Math Functions
✔