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 method

    Returns 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
    Show on GitHub
  • lowercased Extension method

    Returns 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
    Show on GitHub
  • uppercased Extension method

    Returns 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
    Show on GitHub
  • localizedCapitalized Extension method

    Returns 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
    Show on GitHub
  • localizedLowercased Extension method

    Returns 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
    Show on GitHub
  • localizedUppercased Extension method

    Returns 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
    Show on GitHub