How to JSON in MySQL

How to create a JSON document from fields in MySQL

You can create a JSON document from fields in Mysql® with the JSON_OBJECT function

How to create a JSON object from array of key/value pairs in PostgreSQL®?

PostgreSQL® offers two types of data types to handle JSON data, JSON and JSONB, you can use the function json_object (jsonb_object for JSONB) to create a JSON object from an array of key/value pairs.

How to create a JSON object from keys and values arrays in PostgreSQL®?

PostgreSQL® offers two types of data types to handle JSON data, JSON and JSONB, you can use the function json_object (jsonb_object for JSONB) to create a JSON object from two arrays of keys and values.