Return multi-row result as JSON array

[dm8tbr]

This could be useful.
For now I've devised a work around. I print '[' and ']' around the output and the query looks like this:

  SELECT CONCAT(json_object(foo, bar, baz), ',') AS '' FROM quux;

[ziadloo]

Just a thought, you can use the current version of non-aggregate JSON UDFs combined with recursive stored procedures to achieve what you want.