The Query Language

The toql query language is a string that defines which fields should be selected from a database table.

Fields can be filtered and ordered, they are separated by comma or semicolon to express AND or OR concatenation.

Fields preceded by a path refer to a depended table.

Example 1:

id, +name, age gt 18

is translated into

SELECT id, name, age WHERE age > 18 ORDER BY name ASC

Example 2:

id , .age eq 12; .age eq 15

is translated into

SELECT id WHERE age = 12 OR age = 15