JSON

JSON_QUOTE

DuckDB

Mengubah string menjadi JSON string literal yang valid dengan proper escaping.

Tipe hasil: JSONDiperbarui: 6 Jan 2026

Syntax

SQL

JSON_QUOTE(string)

Parameter

stringVARCHARwajib

String yang akan di-quote sebagai JSON string

Contoh Penggunaan

Quote String Sederhana

SQL

1 SELECT
2   JSON_QUOTE('Hello World') as simple,
3   JSON_QUOTE('Line1\nLine2') as with_newline,
4   JSON_QUOTE('Say "Hello"') as with_quotes;

Mengkonversi string ke JSON string literal.

Hasil

simple	with_newline	with_quotes
"Hello World"	"Line1\nLine2"	"Say \"Hello\""

Membangun JSON Manual

SQL

1 SELECT
2   '{"name": ' || JSON_QUOTE(name) || ', "city": ' || JSON_QUOTE(city) || '}' as json_str
3 FROM users;

Membangun JSON string dengan proper escaping.

Hasil

json_str
{"name": "Budi", "city": "Jakarta"}
{"name": "Ani", "city": "Surabaya"}

Handle Special Characters

SQL

1 SELECT
2   original,
3   JSON_QUOTE(original) as quoted
4 FROM (
5   SELECT 'Tab:\there' as original UNION ALL
6   SELECT 'Path: C:\\Users' UNION ALL
7   SELECT 'JSON: {"key": "value"}'
8 );

Proper escaping untuk berbagai karakter special.

Hasil

original	quoted
Tab: here	"Tab:\there"
Path: C:\Users	"Path: C:\\Users"
JSON: {"key": "value"}	"JSON: {\"key\": \"value\"}"

Kembali ke DuckDB Functions

1	SELECT
2	JSON_QUOTE('Hello World') as simple,
3	JSON_QUOTE('Line1\nLine2') as with_newline,
4	JSON_QUOTE('Say "Hello"') as with_quotes;

1	SELECT
2	'{"name": ' \|\| JSON_QUOTE(name) \|\| ', "city": ' \|\| JSON_QUOTE(city) \|\| '}' as json_str
3	FROM users;

1	SELECT
2	original,
3	JSON_QUOTE(original) as quoted
4	FROM (
5	SELECT 'Tab:\there' as original UNION ALL
6	SELECT 'Path: C:\\Users' UNION ALL
7	SELECT 'JSON: {"key": "value"}'
8	);