Understanding Custom Sorting Parameters with ORDER BY

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