Type Method

select(_:)

Create a SQLSubquery expression using an inline query builder.

static func select(_ build: (any SQLSubqueryClauseBuilder) throws -> any SQLSubqueryClauseBuilder) rethrows -> some SQLExpression

Discussion

Example usage:

try await db.update("foos")
    .set(SQLIdentifier("bar_id"), to: SQLSubquery.select { $0
        .column("id")
        .from("bars")
        .where("baz", .notEqual, "bamf")
    })
    .run()

Note

At this time, only SELECT subqueries are supported by the API.