New JSON functions in MySQL v5.7.22

[Costas]

Functions That Create JSON Values
https://dev.mysql.com/doc/refman/8.0/en/json-creation-functions.html

--supported only by MySQL > v5.7.21 / v8 / v9
--tested on v5.7.35
SELECT JSON_ARRAY(1, "abc", NULL, TRUE, CURTIME());
SELECT JSON_OBJECT('id', 87, 'name', 'carrot');
SELECT JSON_QUOTE('null'), JSON_QUOTE('"null"');

ref -
https://www.geekyhacker.com/2020/05/02/export-mysql-query-results-as-json/