JSON

JSON_OBJECT

DuckDB

Membuat JSON object dari pasangan key-value.

Tipe hasil: JSONDiperbarui: 6 Jan 2026

Syntax

SQL

JSON_OBJECT(key1, value1, key2, value2, ...)

Parameter

key, value pairsVARCHAR, anywajib

Pasangan key (string) dan value

Contoh Penggunaan

Membuat JSON Object

SQL

1 SELECT JSON_OBJECT('name', 'John', 'age', 30);

Membuat object dengan 2 field.

Hasil

{"name":"John","age":30}

Dari Kolom Tabel

SQL

1 SELECT JSON_OBJECT(
2   'id', id,
3   'name', name,
4   'email', email
5 ) as user_json
6 FROM users;

Konversi baris ke JSON object.

Hasil

user_json
{"id":1,"name":"John","email":"john@example.com"}

Nested Object

SQL

1 SELECT JSON_OBJECT(
2   'user', JSON_OBJECT('name', name, 'email', email),
3   'metadata', JSON_OBJECT('created_at', created_at)
4 ) as data
5 FROM users;

Membuat nested JSON object.

Fungsi Equivalen di Database Lain

JSONB_BUILD_OBJECT

PostgreSQL

JSON_OBJECT

MySQL

OBJECT_CONSTRUCT

Snowflake

JSON_OBJECT

BigQuery

Fungsi Terkait

JSON_ARRAYTO_JSON

Kembali ke DuckDB Functions

1	SELECT JSON_OBJECT(
2	'id', id,
3	'name', name,
4	'email', email
5	) as user_json
6	FROM users;

1	SELECT JSON_OBJECT(
2	'user', JSON_OBJECT('name', name, 'email', email),
3	'metadata', JSON_OBJECT('created_at', created_at)
4	) as data
5	FROM users;