SQL · Aggregate functions

json_group_object()

Collects key-value pairs into a JSON object. SQLite only.

sqlRunnable example sql course

Syntax

json_group_object(key, value)

Example

Open in the lab

WITH scores(name, score) AS (VALUES ('Ada', 90), ('Linus', 85))
SELECT json_group_object(name, score) AS scores FROM scores;

Reference pages are the quick answer. The course explains the why, shows the full example and ends with a challenge.