Skip to main content

WebdaQL

Operators

= equal to
< less than
> greater than
<= less than or equal to
>= greater than or equal to
IN array
LIKE
AND:
OR:

Precedence
a AND b OR c is equivalent to (a AND b) OR c
a AND b OR c AND d is equivalent to (a AND b) OR (c AND d)

Order By

You can use ORDER BY to order the results, this is not a hard requirements to manage it on underlying Store.

Currently, MongoDB, Postgres, File and Memory have a full ORDER BY capabilities

DynamoDB have some hard limitation, only the sortKey can be ordered and every other ORDER BY clause will be ignored

FireBase have also limitations, only the defined index with their direction will be able to be used, every other ORDER BY clause will be ignored

Limit and Offset

To define the LIMIT just add LIMIT