SQLSubqueryable

public protocol SQLSubqueryable : SQLSpecificExpressible

The protocol for types that can be embedded as a subquery.

Show on GitHub

SQLSubqueryable

  • sqlExpression Extension method

    Returns a subquery expression.

    Declaration

    Swift

    public var sqlExpression: SQLExpression { get }
    Show on GitHub
  • contains(_:) Extension method

    Returns an expression that checks the inclusion of the expression in the subquery.

    // 1000 IN (SELECT score FROM player)
let request = Player.select(Column("score"), as: Int.self)
let condition = request.contains(1000)

    Declaration

    Swift

    public func contains(_ element: SQLExpressible) -> SQLExpression
    Show on GitHub
  • contains(_:) Extension method

    Returns an expression that checks the inclusion of the expression in the subquery.

    // name COLLATE NOCASE IN (SELECT name FROM player)
let request = Player.select(Column("name"), as: String.self)
let condition = request.contains(Column("name").collating(.nocase))

    Declaration

    Swift

    public func contains(_ element: SQLCollatedExpression) -> SQLExpression
    Show on GitHub