OR-ing together expressions in a filter (dynamic)
Opened this issue · 3 comments
d6y commented
Producing a expresion while where (exp) or (exp) or (exp)
is not obvious. It's a single filter
call, but what do you put in the filter body?
Example: https://github.com/d6y/list-of-tuples
Might make a good advanced question, or a trick to put in. Perhaps a section/chapter/"case study" on dynamic queries with #34
d6y commented
d6y commented
Also: useful as a workaround for no tuple support for inSet
. E.g., replacing "select * where (x,y) in ( (1,2), (4,5) )" with "where (x=1 && y=2) or (x=4 && y=5)".
d6y commented
Another one: https://stackoverflow.com/a/60511701/154248