https://github.com/hibernate/hibernate-orm/blob/4.2.7.SP1/hibernate-core/src/test/java/org/hibernate/test/hql/WithClauseTest.java
list = s.createQuery( "from Human h inner join h.friends as f with f.nickName like 'bubba'" ).list();