JSON

JSON_SERIALIZE

DuckDBDuckDB

Mengkonversi JSON value ke string representation. Kebalikan dari JSON parse.

Tipe hasil: VARCHARDiperbarui: 6 Jan 2026

Syntax

SQL
JSON_SERIALIZE(json)

Parameter

jsonJSONwajib

JSON value yang akan dikonversi ke string

Contoh Penggunaan

Serialize JSON ke String

SQL
1SELECT
2  json_col,
3  JSON_SERIALIZE(json_col) as serialized,
4  TYPEOF(JSON_SERIALIZE(json_col)) as result_type
5FROM (SELECT JSON('{"name": "Budi", "age": 30}') as json_col);

Mengkonversi JSON ke string.

Hasil
json_colserializedresult_type
{"name":"Budi","age":30}{"name":"Budi","age":30}VARCHAR

Prepare for File Export

SQL
1SELECT
2  id,
3  JSON_SERIALIZE(JSON_OBJECT(
4    'id', id,
5    'name', name,
6    'email', email
7  )) as json_line
8FROM users;

Menyiapkan JSON lines untuk export.

Hasil
idjson_line
1{"id":1,"name":"Budi","email":"budi@mail.com"}
2{"id":2,"name":"Ani","email":"ani@mail.com"}

API Response Preparation

SQL
1SELECT JSON_SERIALIZE(JSON_OBJECT(
2  'status', 'success',
3  'data', JSON_OBJECT(
4    'users', JSON_ARRAY(
5      JSON_OBJECT('id', 1, 'name', 'Budi'),
6      JSON_OBJECT('id', 2, 'name', 'Ani')
7    )
8  )
9)) as api_response;

Membuat JSON response untuk API.

Hasil
api_response
{"status":"success","data":{"users":[{"id":1,"name":"Budi"},{"id":2,"name":"Ani"}]}}

Fungsi Terkait

TO_JSON
Kembali ke DuckDB Functions