Instance Property

isRecursive

Indicates whether the CTE is recursive, e.g. whether its query is a UNION whose second subquery refers to the CTE’s own aliased name.

var isRecursive: Bool

Discussion

Warning

Neither SQLCommonTableExpression nor the methods of SQLCommonTableExpressionBuilder validate that a recursive CTE’s query takes the proper form, nor that a non-recursive CTE’s query is not self-referential. It is the responsibility of the user to specify the flag accurately. Failure to do so will result in generating invalid SQL.