CODE EXAMPLE FOR JAVASCRIPT

mariadb JSON_ARRAYAGG does not exist

SELECT column1, CONCAT('[', GROUP_CONCAT(column2), ']') AS column2 FROM table GROUP BY column1;