Sequence<any SQLSpecificExpressible>

  • Returns an expression by joining all elements with an associative SQL binary operator.

    For example:

    // SELECT * FROM player
    // WHERE (registered
    //        AND (score >= 1000)
    //        AND (name IS NOT NULL))
    let conditions = [
        Column("registered"),
        Column("score") >= 1000,
        Column("name") != nil]
    Player.filter(conditions.joined(operator: .and))
    

    When the sequence is empty, joined(operator:) returns the neutral value of the operator. It is 0 (zero) for .add, 1 for ‘.multiply, false for.or, and true for.and`.