how do we say cleanly in hql something like, "select only the rows where all the elements in my collection are contained within this other collection"

when I use "object in (:collection)", it does an "OR" on the individual items so it pulls all the rows with at least one match. I basically want the opposite - only pulling if they all match.

I just posted this same question with a detailed example of what i've tried in this thread:
https://forum.hibernate.org/viewtopic.php?f=1&t=999756

I'm interested to see if there is a solution to this.

I've tried it in a million different ways. A few times I got the HQL to compile, but then got a SQL grammar error.

I was trying things like this (forgive the bad syntax).



I've tried = some and a whole bunch of other variations.

I've come to the conclusion that generating the HQL string with a string builder is probably the only way to do it.