$query parameter allows you to combine multiple SoQL clauses together into a single parameter, for convenience. Similar to SQL, clauses must be specified in a specific order:
Note that unlike SQL, there is no
For example, you could combine
$where parameters together as follows:
For a full listing of the functionality available in SoQL, check out the the SoQL documentation.