SQL · JSON functions

json()

Validates and stores a JSON text value.

sqlRunnable example sql course

Syntax

json(text)

Example

Open in the lab

SELECT json('{"a":1}') AS document;

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