Use a native SQL subquery within a HQL query?

Question

I would want to create a HQL query with a native SQL subquery. It's possible to use a HQL subquery within a HQL query but what about a native SQL subquery within a HQl query ? Cause, in hibernate, we use session.createQuery to create a HQL query and session.createSQLQuery to create a native SQL query.

Answer 1

There is no way to mix both HQL and SQL. You can't. Execute them separately and use it with one another. That is the only way.