USE KEYS

SELECT fname, email FROM tutorial USE KEYS ('dave', 'ian');

SELECT fname, email FROM tutorial WHERE META().id IN ('dave', 'ian');

ON KEYS

SELECT * FROM user u JOIN orders o ON KEYS ARRAY s.order_id FOR s IN u.order_history END;

SELECT * FROM user u, u.order_history s JOIN orders o ON s.order_id = Meta(o).id;

USE KEY

SELECT * FROM user u JOIN orders o ON KEY o.user_id FOR u;

SELECT * FROM user u JOIN orders o ON META(u).id = o.user_id;

NEST

SELECT * FROM user u NEST orders orders ON KEYS ARRAY s.order_id FOR s IN u.order_history END;

NEST/UNNEST not supported

LEFT OUTER NEST

SELECT * FROM user u LEFT OUTER NEST orders orders ON KEYS ARRAY s.order_id FOR s IN u.order_history END;

NEST/UNNEST not supported

ARRAY

ARRAY i FOR i IN [1, 2] END

(SELECT VALUE i FROM [1, 2] AS i)

ARRAY FIRST

ARRAY FIRST arr

arr[0]

LIMIT l OFFSET o

Allows OFFSET without LIMIT

Allows OFFSET without LIMIT

UNION, INTERSECT, EXCEPT

All three are supported (with ALL and DISTINCT variants).

Not supported

OUTER JOIN

Both LEFT and RIGHT OUTER JOIN are supported.

Only LEFT OUTER JOIN supported (and necessary for query expressability).

<, <=, =, etc. operators

Can compare either complex values or scalar values.

Only scalar values may be compared.

ORDER BY

Result sequencing is based on specific rules described in SQL++ for Server ORDER BY clause.

Result sequencing is based on the SQLite ordering described in SQLite select overview.

The ordering of Dictionary and Array objects is based on binary ordering.

SELECT DISTINGCT

Supported

SELECT DISTINCT VALUE is supported when the returned values are scalars.

CREATE INDEX

Supported

Not Supported

INSERT, UPSERT, DELETE

Supported

Not Supported