The query language
The Toql query language is a normal string that list all query fields, that should be retrieved from a database.
Besides selection, query fields can also be filtered and ordered.
They are separated either by comma or semicolon. If a filter is applied a comma will join the filters with AND, a semicolon with OR.
Example 1:
id, +name, age gt 18
is translated into
SELECT t1.id, t1.name, t1.age FROM ... t1 WHERE t1.age > 18 ORDER BY t1.name ASC
Example 2:
id, .age eq 12; .age eq 15is translated into
SELECT t1.id From ... t1 WHERE t1.age = 12 OR t1.age = 15`