Support for where(attr: [nil, "foo", "bar"])?

[rolftimmermans]

When calling where(attr: [nil, "foo", "bar"]) on a dataset, sequel currently transforms this into: WHERE attr IN (NULL, 'foo', 'bar') which does not work as expected.

Contrast this to where(attr: nil) which works fine (WHERE attr IS NULL) and where(attr: ["foo", "bar"]) which works fine (WHERE attr IN ('foo', 'bar').

Ideally where(attr: [nil, "foo", "bar"]) would be turned into WHERE attr IS NULL OR attr IN ('foo', 'bar').

Is there any interest in supporting this use case?
I'd be happy to create a PR in that case.

[jeremyevans]

The behavior you want is available in the split_array_nil extension: https://sequel.jeremyevans.net/rdoc-plugins/files/lib/sequel/extensions/split_array_nil_rb.html

[rolftimmermans]

Wow, thanks!