[Feature Request]: IN and NOT IN support for Where clauses

[HammadB]

Describe the problem

Chaining together multiple OR calls for IN or NOT IN behavior in where clauses is cumbersome.

Describe the proposed solution

We should support IN and NOT IN behavior for fields in the metadata as a shorthand for OR.

I.E

where = {"property_name": {"$in" : ["A", "B", "C"]}}

Alternatives considered

No response

Importance

would make my life easier

Additional Information

From discord user -> https://discord.com/channels/1073293645303795742/1074711446589542552/1100117157225967717