[heurisko]

The ORM vs SQL debate is a false dichotomy, at least if you take Hibernate as an example.

You can use a combination of JPQL, native SQL, and object mapping. There's nothing stopping you from mixing and matching.

You can use an ORM to save entities, and using native SQL to retrieve projections, Spring Data makes this easy, as it will do the mapping, if you provide an interface.