I’m working on a project using Spring Data JPA, and I have some complex relationships between entities that JPA doesn’t seem to handle well. I’m looking for the best approach to implement repositories for these types of relationships. Specifically, I’m considering the following options:

Writing custom queries using @Query: Using JPQL or SQL queries directly in the repository code.
Using Hibernate-specific features,Using the Criteria API

Which of these approaches is most better for handling complex relationships in JPA

I found that using custom queries with @Query annotation can be good way to handle complex relationships in JPA

    @Query("SELECT a FROM Author a JOIN a.books b WHERE LOWER(b.title) LIKE LOWER(CONCAT('%', :title, '%'))")
    Page<Author> findAllByBookTitleIsLikeIgnoreCase(@Param("title") String title, Pageable pageable);