Resolving Collation Conflicts When Auto-Updating Database Schemas with Hibernate

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