When JSON is specified as the format, the response will be a JSON array, where each element in the array is a result. The key will be the column’s
field name and the value will be the result. Fields with
null values are omitted. For example:
The format is designed to be easily human-readable, and should also be immediately parsable by all common JSON parsers.
Details on how data is encoded is are described in the documentation for each datatype.