Iterator Query Language

ActiveSpaces software supports a restricted subset of the SQL query language.

To specify a query when using an iterator, supply a filter expression. For example:
column_name > 100

Iterator Queries return all columns of a table rather than a subset of specific columns. That is, all queries implicitly begin with SELECT * FROM table_name WHERE. Nonetheless, programs do not specify this string, they specify only the filter that would follow the WHERE keyword.

SQL keywords and table and column identifiers are not case sensitive when used in a filter expression. String values, surrounded by single quotes, are case-sensitive.