AggregateColumnExpression

public struct AggregateColumnExpression : Field

An expression containing an aggregate function applied on a column.

  • The alias of the field.

    Declaration

    Swift

    public var alias: String?

  • The aggregate function to apply.

    Declaration

    Swift

    public private(set) var function: AggregateFunction { 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 aggregate functions that can applied on a column.

    See more

    Declaration

    Swift

    public enum AggregateFunction

  • Create a Having clause using the like operator.

    Declaration

    Swift

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

    Parameters

    pattern

    The pattern to use in the like expression.

    Return Value

    A Having containing the clause.

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

    Declaration

    Swift

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

    Parameters

    pattern

    The pattern to use in the like expression as Parameter.

    Return Value

    A Having containing the clause.

  • Create a Having clause using the notLike operator.

    Declaration

    Swift

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

    Parameters

    pattern

    The pattern to use in the notLike expression.

    Return Value

    A Having containing the clause.

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

    Declaration

    Swift

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

    Parameters

    pattern

    The pattern to use in the notLike expression as Parameter.

    Return Value

    A Having containing the clause.

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

    Declaration

    Swift

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

    Parameters

    value1

    The left hand side of the between expression.

    Return Value

    A Having containing the clause.

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

    Declaration

    Swift

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

    Parameters

    value1

    The left hand side of the notBetween expression.

    Return Value

    A Having containing the clause.

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

    Declaration

    Swift

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

    Parameters

    values

    The list of values for the in expression.

    Return Value

    A Having containing the clause.

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

    Declaration

    Swift

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

    Parameters

    values

    An array of values for the in expression.

    Return Value

    A Having containing the clause.

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

    Declaration

    Swift

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

    Parameters

    values

    The list of values for the notIn expression.

    Return Value

    A Having containing the clause.

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

    Declaration

    Swift

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

    Parameters

    values

    An array of values for the notIn expression.

    Return Value

    A Having containing the clause.

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

    Declaration

    Swift

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

    Parameters

    value1

    The left hand side of the between expression.

    Return Value

    A Having containing the clause.

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

    Declaration

    Swift

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

    Parameters

    value1

    The left hand side of the notBetween expression.

    Return Value

    A Having containing the clause.

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

    Declaration

    Swift

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

    Parameters

    values

    The list of values for the in expression.

    Return Value

    A Having containing the clause.

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

    Declaration

    Swift

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

    Parameters

    values

    An array of values for the in expression.

    Return Value

    A Having containing the clause.

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

    Declaration

    Swift

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

    Parameters

    values

    The list of values for the notIn expression.

    Return Value

    A Having containing the clause.

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

    Declaration

    Swift

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

    Parameters

    values

    An array of values for the notIn expression.

    Return Value

    A Having containing the clause.

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

    Declaration

    Swift

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

    Parameters

    value1

    The left hand side of the between expression.

    Return Value

    A Having containing the clause.

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

    Declaration

    Swift

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

    Parameters

    value1

    The left hand side of the notBetween expression.

    Return Value

    A Having containing the clause.

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

    Declaration

    Swift

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

    Parameters

    values

    The list of values for the in expression.

    Return Value

    A Having containing the clause.

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

    Declaration

    Swift

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

    Parameters

    values

    An array of values for the in expression.

    Return Value

    A Having containing the clause.

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

    Declaration

    Swift

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

    Parameters

    values

    The list of values for the notIn expression.

    Return Value

    A Having containing the clause.

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

    Declaration

    Swift

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

    Parameters

    values

    An array of values for the notIn expression.

    Return Value

    A Having containing the clause.

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

    Declaration

    Swift

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

    Parameters

    value1

    The left hand side of the between expression.

    Return Value

    A Having containing the clause.

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

    Declaration

    Swift

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

    Parameters

    value1

    The left hand side of the notBetween expression.

    Return Value

    A Having containing the clause.

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

    Declaration

    Swift

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

    Parameters

    values

    The list of values for the in expression.

    Return Value

    A Having containing the clause.

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

    Declaration

    Swift

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

    Parameters

    values

    An array of values for the in expression.

    Return Value

    A Having containing the clause.

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

    Declaration

    Swift

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

    Parameters

    values

    The list of values for the notIn expression.

    Return Value

    A Having containing the clause.

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

    Declaration

    Swift

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

    Parameters

    values

    An array of values for the notIn expression.

    Return Value

    A Having containing the clause.

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

    Declaration

    Swift

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

    Parameters

    value1

    The left hand side of the between expression.

    Return Value

    A Having containing the clause.

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

    Declaration

    Swift

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

    Parameters

    value1

    The left hand side of the notBetween expression.

    Return Value

    A Having containing the clause.

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

    Declaration

    Swift

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

    Parameters

    values

    The list of values for the in expression.

    Return Value

    A Having containing the clause.

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

    Declaration

    Swift

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

    Parameters

    values

    An array of values for the in expression.

    Return Value

    A Having containing the clause.

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

    Declaration

    Swift

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

    Parameters

    values

    The list of values for the notIn expression.

    Return Value

    A Having containing the clause.

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

    Declaration

    Swift

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

    Parameters

    values

    An array of values for the notIn expression.

    Return Value

    A Having containing the clause.

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

    Declaration

    Swift

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

    Parameters

    value1

    The left hand side of the between expression.

    Return Value

    A Having containing the clause.

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

    Declaration

    Swift

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

    Parameters

    value1

    The left hand side of the notBetween expression.

    Return Value

    A Having containing the clause.

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

    Declaration

    Swift

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

    Parameters

    values

    The list of values for the in expression.

    Return Value

    A Having containing the clause.

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

    Declaration

    Swift

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

    Parameters

    values

    An array of values for the in expression.

    Return Value

    A Having containing the clause.

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

    Declaration

    Swift

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

    Parameters

    values

    The list of values for the notIn expression.

    Return Value

    A Having containing the clause.

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

    Declaration

    Swift

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

    Parameters

    values

    An array of values for the notIn expression.

    Return Value

    A Having containing the clause.

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

    Declaration

    Swift

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

    Parameters

    value1

    The left hand side of the between expression.

    Return Value

    A Having containing the clause.

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

    Declaration

    Swift

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

    Parameters

    value1

    The left hand side of the notBetween expression.

    Return Value

    A Having containing the clause.

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

    Declaration

    Swift

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

    Parameters

    values

    The list of values for the in expression.

    Return Value

    A Having containing the clause.

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

    Declaration

    Swift

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

    Parameters

    values

    An array of values for the in expression.

    Return Value

    A Having containing the clause.

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

    Declaration

    Swift

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

    Parameters

    values

    The list of values for the notIn expression.

    Return Value

    A Having containing the clause.

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

    Declaration

    Swift

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

    Parameters

    values

    An array of values for the notIn expression.

    Return Value

    A Having containing the clause.

  • Create a Having clause using the isNull operator.

    Declaration

    Swift

    public func isNull() -> Having

    Return Value

    A Having containing the clause.

  • Create a Having clause using the isNotNull operator.

    Declaration

    Swift

    public func isNotNull() -> Having

    Return Value

    A Having containing the clause.

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

    Declaration

    Swift

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

    Parameters

    query

    The subquery.

    Return Value

    A Having containing the clause.

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

    Declaration

    Swift

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

    Parameters

    query

    The subquery.

    Return Value

    A Having containing the clause.