Inserting JSON formatted values

Inserting JSON data with the INSERT command for testing queries.

In a production database, inserting columns and column values programmatically is
more practical than using cqlsh. The CQL INSERT commands supports JSON to provide a
manual testing from the cqlsh command line utility.

When upserting data if any columns are missing from the JSON, the value in the
missing column is overwritten with null (by default). The following removes the
lastname value "SUTHERLAND" from the previous
example: