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 intoSELECT t1.id From ... t1 WHERE t1.age = 12 OR t1.age = 15`