Could you do a query with subqueries like this with nhibernate?

Question

If you had a query that looks like this, could it be converted into a nhibernate query?

SELECT ....
FROM
(
   SELECT ...
   FROM ...
   GROUP BY...
   ORDER BY ...

   UNION

   SELECT ..
   FROM ...
)
AS ASDF
GROUP BY ...
ORDER BY ...

Answer 1

With hibernate you can do native SQL queries. You just need to create a named Sql query mapping, and map it to a class.

However, you will not get the benefit of writing to the named query. [Which is to be expected]