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

Using Spring Data JPA's "ON DUPLICATE KEY UPDATE" Feature with Identity Columns for Efficient Database Updates

Fixing Null Values in Spring Boot's `findAllByUsername` Method Using Native Queries