SQLSpecificExpressible

public protocol SQLSpecificExpressible : SQLExpressible, SQLOrderingTerm, SQLSelectable

SQLSpecificExpressible is a protocol for all database-specific types that can be turned into an SQL expression. Types whose existence is not purely dedicated to the database 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.

Show on GitHub

SQLExpressible

sqlSelection Extension method
Declaration
Swift

public var sqlSelection: SQLSelection { get }
Show on GitHub
sqlOrdering Extension method
Declaration
Swift

public var sqlOrdering: SQLOrdering { get }
Show on GitHub

SQL Ordering Support

asc Extension method
Returns 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: SQLOrdering { get }
Show on GitHub
desc Extension method
Returns 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: SQLOrdering { get }
Show on GitHub
ascNullsLast Extension method

Returns a value that can be used as an argument to QueryInterfaceRequest.order()

See https://github.com/groue/GRDB.swift/#the-query-interface
descNullsFirst Extension method

Returns a value that can be used as an argument to QueryInterfaceRequest.order()

See https://github.com/groue/GRDB.swift/#the-query-interface
ascNullsLast Extension method
Returns a value that can be used as an argument to QueryInterfaceRequest.order()

See https://github.com/groue/GRDB.swift/#the-query-interface
Declaration
Swift

@available(macOS 11.0, iOS 14, tvOS 14, watchOS 7, *) public var ascNullsLast: SQLOrdering { get }
Show on GitHub
descNullsFirst Extension method
Returns a value that can be used as an argument to QueryInterfaceRequest.order()

See https://github.com/groue/GRDB.swift/#the-query-interface
Declaration
Swift

@available(macOS 11.0, iOS 14, tvOS 14, watchOS 7, *) public var descNullsFirst: SQLOrdering { get }
Show on GitHub

SQL Collations Support


                    
                    
                    collating(_:)

Extension method

Returns a collated expression.

For example:

Player.filter(Column("email").collating(.nocase) == "contact@example.com")

Declaration

Swift

public func collating(_ collation: Database.CollationName) -> SQLExpression

Show on GitHub


                    
                    
                    collating(_:)

Extension method

Returns a collated expression.

For example:

Player.filter(Column("name").collating(.localizedStandardCompare) == "Hervé")

Declaration

Swift

public func collating(_ collation: DatabaseCollation) -> SQLExpression

Show on GitHub

Like Operator


                    
                    
                    like(_:escape:)

Extension method

An SQL expression with the LIKE SQL operator.

// email LIKE '%@example.com"
Column("email").like("%@example.com")

// title LIKE '%10\%%' ESCAPE '\'
Column("title").like("%10\\%%", escape: "\\")

Declaration

Swift

public func like(_ pattern: SQLExpressible, escape: SQLExpressible? = nil) -> SQLExpression

Show on GitHub