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

Case Where Clause of JPQL is not Working as Expected