HQL supports two forms of association joining: implicit and explicit.
The queries shown in the previous section all use the explicit form 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%'