Custom Queries

Write custom JPQL and native SQL queries.

JPQL Queries

@Query("SELECT u FROM User u WHERE u.age > :age")
List<User> findUsersOlderThan(@Param("age") int age);

Native Queries

@Query(value = "SELECT * FROM users WHERE created_at > ?1", nativeQuery = true)
List<User> findRecentUsers(LocalDateTime since);

See Annotations for details.