SQLSpecificExpressible
public protocol SQLSpecificExpressible : SQLExpressible
This protocol is an implementation detail of the query interface. Do not use it directly.
See https://github.com/groue/GRDB.swift/#the-query-interface
Low Level Query Interface
SQLSpecificExpressible is a protocol for all query interface types that can be turned into an SQL expression. Other types whose existence is not purely dedicated to the query interface should adopt the SQLExpressible protocol instead.
For example, Column is a type that only exists to help you build requests, and it adopts SQLSpecificExpressible.
On the other side, Int adopts SQLExpressible (via DatabaseValueConvertible).
-
capitalized
Extension methodReturns an SQL expression that applies the Swift’s built-in capitalized String property. It is NULL for non-String arguments.
let nameColumn = Column("name") let request = Person.select(nameColumn.capitalized) let names = try String.fetchAll(dbQueue, request) // [String]
Declaration
Swift
public var capitalized: SQLExpression
-
lowercased
Extension methodReturns an SQL expression that applies the Swift’s built-in lowercased String property. It is NULL for non-String arguments.
let nameColumn = Column("name") let request = Person.select(nameColumn.lowercased()) let names = try String.fetchAll(dbQueue, request) // [String]
Declaration
Swift
public var lowercased: SQLExpression
-
uppercased
Extension methodReturns an SQL expression that applies the Swift’s built-in uppercased String property. It is NULL for non-String arguments.
let nameColumn = Column("name") let request = Person.select(nameColumn.uppercased()) let names = try String.fetchAll(dbQueue, request) // [String]
Declaration
Swift
public var uppercased: SQLExpression
-
localizedCapitalized
Extension methodReturns an SQL expression that applies the Swift’s built-in localizedCapitalized String property. It is NULL for non-String arguments.
let nameColumn = Column("name") let request = Person.select(nameColumn.localizedCapitalized) let names = try String.fetchAll(dbQueue, request) // [String]
Declaration
Swift
public var localizedCapitalized: SQLExpression
-
localizedLowercased
Extension methodReturns an SQL expression that applies the Swift’s built-in localizedLowercased String property. It is NULL for non-String arguments.
let nameColumn = Column("name") let request = Person.select(nameColumn.localizedLowercased) let names = try String.fetchAll(dbQueue, request) // [String]
Declaration
Swift
public var localizedLowercased: SQLExpression
-
localizedUppercased
Extension methodReturns an SQL expression that applies the Swift’s built-in localizedUppercased String property. It is NULL for non-String arguments.
let nameColumn = Column("name") let request = Person.select(nameColumn.localizedUppercased) let names = try String.fetchAll(dbQueue, request) // [String]
Declaration
Swift
public var localizedUppercased: SQLExpression
-
like(_:)
Extension methodAn SQL expression with the
LIKE
SQL operator.// email LIKE '%@example.com" Column("email").like("%@example.com")
Declaration
Swift
public func like(_ pattern: SQLExpressible) -> SQLExpression
-
asc
Extension methodReturns a value that can be used as an argument to QueryInterfaceRequest.order()
See https://github.com/groue/GRDB.swift/#the-query-interface
Declaration
Swift
public var asc: SQLOrderingTerm
-
desc
Extension methodReturns a value that can be used as an argument to QueryInterfaceRequest.order()
See https://github.com/groue/GRDB.swift/#the-query-interface
Declaration
Swift
public var desc: SQLOrderingTerm
-
aliased(_:)
Extension methodReturns a value that can be used as an argument to QueryInterfaceRequest.select()
See https://github.com/groue/GRDB.swift/#the-query-interface
Declaration
Swift
public func aliased(_ alias: String) -> SQLSelectable
-
collating(_:)
Extension methodThis method is an implementation detail of the query interface. Do not use it directly.
See https://github.com/groue/GRDB.swift/#the-query-interface
Declaration
Swift
public func collating(_ collation: Database.CollationName) -> SQLCollatedExpression
-
collating(_:)
Extension methodThis method is an implementation detail of the query interface. Do not use it directly.
See https://github.com/groue/GRDB.swift/#the-query-interface
Declaration
Swift
public func collating(_ collation: DatabaseCollation) -> SQLCollatedExpression