Wraps the query as a derived table, SELECT * FROM (query) AS alias. Leading CTEs are hoisted
out first (a WITH cannot sit inside a derived table on SQL Server), the query-hint clause moves
to the outer query, and the ORDER BY is handled by WrapOptions.OrderBy. Not applied to
a query with FOR JSON / FOR XML or a row-locking clause.
Wraps the query as a derived table,
SELECT * FROM (query) AS alias. Leading CTEs are hoisted out first (a WITH cannot sit inside a derived table on SQL Server), the query-hint clause moves to the outer query, and the ORDER BY is handled by WrapOptions.OrderBy. Not applied to a query withFOR JSON/FOR XMLor a row-locking clause.