As of MySQL 9.3.1, you can export the query results to a Newline-Delimited JSON (ND-JSON) file.