How can I build the following query with the builder:
SELECT * FROM Post WHERE (Post.id IN (X) OR Post.element IN (Y));
Where (X) and (Y) would be arbitrary arrays of ids/elements
If I do the following:
$builder->from('Post') ->inWhere('id', X) ->inWhere('element', Y);
The inWhere method always seems to assume that the condition should be appended with an AND operator. Is there an easy way to create this query with the builder, or is it only possible by generating my own query string?
Any help would be appreciated. Thanks!