Query syntax

Query structure

select <selectors> where <conditions> order by <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

Logic Operator Precedence: AND and OR:

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