Outfile query result into JSON file

Is there a way to convert the query result into JSON format instead of CSV?

With MemSQL 7.1 coming in the next two week adn beta ready MemSQL 7.1 Beta is now available for download!

You can use to_json to output in the json format. https://docs.memsql.com/v7.1/reference/sql-reference/json-functions/to_json/