Skip to content

Structure

SQLNestedSubpathExpression

A “nested subpath” expression is used to descend into the “deeper” structure of a non-scalar value, such as a dictionary, array, or JSON value.
struct SQLNestedSubpathExpression

Overview

This expression is effectively an API for nestedSubpathExpression(in:for:), which is defined as providing an expression for descending specifically into JSON values only. As a result, the more “general” usage of applying a nested subpath to any non-scalar value is not available via this interface.

Topics

Initializers

  • init(column:path:)
    Create a nested subpath from an identifier string and an array of one or more path elements.

Instance Properties

  • column
    The expression to which the nested subpath is applied.
  • path
    The subpath itself. Must always contain at least one element.

Instance Methods

  • serialize(to:)
    Invoked when a request is made to serialize the expression to raw SQL.

Relationships

Conforms To

See Also

Basic Expressions

  • SQLAlias
    Encapsulates SQL’s <expression> [AS] <name> syntax, most often used to declare aliaed names for columns and tables.
  • SQLBetween
    An SQLExpression which constructs SQL of the form <operand> BETWEEN <lowerBound> AND <upperBound>.
  • SQLColumn
    An expression representing an optionally table-qualified column in an SQL table.
  • SQLConstraint
    An expression representing the combination of a constraint name and algorithm for table constraints.
  • SQLDataType
    Represents a value’s type in SQL.
  • SQLDirection
    Describes an ordering direction for a given sorting key.
  • SQLDistinct
    An expression representing the subexpression of an aggregate function call which specifies whether the aggregate groups over all result rows or only distinct rows.
  • SQLForeignKeyAction
    An expression specifying a behavior for a foreign key constraint violation.
  • SQLQualifiedTable
    An expression representing an optionally second-level-qualified SQL table.
  • SQLQueryString
    An expression consisting of an array of constituent subexpressions generated by custom string interpolations.