Between Operator
Between is an operator returns true if the numeric or date values fall within the range.
Example
SELECT city FROM table WHERE pop Between 100000 AND 200000
If the data source provider supports Between, the entire query is delegated to the data source provider.
If the data source provider does not support Between, part of the query is delegated, as follows:
SELECT city, pop FROM table
Spectrum Spatial executes the entire query, using the results from the data source provider:
SELECT city FROM <results from the delegation> WHERE pop Between 100000 AND 200000