JSON

JSON_OBJECT

BigQuery

Membuat JSON object dari pasangan key-value yang diberikan.

Tipe hasil: JSONDiperbarui: 7 Jan 2026

Syntax

SQL

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

key, value pairsSTRING, anyopsional

Pasangan key (string) dan value

SQL

1 SELECT
2   JSON_OBJECT() as empty_obj,
3   JSON_OBJECT('name', 'John', 'age', 30) as person;

Membuat JSON object.

Hasil

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

JSONB_BUILD_OBJECT

PostgreSQL

JSON_OBJECT

MySQL

OBJECT_CONSTRUCT

Snowflake

JSON_OBJECT

DuckDB

1	SELECT
2	JSON_OBJECT() as empty_obj,
3	JSON_OBJECT('name', 'John', 'age', 30) as person;