MariaDB starting with 10.2.4
This function was added in MariaDB 10.2.4.
JSON_LOOSE(json_doc)
Adds spaces to a JSON document to make it look more readable.
SET @j = '{ "A":1,"B":[2,3]}';
SELECT JSON_LOOSE(@j), @j;
+-----------------------+--------------------+
| JSON_LOOSE(@j) | @j |
+-----------------------+--------------------+
| {"A": 1, "B": [2, 3]} | { "A":1,"B":[2,3]} |
+-----------------------+--------------------+