ScalarColumnExpression

public struct ScalarColumnExpression : Field

An expression containing a scalar function applied on a column.

  • The alias of the field.

    Declaration

    Swift

    public var alias: String?
  • The scalar function to apply.

    Declaration

    Swift

    public private(set) var function: ScalarFunction { get }
  • Build the query component using QueryBuilder.

    Throws

    QueryError.syntaxError if query build fails.

    Declaration

    Swift

    public func build(queryBuilder: QueryBuilder) throws -> String

    Parameters

    queryBuilder

    The QueryBuilder to use.

    Return Value

    A String representation of the query component.

  • An enumeration of the supported scalar functions that can applied on a column.

    See more

    Declaration

    Swift

    public enum ScalarFunction : Buildable
  • Create a Filter clause using the like operator.

    Declaration

    Swift

    public func like(_ pattern: String) -> Filter

    Parameters

    pattern

    The pattern to use in the like expression.

    Return Value

    A Filter containing the clause.

  • Create a Filter clause using the like operator with Parameter.

    Declaration

    Swift

    public func like(_ pattern: Parameter) -> Filter

    Parameters

    pattern

    The pattern to use in the like expression as Parameter.

    Return Value

    A Filter containing the clause.

  • Create a Filter clause using the notLike operator.

    Declaration

    Swift

    public func notLike(_ pattern: String) -> Filter

    Parameters

    pattern

    The pattern to use in the notLike expression.

    Return Value

    A Filter containing the clause.

  • Create a Filter clause using the notLike operator with Parameter.

    Declaration

    Swift

    public func notLike(_ pattern: Parameter) -> Filter

    Parameters

    pattern

    The pattern to use in the notLike expression as Parameter.

    Return Value

    A Filter containing the clause.

  • Create a Filter clause using the between operator for Bool.

    Declaration

    Swift

    public func between(_ value1: Bool, and value2: Bool) -> Filter

    Parameters

    value1

    The left hand side of the between expression.

    Return Value

    A Filter containing the clause.

  • Create a Filter clause using the notBetween operator for Bool.

    Declaration

    Swift

    public func notBetween(_ value1: Bool, and value2: Bool) -> Filter

    Parameters

    value1

    The left hand side of the notBetween expression.

    Return Value

    A Filter containing the clause.

  • Create a Filter clause using the in operator for Bool.

    Declaration

    Swift

    public func `in`(_ values: Bool...) -> Filter

    Parameters

    values

    The list of values for the in expression.

    Return Value

    A Filter containing the clause.

  • Create a Filter clause using the in operator for Bool.

    Declaration

    Swift

    public func `in`(_ values: [Bool]) -> Filter

    Parameters

    values

    An array of values for the in expression.

    Return Value

    A Filter containing the clause.

  • Create a Filter clause using the notIn operator for Bool.

    Declaration

    Swift

    public func notIn(_ values: Bool...) -> Filter

    Parameters

    values

    The list of values for the notIn expression.

    Return Value

    A Filter containing the clause.

  • Create a Filter clause using the notIn operator for Bool.

    Declaration

    Swift

    public func notIn(_ values: [Bool]) -> Filter

    Parameters

    values

    An array of values for the notIn expression.

    Return Value

    A Filter containing the clause.

  • Create a Filter clause using the between operator for String.

    Declaration

    Swift

    public func between(_ value1: String, and value2: String) -> Filter

    Parameters

    value1

    The left hand side of the between expression.

    Return Value

    A Filter containing the clause.

  • Create a Filter clause using the notBetween operator for String.

    Declaration

    Swift

    public func notBetween(_ value1: String, and value2: String) -> Filter

    Parameters

    value1

    The left hand side of the notBetween expression.

    Return Value

    A Filter containing the clause.

  • Create a Filter clause using the in operator for String.

    Declaration

    Swift

    public func `in`(_ values: String...) -> Filter

    Parameters

    values

    The list of values for the in expression.

    Return Value

    A Filter containing the clause.

  • Create a Filter clause using the in operator for String.

    Declaration

    Swift

    public func `in`(_ values: [String]) -> Filter

    Parameters

    values

    An array of values for the in expression.

    Return Value

    A Filter containing the clause.

  • Create a Filter clause using the notIn operator for String.

    Declaration

    Swift

    public func notIn(_ values: String...) -> Filter

    Parameters

    values

    The list of values for the notIn expression.

    Return Value

    A Filter containing the clause.

  • Create a Filter clause using the notIn operator for String.

    Declaration

    Swift

    public func notIn(_ values: [String]) -> Filter

    Parameters

    values

    An array of values for the notIn expression.

    Return Value

    A Filter containing the clause.

  • Create a Filter clause using the between operator for Int.

    Declaration

    Swift

    public func between(_ value1: Int, and value2: Int) -> Filter

    Parameters

    value1

    The left hand side of the between expression.

    Return Value

    A Filter containing the clause.

  • Create a Filter clause using the notBetween operator for Int.

    Declaration

    Swift

    public func notBetween(_ value1: Int, and value2: Int) -> Filter

    Parameters

    value1

    The left hand side of the notBetween expression.

    Return Value

    A Filter containing the clause.

  • Create a Filter clause using the in operator for Int.

    Declaration

    Swift

    public func `in`(_ values: Int...) -> Filter

    Parameters

    values

    The list of values for the in expression.

    Return Value

    A Filter containing the clause.

  • Create a Filter clause using the in operator for Int.

    Declaration

    Swift

    public func `in`(_ values: [Int]) -> Filter

    Parameters

    values

    An array of values for the in expression.

    Return Value

    A Filter containing the clause.

  • Create a Filter clause using the notIn operator for Int.

    Declaration

    Swift

    public func notIn(_ values: Int...) -> Filter

    Parameters

    values

    The list of values for the notIn expression.

    Return Value

    A Filter containing the clause.

  • Create a Filter clause using the notIn operator for Int.

    Declaration

    Swift

    public func notIn(_ values: [Int]) -> Filter

    Parameters

    values

    An array of values for the notIn expression.

    Return Value

    A Filter containing the clause.

  • Create a Filter clause using the between operator for Float.

    Declaration

    Swift

    public func between(_ value1: Float, and value2: Float) -> Filter

    Parameters

    value1

    The left hand side of the between expression.

    Return Value

    A Filter containing the clause.

  • Create a Filter clause using the notBetween operator for Float.

    Declaration

    Swift

    public func notBetween(_ value1: Float, and value2: Float) -> Filter

    Parameters

    value1

    The left hand side of the notBetween expression.

    Return Value

    A Filter containing the clause.

  • Create a Filter clause using the in operator for Float.

    Declaration

    Swift

    public func `in`(_ values: Float...) -> Filter

    Parameters

    values

    The list of values for the in expression.

    Return Value

    A Filter containing the clause.

  • Create a Filter clause using the in operator for Float.

    Declaration

    Swift

    public func `in`(_ values: [Float]) -> Filter

    Parameters

    values

    An array of values for the in expression.

    Return Value

    A Filter containing the clause.

  • Create a Filter clause using the notIn operator for Float.

    Declaration

    Swift

    public func notIn(_ values: Float...) -> Filter

    Parameters

    values

    The list of values for the notIn expression.

    Return Value

    A Filter containing the clause.

  • Create a Filter clause using the notIn operator for Float.

    Declaration

    Swift

    public func notIn(_ values: [Float]) -> Filter

    Parameters

    values

    An array of values for the notIn expression.

    Return Value

    A Filter containing the clause.

  • Create a Filter clause using the between operator for Double.

    Declaration

    Swift

    public func between(_ value1: Double, and value2: Double) -> Filter

    Parameters

    value1

    The left hand side of the between expression.

    Return Value

    A Filter containing the clause.

  • Create a Filter clause using the notBetween operator for Double.

    Declaration

    Swift

    public func notBetween(_ value1: Double, and value2: Double) -> Filter

    Parameters

    value1

    The left hand side of the notBetween expression.

    Return Value

    A Filter containing the clause.

  • Create a Filter clause using the in operator for Double.

    Declaration

    Swift

    public func `in`(_ values: Double...) -> Filter

    Parameters

    values

    The list of values for the in expression.

    Return Value

    A Filter containing the clause.

  • Create a Filter clause using the in operator for Double.

    Declaration

    Swift

    public func `in`(_ values: [Double]) -> Filter

    Parameters

    values

    An array of values for the in expression.

    Return Value

    A Filter containing the clause.

  • Create a Filter clause using the notIn operator for Double.

    Declaration

    Swift

    public func notIn(_ values: Double...) -> Filter

    Parameters

    values

    The list of values for the notIn expression.

    Return Value

    A Filter containing the clause.

  • Create a Filter clause using the notIn operator for Double.

    Declaration

    Swift

    public func notIn(_ values: [Double]) -> Filter

    Parameters

    values

    An array of values for the notIn expression.

    Return Value

    A Filter containing the clause.

  • Create a Filter clause using the between operator for Parameter.

    Declaration

    Swift

    public func between(_ value1: Parameter, and value2: Parameter) -> Filter

    Parameters

    value1

    The left hand side of the between expression.

    Return Value

    A Filter containing the clause.

  • Create a Filter clause using the notBetween operator for Parameter.

    Declaration

    Swift

    public func notBetween(_ value1: Parameter, and value2: Parameter) -> Filter

    Parameters

    value1

    The left hand side of the notBetween expression.

    Return Value

    A Filter containing the clause.

  • Create a Filter clause using the in operator for Parameter.

    Declaration

    Swift

    public func `in`(_ values: Parameter...) -> Filter

    Parameters

    values

    The list of values for the in expression.

    Return Value

    A Filter containing the clause.

  • Create a Filter clause using the in operator for Parameter.

    Declaration

    Swift

    public func `in`(_ values: [Parameter]) -> Filter

    Parameters

    values

    An array of values for the in expression.

    Return Value

    A Filter containing the clause.

  • Create a Filter clause using the notIn operator for Parameter.

    Declaration

    Swift

    public func notIn(_ values: Parameter...) -> Filter

    Parameters

    values

    The list of values for the notIn expression.

    Return Value

    A Filter containing the clause.

  • Create a Filter clause using the notIn operator for Parameter.

    Declaration

    Swift

    public func notIn(_ values: [Parameter]) -> Filter

    Parameters

    values

    An array of values for the notIn expression.

    Return Value

    A Filter containing the clause.

  • Create a Filter clause using the between operator for Date.

    Declaration

    Swift

    public func between(_ value1: Date, and value2: Date) -> Filter

    Parameters

    value1

    The left hand side of the between expression.

    Return Value

    A Filter containing the clause.

  • Create a Filter clause using the notBetween operator for Date.

    Declaration

    Swift

    public func notBetween(_ value1: Date, and value2: Date) -> Filter

    Parameters

    value1

    The left hand side of the notBetween expression.

    Return Value

    A Filter containing the clause.

  • Create a Filter clause using the in operator for Date.

    Declaration

    Swift

    public func `in`(_ values: Date...) -> Filter

    Parameters

    values

    The list of values for the in expression.

    Return Value

    A Filter containing the clause.

  • Create a Filter clause using the in operator for Date.

    Declaration

    Swift

    public func `in`(_ values: [Date]) -> Filter

    Parameters

    values

    An array of values for the in expression.

    Return Value

    A Filter containing the clause.

  • Create a Filter clause using the notIn operator for Date.

    Declaration

    Swift

    public func notIn(_ values: Date...) -> Filter

    Parameters

    values

    The list of values for the notIn expression.

    Return Value

    A Filter containing the clause.

  • Create a Filter clause using the notIn operator for Date.

    Declaration

    Swift

    public func notIn(_ values: [Date]) -> Filter

    Parameters

    values

    An array of values for the notIn expression.

    Return Value

    A Filter containing the clause.

  • Create a Filter clause using the isNull operator.

    Declaration

    Swift

    public func isNull() -> Filter

    Return Value

    A Filter containing the clause.

  • Create a Filter clause using the isNotNull operator.

    Declaration

    Swift

    public func isNotNull() -> Filter

    Return Value

    A Filter containing the clause.

  • Create a Filter clause using the in operator for subquery.

    Declaration

    Swift

    public func `in`(_ query: Select) -> Filter

    Parameters

    query

    The subquery.

    Return Value

    A Filter containing the clause.

  • Create a Filter clause using the notIn operator for subquery.

    Declaration

    Swift

    public func notIn(_ query: Select) -> Filter

    Parameters

    query

    The subquery.

    Return Value

    A Filter containing the clause.