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

Retrieving Last N Rows with Spring Boot JpaRepository: A Deep Dive