Skip to content

Structure

SQLList

A fundamental syntactical expression - a list of subexpresions with a specified “separator” subexpression.
struct SQLList

Overview

When serialized, an empty SQLList outputs nothing, a single-item SQLList outputs the serialization of that one expression, and all other SQLLists output the entire list of subexpressions joined by an appropriate number of copies of the separator subexpression. The default separator is SQLRaw(", ").

Examples:

print(database.serialize(SQLList(SQLLiteral.string("a"), SQLLiteral.string("b"))).sql)
// "'a', 'b'"
print(database.serialize(SQLList(SQLLiteral.string("a"), SQLLiteral.string("b"), separator: SQLBinaryOperator.and)).sql)
// "'a'AND'b'"
print(database.serialize(SQLList(SQLLiteral.string("a"), SQLLiteral.string("b"), separator: SQLRaw(" AND ")).sql)
// "'a' AND 'b'"

Topics

Initializers

Instance Properties

Instance Methods

Relationships

Conforms To

See Also

Syntactic Expressions

  • struct SQLBinaryExpression
    A fundamental syntactical expression - a left and right operand joined by an infix operator.
  • enum SQLBinaryOperator
    SQL binary expression operators.
  • struct SQLBind
    A parameterizied value bound to the SQL query.
  • struct SQLFunction
    A call to a function available in SQL, expressed as a name and a (possibly empty) list of arguments.
  • struct SQLGroupExpression
    A fundamental syntactical expression - an arbitrary expression or list of expressions, surroudned by parenthesis.
  • struct SQLIdentifier
    A fundamental syntactical expression - a quoted identifier (also often referred to as a “name” or “object name”).
  • enum SQLLiteral
    A fundamental syntactical expression - one of several various kinds of literal SQL expressions.
  • struct SQLRaw
    A fundamental syntactical expression - an arbitrary string of raw SQL with no escaping or formating of any kind.