row()

Create an unnamed STRUCT (tuple) containing the argument values.

Reference: DuckDB 2.0.0

Arguments & returns

row(…)

Scalar
Overload link … Varargs Returns
#01 ANY TUPLE

… accepts a variable number of arguments of the type shown.

Example

row example
SQL
Haybarn WASM 2.0.0-rc12 · In your browser

Engine example with sample data · Run to view results.

In other engines

BigQuerycast()

CAST(STRUCT<a INT64>(1) AS STRUCT<a INT64>)
In DuckDB
CAST(CAST(ROW(1) AS STRUCT(a BIGINT)) AS STRUCT(a BIGINT))

SQLGlot example ↗