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

Implementing Many-to-Many Relationships with Multi Where Clauses Using Elasticsearch and Hibernate