Query syntax

Query structure

select <projection selectors> 
where <conditions> 
order by <order selectors asc|desc> 
limit <offset>,<limit>

Example:

select name, age where age > 18 order by name asc, age desc limit 0, 10

select name, age where age > 18 and age < 25 order by name asc, age desc limit 0, 10

Only selectors:

select name, age

Only conditions:

age > 18

Only order:

order by name, age

Only limit:

limit 0,100

Logic Operator Precedence: AND and OR:

select name, age where name like 'John%' and (age = 18 or age = 25) limit 0, 10

select name, age where name like 'John%' or (age > 18 and age <25) limit 0, 10