JSON

DuckDB

Mem-parse string JSON menjadi tipe JSON DuckDB. Validasi dan konversi string ke JSON object.

Tipe hasil: JSONDiperbarui: 6 Jan 2026

Syntax

SQL

JSON(string)

Parameter

stringVARCHARwajib

String JSON yang akan di-parse

Contoh Penggunaan

Parse String ke JSON

SQL

1 SELECT
2   JSON('{"name": "Budi", "age": 30}') as json_obj,
3   JSON('[1, 2, 3, 4, 5]') as json_arr;

Mengkonversi string ke JSON object dan array.

Hasil

json_obj	json_arr
{"name":"Budi","age":30}	[1,2,3,4,5]

Parse dan Extract

SQL

1 SELECT
2   JSON_EXTRACT(JSON('{"user": {"name": "Ani", "email": "ani@mail.com"}}'),
3     '$.user.name') as user_name;

Parse JSON lalu extract nilai tertentu.

Hasil

user_name
"Ani"

Cast String Column ke JSON

SQL

1 SELECT
2   id,
3   JSON(metadata) as parsed_metadata,
4   JSON_EXTRACT(JSON(metadata), '$.version') as version
5 FROM configs
6 WHERE JSON_VALID(metadata);

Mengkonversi kolom string ke JSON untuk processing.

Hasil

id	parsed_metadata	version
1	{"version":"1.0","env":"prod"}	"1.0"
2	{"version":"2.0","env":"dev"}	"2.0"

Kembali ke DuckDB Functions

1	SELECT
2	JSON('{"name": "Budi", "age": 30}') as json_obj,
3	JSON('[1, 2, 3, 4, 5]') as json_arr;

1	SELECT
2	JSON_EXTRACT(JSON('{"user": {"name": "Ani", "email": "ani@mail.com"}}'),
3	'$.user.name') as user_name;

1	SELECT
2	id,
3	JSON(metadata) as parsed_metadata,
4	JSON_EXTRACT(JSON(metadata), '$.version') as version
5	FROM configs
6	WHERE JSON_VALID(metadata);