In Hibernate v7 (development still ongoing for now), an array unnest SQL array function (e.g. https://www.postgresql.org/docs/17/functions-array.html) was implemented which will unleash the full power of ad-hoc array search, e.g. MongoDB's $elemMatch operator.

We need to make a patch on the Hibernate v6.6 to tap into the power of unnest. This might be challenging for it involves deep code analysis and experimenting.