Selecting Data from Multiple Tables Based on One-to-Many Relations in SQL

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