IN clause for querying JCR

[aembytes]

If I had to query JCR using an IN clause, what's the right syntax for those?

For example, I need to find out all products that have SKU in ('x','y','z','a','b','c')

Looking for suggestions also from a performance perspective