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

Resolving SQL to HQL Translation Issues: A Step-by-Step Guide