Query Where relation field contains ALL rather than just IN

I understand from the docs, that in a REST API query for WHERE <Relation>.<Column> IN (‘Value 1’, ‘Value2’) translates to “Give me all data where the relation.column is equal to Value 1 OR value 2”.
What If I have a table A whose mapped 1-Many to table B. So Table A has a column of ‘Many’ Table B objects.
How do I query for all Table A rows who have an array of Table B values? So Table A’s relational column has many values from Table B, and I want all the rows with certain particular values.
Kind of like:
WHERE relation.column = [‘Value1’, ‘Value2’]
So rather than an OR, it would be an AND. I’m not figuring out how to create this in REST API request form…

Hi Lucas,

I cannot think of a way to do it with a single where clause statement. I’d implement the logic of the object retrieval in a custom service to encapsulate the complexity in a single place and optimize the performance from the client-side perspective.

Regards,
Mark