SQL · JSON functions

json_object()

Builds a JSON object from pairs.

sqlRunnable example sql course

Syntax

json_object(key, value, …)

Example

Open in the lab

SELECT json_object('course', 'CSS', 'lessons', 16) AS document;

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