Run query designer, set one WHERE condition, switch to data and SQL view, change the condition in the SQL view.
Repeat for 2 or more conditions. Use relations such as = < <= > >= and without relation (defaults to =).
Needed KDb patches: D5294
Note: for 3.0 branches! Will be merged to master when accepted.