Structuregrdb 7.3.0GRDB
AnySQLJSONExpressible
A type-erased SQLJSONExpressible.
struct AnySQLJSONExpressibleA type-erased SQLJSONExpressible.
struct AnySQLJSONExpressibleimport GRDBA toolkit for SQLite databases, with a focus on application development
protocol SQLJSONExpressible : SQLSpecificExpressibleA type of SQL expression that is interpreted as a JSON value.
protocol SQLExpressibleA type that can be used as an SQL expression.
protocol SQLOrderingTermA type that can be used as an SQL ordering term.
protocol SQLSelectableA type that can be used as SQL result columns.
protocol SQLSpecificExpressible : SQLExpressible, SQLOrderingTerm, SQLSelectableA database-specific type that can be used as an SQL expression.
init(_ base: some SQLJSONExpressible) let sqlExpression: SQLExpressionAn SQL expression that is interpreted as a JSON value.
var asJSON: AnySQLJSONExpressible { get }Returns an expression that is interpreted as a JSON value.
var asc: SQLOrdering { get }An ordering term for ascending order (nulls first).
var ascNullsLast: SQLOrdering { get }An ordering term for ascending order (nulls last).
var capitalized: SQLExpression { get }An SQL expression that calls the Foundation String.capitalized property.
var desc: SQLOrdering { get }An ordering term for descending order (nulls last).
var descNullsFirst: SQLOrdering { get }An ordering term for descending order (nulls first).
var localizedCapitalized: SQLExpression { get }An SQL expression that calls the Foundation String.localizedCapitalized property.
var localizedLowercased: SQLExpression { get }An SQL expression that calls the Foundation String.localizedLowercase property.
var localizedUppercased: SQLExpression { get }An SQL expression that calls the Foundation String.localizedUppercase property.
var lowercased: SQLExpression { get }An SQL expression that calls the Swift String.lowercased() method.
var sqlOrdering: SQLOrdering { get }var sqlSelection: SQLSelection { get }var uppercased: SQLExpression { get }An SQL expression that calls the Swift String.uppercased() method.
subscript(path: some SQLExpressible) -> SQLExpression { get } The ->> SQL operator.
static func ! (value: Self) -> SQLExpression A negated logical SQL expression.
static func != (lhs: (any SQLExpressible)?, rhs: Self) -> SQLExpression Compares two SQL expressions.
static func != (lhs: Bool, rhs: Self) -> SQLExpression The <> SQL operator.
static func != (lhs: Self, rhs: (any SQLExpressible)?) -> SQLExpression Compares two SQL expressions.
static func != (lhs: Self, rhs: Bool) -> SQLExpression The <> SQL operator.
static func != (lhs: Self, rhs: some SQLSpecificExpressible) -> SQLExpression The <> SQL operator.
static func !== (lhs: (any SQLExpressible)?, rhs: Self) -> SQLExpression The IS NOT SQL operator.
static func !== (lhs: Self, rhs: (any SQLExpressible)?) -> SQLExpression The IS NOT SQL operator.
static func !== (lhs: Self, rhs: some SQLSpecificExpressible) -> SQLExpression The IS NOT SQL operator.
static func && (lhs: some SQLExpressible, rhs: Self) -> SQLExpression The AND SQL operator.
static func && (lhs: Self, rhs: some SQLExpressible) -> SQLExpression The AND SQL operator.
static func && (lhs: Self, rhs: some SQLSpecificExpressible) -> SQLExpression The AND SQL operator.
static func & (lhs: some SQLExpressible, rhs: Self) -> SQLExpression The & SQL operator.
static func & (lhs: Self, rhs: some SQLExpressible) -> SQLExpression The & SQL operator.
static func & (lhs: Self, rhs: some SQLSpecificExpressible) -> SQLExpression The & SQL operator.
static func * (lhs: some SQLExpressible, rhs: Self) -> SQLExpression The * SQL operator.
static func * (lhs: Self, rhs: some SQLExpressible) -> SQLExpression The * SQL operator.
static func * (lhs: Self, rhs: some SQLSpecificExpressible) -> SQLExpression The * SQL operator.
static func + (lhs: some SQLExpressible, rhs: Self) -> SQLExpression The + SQL operator.
static func + (lhs: Self, rhs: some SQLExpressible) -> SQLExpression The + SQL operator.
static func + (lhs: Self, rhs: some SQLSpecificExpressible) -> SQLExpression The + SQL operator.
static func - (value: Self) -> SQLExpression The - SQL operator.
static func - (lhs: some SQLExpressible, rhs: Self) -> SQLExpression The - SQL operator.
static func - (lhs: Self, rhs: some SQLExpressible) -> SQLExpression The - SQL operator.
static func - (lhs: Self, rhs: some SQLSpecificExpressible) -> SQLExpression The - SQL operator.
static func / (lhs: some SQLExpressible, rhs: Self) -> SQLExpression The / SQL operator.
static func / (lhs: Self, rhs: some SQLExpressible) -> SQLExpression The / SQL operator.
static func / (lhs: Self, rhs: some SQLSpecificExpressible) -> SQLExpression The / SQL operator.
static func < (lhs: some SQLExpressible, rhs: Self) -> SQLExpression The < SQL operator.
static func < (lhs: Self, rhs: some SQLExpressible) -> SQLExpression The < SQL operator.
static func < (lhs: Self, rhs: some SQLSpecificExpressible) -> SQLExpression The < SQL operator.
static func << (lhs: some SQLExpressible, rhs: Self) -> SQLExpression The << SQL operator.
static func << (lhs: Self, rhs: some SQLExpressible) -> SQLExpression The << SQL operator.
static func << (lhs: Self, rhs: some SQLSpecificExpressible) -> SQLExpression The << SQL operator.
static func <= (lhs: some SQLExpressible, rhs: Self) -> SQLExpression The <= SQL operator.
static func <= (lhs: Self, rhs: some SQLExpressible) -> SQLExpression The <= SQL operator.
static func <= (lhs: Self, rhs: some SQLSpecificExpressible) -> SQLExpression The <= SQL operator.
static func == (lhs: (any SQLExpressible)?, rhs: Self) -> SQLExpression Compares two SQL expressions.
static func == (lhs: Bool, rhs: Self) -> SQLExpression The = SQL operator.
static func == (lhs: Self, rhs: (any SQLExpressible)?) -> SQLExpression Compares two SQL expressions.
static func == (lhs: Self, rhs: Bool) -> SQLExpression The = SQL operator.
static func == (lhs: Self, rhs: some SQLSpecificExpressible) -> SQLExpression The = SQL operator.
static func === (lhs: (any SQLExpressible)?, rhs: Self) -> SQLExpression The IS SQL operator.
static func === (lhs: Self, rhs: (any SQLExpressible)?) -> SQLExpression The IS SQL operator.
static func === (lhs: Self, rhs: some SQLSpecificExpressible) -> SQLExpression The IS SQL operator.
static func > (lhs: some SQLExpressible, rhs: Self) -> SQLExpression The > SQL operator.
static func > (lhs: Self, rhs: some SQLExpressible) -> SQLExpression The > SQL operator.
static func > (lhs: Self, rhs: some SQLSpecificExpressible) -> SQLExpression The > SQL operator.
static func >= (lhs: some SQLExpressible, rhs: Self) -> SQLExpression The >= SQL operator.
static func >= (lhs: Self, rhs: some SQLExpressible) -> SQLExpression The >= SQL operator.
static func >= (lhs: Self, rhs: some SQLSpecificExpressible) -> SQLExpression The >= SQL operator.
static func >> (lhs: some SQLExpressible, rhs: Self) -> SQLExpression The >> SQL operator.
static func >> (lhs: Self, rhs: some SQLExpressible) -> SQLExpression The >> SQL operator.
static func >> (lhs: Self, rhs: some SQLSpecificExpressible) -> SQLExpression The >> SQL operator.
static func ?? (lhs: Self, rhs: some SQLExpressible) -> SQLExpression The IFNULL SQL function.
static func | (lhs: some SQLExpressible, rhs: Self) -> SQLExpression The | SQL operator.
static func | (lhs: Self, rhs: some SQLExpressible) -> SQLExpression The | SQL operator.
static func | (lhs: Self, rhs: some SQLSpecificExpressible) -> SQLExpression The | SQL operator.
static func || (lhs: some SQLExpressible, rhs: Self) -> SQLExpression The OR SQL operator.
static func || (lhs: Self, rhs: some SQLExpressible) -> SQLExpression The OR SQL operator.
static func || (lhs: Self, rhs: some SQLSpecificExpressible) -> SQLExpression The OR SQL operator.
static func ~ (value: Self) -> SQLExpression The ~ SQL operator.
func collating(_ collation: DatabaseCollation) -> SQLExpression Returns a collated expression.
func collating(_ collation: Database.CollationName) -> SQLExpression Returns a collated expression.
func forKey(_ key: String) -> SQLSelection Returns an aliased result column.
func jsonExtract(atPath path: some SQLExpressible) -> SQLExpression The JSON_EXTRACT SQL function.
func jsonExtract(atPaths paths: some Collection<some SQLExpressible>) -> SQLExpression The JSON_EXTRACT SQL function.
func jsonRepresentation(atPath path: some SQLExpressible) -> SQLExpression Returns a valid JSON string with the -> SQL operator.
func like(_ pattern: some SQLExpressible, escape: (any SQLExpressible)? = nil) -> SQLExpression The LIKE SQL operator.