JSON

JSON_EXTRACT

DuckDB

Mengekstrak nilai dari JSON berdasarkan path. DuckDB mendukung operator -> dan ->> seperti PostgreSQL.

Tipe hasil: JSON (untuk ->) atau VARCHAR (untuk ->>)Diperbarui: 6 Jan 2026

Syntax

SQL

JSON_EXTRACT(json, path) | json -> path | json ->> path

jsonJSON/VARCHARwajib

Data JSON atau string JSON yang akan diekstrak

pathVARCHARwajib

Path ke nilai yang diinginkan (contoh: '$.name' atau '/name')

SQL

1 SELECT JSON_EXTRACT('{"name": "John", "age": 30}', '$.name');

Mengekstrak field 'name' dari JSON.

Hasil

"John"

SQL

1 SELECT
2   data -> '$.name' as name_json,
3   data ->> '$.name' as name_text
4 FROM json_table;

-> untuk JSON, ->> untuk string.

Hasil

name_json	name_text
"John"	John

SQL

1 SELECT
2   data ->> '$.user.name' as user_name,
3   data ->> '$.user.address.city' as city
4 FROM users;

Mengakses nested object dengan dot notation.

SQL

1 SELECT
2   data ->> '$.items[0].name' as first_item,
3   data ->> '$.items[1].price' as second_price
4 FROM orders;

Mengakses element array berdasarkan indeks.

JSON_EXTRACT_PATH

PostgreSQL

JSON_EXTRACT

MySQL

GET_PATH

Snowflake

JSON_EXTRACT

BigQuery

1	SELECT
2	data ->> '$.user.name' as user_name,
3	data ->> '$.user.address.city' as city
4	FROM users;

1	SELECT
2	data ->> '$.items[0].name' as first_item,
3	data ->> '$.items[1].price' as second_price
4	FROM orders;