JSON support

SELECT JSON

Add the JSON keyword to a SELECT statement to return each row as a JSON-encoded map. The rest of the SELECT behavior stays the same.

The map keys match the column names in a regular result set. For example, you can execute the SELECT JSON a, b FROM ... statement to generate a map that contains the a and b keys.

INSERT JSON

Add the JSON keyword to an INSERT statement to insert a JSON-encoded map as a row. The JSON map format must match what SELECT JSON returns for the same table.

For example, you can execute the following statement to insert a map into a table that contains the key and value columns:

INSERT INTO persioninfo JSON '{ "c1": "key", "c2": "value"}'

By default, columns omitted from the JSON map are set to NULL. This rule also applies when the default value NULL is explicitly specified, which means that all existing values of the unspecified columns are removed.

JSON encoding of CQL data types

The following table shows how Lindorm CQL maps CQL data types to and from JSON. It describes the data types accepted in INSERT JSON statements and fromJson() functions, and the data types returned for SELECT JSON statements and toJson() functions.