Subqueries, lateral joins, and arrays. HQL is growing into a rather powerful query language.