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

Fixing the Join Alias Quirk in Hibernate Query Language: A Deep Dive into Resolving HQL Errors