JSON

FROM_JSON

DuckDBDuckDB

Mengkonversi JSON value ke tipe data DuckDB tertentu. Type-safe JSON parsing.

Tipe hasil: Sesuai parameter typeDiperbarui: 6 Jan 2026

Syntax

SQL
FROM_JSON(json, type)

Parameter

jsonJSON/VARCHARwajib

JSON value yang akan dikonversi

typeTYPEwajib

Target type untuk konversi

Contoh Penggunaan

Konversi JSON Array ke DuckDB List

SQL
1SELECT FROM_JSON('[1, 2, 3, 4, 5]', 'INTEGER[]') as int_list;

Mengkonversi JSON array ke DuckDB INTEGER array.

Hasil
int_list
[1, 2, 3, 4, 5]

Parse JSON Object ke Struct

SQL
1SELECT FROM_JSON(
2  '{"name": "Budi", "age": 30, "active": true}',
3  'STRUCT(name VARCHAR, age INTEGER, active BOOLEAN)'
4) as user_struct;

Mengkonversi JSON object ke DuckDB STRUCT.

Hasil
user_struct
{'name': Budi, 'age': 30, 'active': true}

Parse Complex Nested JSON

SQL
1SELECT FROM_JSON(
2  '{"users": [{"id": 1, "name": "Budi"}, {"id": 2, "name": "Ani"}]}',
3  'STRUCT(users STRUCT(id INTEGER, name VARCHAR)[])'
4).users as users_array;

Parse nested JSON dengan array of structs.

Hasil
users_array
[{'id': 1, 'name': Budi}, {'id': 2, 'name': Ani}]
Kembali ke DuckDB Functions