Subselect fetching isn’t widely used right now, but that’s probably because the way it’s exposed makes it almost useless. It should not be a static aspect of the mapping, but something more dynamic.

See: https://github.com/hibernate/hibernate-orm/discussions/6500