The Watson Explorer Engine reporting tool uses the SQLite package for collection and querying of reporting data. Please refer to this site for supported syntax when writing SQL statements in the reporting tool.
In addition to the standard SQLite syntax, the next few sections discuss some extensions that are provided by Watson Explorer Engine for your convenience when writing SQL expressions.