What query methods using the @Query annotation are available in your framework?

In Java frameworks such as Spring Data JPA, the @Query annotation allows you to define database queries in several ways:

• JPQL (Java Persistence Query Language) — queries at the entity level, for example:

@Query("SELECT u FROM User u WHERE u.email = ?1")
User findByEmail(String email);

• Native SQL queries — using the nativeQuery=true parameter:

@Query(value = "SELECT * FROM users WHERE email = ?1", nativeQuery = true)
User findByEmailNative(String email);

• Using named parameters:

@Query("SELECT u FROM User u WHERE u.email = :email")
User findByEmail(@Param("email") String email);

Thus, @Query provides flexibility for writing custom queries beyond standard repository methods.