KoddQL Tutorial

Selecting data

All selection queries must end with forwarding operator (->) pointing to RESULT constant.

Plain selection

To select all the data from the table, you need to just specify table's name and forward it to RESULT.

table	->	RESULT

If you need to select from multiple tables, you can group them in round brackets, separating each by comma.

(table1, table2)	->	RESULT

Projection

If you only need a part of table's columns, you can apply projection.

table	[field1, field2]	->	RESULT

Restriction

To select data by criteria, you need to use restriction.

table	[field1 θ field2]	->	RESULT

List of operations:

• Comparisions
  • (>, <, ==, <>, >=, <=)
• Arithmethic
  • (+, -, *, /, %)
• Logical
  • (&, |, ^)
• Similarity
  • Like ("string" ~ "wildcard")
  • In range ("number" ~ "lower limit" & "higher limit")

Updating data

Remove data

Edit table

Edit database