Is it possible to write HQL with with clause how to write the With clause in HQL. Example below query.