I was wondering if there is a MemSQL function similar to ROW_TO_JSON(t) Postgres json function which can export row to json? This could be handy, especially in a stored proc to return row to an API in a preformated json format.
to_json is coming in 7.1. You can download a beta version now. Releasing in the end of the month:
You can install it following the guide here:
The TO_JSON function implementation was not quite ready for 7.1, so has been removed from the general availability (GA) release, coming shortly. We are considering options for when to deliver it, and will report back later when we have a firm delivery date.