SQLQueryBuilder

Swift

var expressions: [SQLExpression] { get set }

Swift

init()

Swift

func getQuery() -> SQLQuery

Swift

func create(
    table: String,
    ifNotExists: Bool = false,
    columns: Table.Column...,
    constraints: SQLConstraint...
) -> Self

Swift

func create(
    table: String,
    ifNotExists: Bool = false,
    columns: [Table.Column] = .init(),
    constraints: [SQLConstraint] = .init()
) -> Self

Swift

func insert(into table: String, columns: String..., values: Any?...) -> Self

Swift

func insert(into table: String, columns: [String] = .init(), values: [Any?]) -> Self

Swift

func update(table: String, values: (String, Codable?)...) -> Self

Swift

func update(table: String, values: [(String, Codable?)]) -> Self

Swift

func delete() -> Self

Swift

func select(_ columns: String...) -> Self

Swift

func select(_ columns: [String]) -> Self

Swift

func from(_ table: String, as alias: String?) -> Self

Swift

func from(_ tables: String...) -> Self

Swift

func from(_ tables: [String]) -> Self

Swift

func `where`(_ condition: String) -> Self

Swift

func andWhere(_ condition: String) -> Self

Swift

func orWhere(_ condition: String) -> Self

Swift

func having(_ condition: String) -> Self

Swift

func andHaving(_ condition: String) -> Self

Swift

func orHaving(_ condition: String) -> Self

Swift

func join(_ table: String, as alias: String? = nil, on condition: String) -> Self

Swift

func orderBy(_ columns: (String, SQLExpression.Sorting)...) -> Self

Swift

func orderBy(_ columns: [(String, SQLExpression.Sorting)]) -> Self

Swift

func returning(_ columns: String...) -> Self

Swift

func returning(_ columns: [String]) -> Self