CREATE COLLECTION
The idea of automatically creating collections by doing an INSERT has not yet been implemented.
INSERT INTO
The content can be any valid JSON string - not just a JSON object, but any valid JSON. Note that (as with JavaScript) we do not require the double-quotes around the field labels of an object on input. However, the double-quotes will be inserted upon output.
SELECT FROM
Query the whole table.
Query Results
By default, the entire document is returned. But you can construct an alternative document in between the SELECT and FROM keywords.
Query Results
SELECT FROM [collection] WHERE
You can of course put a WHERE clause to restrict the search.
Query Results
DELETE FROM
You can delete a single entry:
Query Results
Or delete everything all at once:
The WHERE clause processing is still just a skeleton. Real soon now, you'll be able to use AND and OR with complex expressions in the WHERE clause in order to delete varying amounts of content.
UPSERT
Here's an example of an UPSERT: Incrementing a counter on a webpage.
Query Results
Query Results
Query Results
UPDATE (adding new fields)
The final demonstration for today is the ability to add new fields to an object using UPDATE: