Outfile query result into JSON file

Off-Topic
1

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

2

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

You can use to_json to output in the json format. SingleStoreDB Cloud ยท SingleStore Documentation