nhibernate multicriteria CTE subquery

Question

I currently have a MultiCriteria query, which filters the results based on the ids being within a sub query

Subqueries.PropertyIn("Id", detachedCriteria)

The sub query is the same for all queries used in the multicriteria query.

It seems a bit ugly looking at the sql that the sub query is repeated, in my current case 15 times.

The reason for the separate queries is each one has different joins, and don't want one massive Cartesian join.

If I was writing the sql by hand I would pull out the repeated sub query into a common table expression

WITH XYZ AS
{
    ....
}

and then the sub query would be where id in XYZ in the 15 queries.

This is a bit sql server specific, an alternative would be a temporary table, or other database specific feature.

Any ideas of how to improve the query, or am I stuck with the sub queries being duplicated?