Skip to content

Instance Property

values

An array of arrays providing a list of rows to insert as lists of expressions.
var values: [[any SQLExpression]]

Discussion

The outer array can be thought of as a list of rows, with each “row” being a list of values for each column. In any given “row”, the value at a given index corresponds to the column at that same index in columns. Each “row” must have the same number of elements as every other row, which must also be the same number elements in columns; if this rule is not followed, invalid SQL is generated. SQLLiteral.default and/or SQLLiteral.null can be used to fill in gaps in a given row as appropriate for the column.

If values is not an empty array, it is always used, even if valueQuery is not nil. If values is empty and valueQuery is nil, invalid SQL is generated.