JPQL and Native Queries

For complex queries, use @Query. You can write JPQL (Java Persistence Query Language) or standard SQL (Native Queries) directly above your repository methods.