compile method
Implementation
String compile(MssqlParameterAllocator parameters, MssqlDialect dialect) {
final buffer = StringBuffer(MssqlSql.quoteIdentifier(name));
if (columns.isNotEmpty) {
buffer.write(' (${columns.map(MssqlSql.quoteIdentifier).join(', ')})');
}
// nested: true — a member cannot carry its own ordering, and the compiler
// says so rather than letting the server reject it.
buffer.write(
' AS (${query.compileInto(parameters, dialect, nested: true)})',
);
return buffer.toString();
}