Is your feature request related to a problem? Please describe.
Currently an empty whereIn clause will render as empty list which results in a MySQL error.
Describe the solution you'd like
An empty whereIn clause should render as 1 = 2 or some other false statement in order to replicate the expected behavior of WHERE x IN ()
Describe alternatives you've considered
Excluding the statement is another option but that's dangerous as sensitive data might be exposed that otherwise would have been filtered by the IN clause and doesn't really match the expected behavior of does the set () include element x.
Is your feature request related to a problem? Please describe.
Currently an empty whereIn clause will render as empty list which results in a MySQL error.
Describe the solution you'd like
An empty whereIn clause should render as
1 = 2or some other false statement in order to replicate the expected behavior ofWHERE x IN ()Describe alternatives you've considered
Excluding the statement is another option but that's dangerous as sensitive data might be exposed that otherwise would have been filtered by the IN clause and doesn't really match the expected behavior of
does the set () include element x.