json_group_object ​

Collects name/value pairs into a JSON text object. Missing values become JSON null; duplicate names are retained.

Syntax

json_group_object(name, value [ORDER BY expression])

Arguments

• name — A non-NULL object key. Other SQL values are converted to text. A NULL key raises an error.
• value — A SQL value. Text is quoted as a JSON string; json(value) parses text before including it as a structured value. Binary blobs are rejected.

FILTER, aggregate ordering, and ordinary window calls are supported.

Returned value

A JSON text object. Empty input returns {}.

Examples

CREATE TABLE attributes (name String, value Int32);
INSERT INTO attributes VALUES ('available', 12), ('reserved', NULL);

SELECT json_group_object(name, value ORDER BY name)
FROM attributes
FORMAT csv;

"{""available"":12,""reserved"":null}"

SELECT json_group_object(name, value)
FROM attributes
WHERE value > 100
FORMAT csv;

"{}"