[FEATURE]: Empty disjunctions should filter everything #4261
Description
Feature hasn't been suggested before.
- I have verified this feature I'm about to request hasn't been suggested before.
Describe the enhancement you want to request
Just flagging that in traditional logic empty disjunctions tend to be identified with falsehood. Under this identification, providing an empty disjunction or() to a where clause would create a totally exclusive filter-- every result is filtered out.
However, currently, an empty disjunction produces undefined (source), which, based on the conditional filtering API (docs), seems like it results in a totally inclusive filter, including every result instead.
This might warrant reconsideration in some future major release of drizzle.