JPA/Hibernate stores should perform left outer joins when sorting.

[aklish]

Expected Behavior

If sorting on book.publisher.name, Elide currently uses JPQL's implicit join syntax (which performs inner joins):

HQL supports two forms of association joining: implicit and explicit.

The queries shown in the previous section all use the explicit form, that is, where the join keyword is explicitly used in the from clause. This is the recommended form.

The implicit form does not use the join keyword. Instead, the associations are "dereferenced" using dot-notation. implicit joins can appear in any of the HQL clauses. implicit join result in inner joins in the resulting SQL statement.

from Cat as cat where cat.mate.name like '%s%'

If the publisher is null, Elide will not return those records. Instead, Elide should return all records including those where one of the relationships is null.

Possible Solution

A possible solution is to modify the JPQL query to build explicit join clauses similar to how filter joins currently work.