LPS-43753 Embed array query parameters

Brian, this is not the best solution.

We should rewrite the query to do a proper table join to avoid the OR or IN list.

However support needs to deliver the patch to customer on Monday, a major refactor is too risky, we don't have enough time to test it.

This solution does not make any logic change, just change OR to IN and embed the parameters, it should be guaranteed safe and very easy to backport. So let's do this simple fix for now, we can do the proper fix later for master.

CC @jonathanmccann @matthewchin @jontanamachi