Iterator Query Language
The rows to be returned when querying a table with an iterator can be constrained by specifying a filter string when the iterator is created. The filter string is the equivalent of a SQL WHERE clause, which must result in a boolean value indicating whether or not a row must be included in the results of a query.
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.