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

Transforming Native SQL to JPQL: Leveraging CTEs and `@SqlResultSetMapping`