Part V Generation of JSON Data

You can use SQL to generate JSON data from other kinds of database data programmatically. You can do this using either (1) SQL/JSON functions json_object, json_array, json_objectagg, and json_arrayagg or (2) constructor JSON with a simplified syntax.

• Generation of JSON Data Using SQL
  You can use SQL to generate JSON objects and arrays from non-JSON data in the database. For that, use either constructor JSON or SQL/JSON functions json_object, json_array, json_objectagg, and json_arrayagg.