withCte method

MssqlQuery withCte(
  1. String name,
  2. MssqlSelectQuery query, {
  3. List<String> columns = const <String>[],
})

Prefixes the query with a common table expression.

The name is then an ordinary source: MssqlQuery.from('tree'), or a join target. Repeated calls add further expressions, each able to refer to the ones named before it.

Not called with, which is a reserved word in Dart.

Implementation

MssqlQuery withCte(
  String name,
  MssqlSelectQuery query, {
  List<String> columns = const <String>[],
}) => withExpression(MssqlCte(name, query, columns: columns));