The fix for HHH-5209 exposed (possibly caused, but not sure) a new issue with a "delete" query using a "member of".
The commit in question: https://github.com/hibernate/hibernate-orm/commit/95bc0194ec37738572c6b8202f1312f82622d747
Query, generated SQL before the commit, and generated SQL after the commit: https://gist.github.com/brmeyer/8434aee0de36e0639d0f