JSON

OBJECT_CONSTRUCT

Snowflake

Membuat OBJECT (JSON object) dari pasangan key-value.

Tipe hasil: OBJECTDiperbarui: 6 Jan 2026

Syntax

SQL

OBJECT_CONSTRUCT(key1, value1, [key2, value2, ...])

keyVARCHARwajib

Nama key

valueanywajib

Nilai untuk key tersebut

SQL

1 SELECT OBJECT_CONSTRUCT(
2   'name', 'John',
3   'age', 30,
4   'email', 'john@example.com'
5 ) as user_obj;

Membuat object user.

SQL

1 SELECT OBJECT_CONSTRUCT(
2   'user', OBJECT_CONSTRUCT('name', 'John'),
3   'orders', ARRAY_CONSTRUCT(1, 2, 3)
4 ) as data;

Object dengan nested structure.

JSONB_BUILD_OBJECT

PostgreSQL

JSON_OBJECT

MySQL

JSON_OBJECT

BigQuery

JSON_OBJECT

DuckDB

1	SELECT OBJECT_CONSTRUCT(
2	'user', OBJECT_CONSTRUCT('name', 'John'),
3	'orders', ARRAY_CONSTRUCT(1, 2, 3)
4	) as data;