In Hibernate 6, the generated SQL is:
select p1_0.id from Parent p1_0 join Child c1_0 on p1_0.id=c1_0.parent_id where c1_0.id is null
So this problem has been fixed, and the issue may now be closed.