The idea of automatically creating collections by doing an INSERT has not yet been implemented.
Query the whole table.
By default, the entire document is returned. But you can construct an alternative document in between the SELECT and FROM keywords.
You can of course put a WHERE clause to restrict the search.
You can delete a single entry:
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.
Here's an example of an UPSERT: Incrementing a counter on a webpage.
The final demonstration for today is the ability to add new fields to an object using UPDATE: