gistfile1.sql

LOG: Hibernate: select count(customer0_.uid) as col_0_0_ from customer customer0_ left outer join person person1_ on customer0_.person_uid=person1_.uid left outer join company company2_ on customer0_.company_uid=company2_.uid cross join person person3_ cross join company company4_ where customer0_.person_uid=person3_.uid and customer0_.company_uid=company4_.uid and (lower(person3_.name) like ? escape '!' or lower(company4_.name) like ? escape '!') limit ?

Java code:
 BooleanBuilder builder = new BooleanBuilder();
        builder.or(customer.person.name.containsIgnoreCase(query));
        builder.or(customer.company.name.containsIgnoreCase(query));

        JPQLQuery jpqlQuery = querydsl.createQuery(customer)
                .leftJoin(customer.person, person)
                .leftJoin(customer.company, company)
                .where(builder);
          
----      

jpqlQuery (in debug value) :
select customer
from Customer customer
  left join customer.person as person
  left join customer.company as company
where lower(customer.person.name) like ?1 escape '!' or lower(customer.company.name) like ?1 escape '!'