dimsuz
11/05/2019, 11:20 AMsqldelight
question. Say I have a query like
SELECT column1 FROM table WHERE column2 IN ?
If I pass an empty list I guess it will return an empty row set. But what if I want to pass an empty list and get ALL rows in this case. Do I absolutely have to have 2 almost identical queries for this (second being one without an IN
)?
Asking because in my case query has quite a complicated WHERE
clause, I'm afraid maintaining 2 versions of it could be prone to forgetting.