Query Language

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

To specify a query, supply a filter expression. For example:
column_name > 100

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.

Filter expressions are not case sensitive. Query evaluation converts keywords and column names to lower case before evaluation.

Related concepts