.filter does client side ResultSet filtering using predicates.
If .limit is used, then the filtering is only applied to the rows retrieved.
Since the rows are filtered when they are retrieved, it does not cost extra memory.
The filtering predicates are removed after being used.
The syntax is basically similar to WHERE clause.
Besides the usual
operators. The following operators are also supported.
BETWEEN <num> AND <num>
< ANY ( ... ),
< SOME ( ... ),
< ALL ( ... )etc
IN ( ... )
.filter a > 10 AND b < 100 SELECT * FROM MyTable ORDER BY a;