JPQL Complex One to Many Join Query Result Using Java Persistence API (JPA)

Understanding Native Queries with Spring JPA and Mapping Results to Non-Model Classes