the alternative syntax of select: with ALIAS1 as (select ...), ALIAS2 as (select ...),... select ... from ALIAS1, ... ALIAS2
"with <common_table_expression>" is an alternate syntax that can be useful as select output. This syntax can work recursive or not based on the SQL dialect.
Here is a link: https://docs.microsoft.com/en-us/sql/t-sql/queries/with-common-table-expression-transact-sql?view=sql-server-2017
Is it possible to obtain that?
Yes, it is possible. You must use MSSQLSyntaxProvider to obtain that.
queryBuilder1.SyntaxProvider = new MSSQLSyntaxProvider();
More details here: What are the Syntax and Metadata providers for?