When implementing SargableNode s, we can consider creating an expression which uses PathCompare [EqMember], rather than a composition of many PathCompare s.

A good place for implementation could be within the lowerPartialSchemaRequirement function.

This ticket is inspired by the approach here, which created a FilterNode with a call to isMember during translation of a $in.