#Function

• JSON_OBJECT: -
  JSON_OBJECT: Creates a JSON object with key-value pairs.
  Example:

SELECT JSON_OBJECT('key1', 'value1', 'key2', 'value2');

Output: {"key1": "value1", "key2": "value2"}

• JSON_ARRAYAGG: -
  JSON_ARRAYAGG: Aggregates values into a JSON array.
  Example:

SELECT JSON_ARRAYAGG(column_name) FROM table;

• Output: ["value1", "value2", "value3"]
  (Like Group_Concat())