Read product variants by multiple product IDs

Gets variants for multiple products by supplying a comma-separated list of product IDs in the ids parameter within the WITH clause.

SELECT * FROM ProductVariants WITH(ids='1111111111111,2222222222222,3333333333333')