title: JPQL query - hibernate: with-clause not allowed on fetched associations
body: <p>I have JPA Repository and JPQL query like this:</p>
  
  <pre><code>@Query("SELECT c from Campaign c" +
          " left join fetch c.postsList p on p.status = :postStatus" +
          " left join fetch p.platform" +
          " left join fetch c.campaignStatistics stat on stat.updateDate = :updateDate" +
          " where c.id =:id")
  Campaign findCampaignWithPosts(
          @Param("id") Long id,
          @Param("postStatus") PostStatus postStatus,
          @Param("updateDate") LocalDate updateDate);
  </code></pre>
  
  <p>But it doesn' work. I get:</p>
  
  <pre><code>org.hibernate.hql.internal.ast.QuerySyntaxException: with-clause not allowed on fetched associations; use filters
  </code></pre>
  
  <p>I went to study information about the JPA 2.1 specification and that's what I found:</p>
  
  <blockquote>
    <p>The join condition used for a join comes from the mapping's join
    columns. This means that the JPQL user is normally free from having to
    know how every relationship is joined. In some cases it is desirable
    to append additional conditions to the join condition, normally in the
    case of outer joins. This can be done through the ON clause. The ON
    clause is defined in the JPA 2.1 specifiation, and may be supported by
    some JPA providers.
    EclipseLink : Hibernate : TopLink - support the ON clause.</p>
  </blockquote>
  
  <p>It should be noted that this type of query does not help me at all, becouse in this query sometimes i get null, where clause use after join tables.</p>
  
  <pre><code>   @Query("SELECT c from Campaign c" +
              " left join fetch c.postsList p" +
              " left join fetch p.platform" +
              " left join fetch c.campaignStatistics stat" +
              " where c.id =:id" +
              " and p.status = :postStatus" +
              " and stat.updateDate = :updateDate")
  </code></pre>
  
  <p>What to do in this case? Is there no alternative solution other than how to use the native query? But then the meaning of almost all JPQL queries is lost.
  I use hibernate version 5.2.12</p>