Expand/Shrink

advanced

You may very well manage just fine with only ever using sqlite3_exec() and sqlite3_get_table(), or even just one of those,
however SQLite contains many more advanced features you may wish to take advantage of.

I have copied many details straight from the SQLite website.
The SQL As Understood By SQLite documents are very thorough, hence the much simpler cheat sheet.

Of course the main point of doing all this is just to make these documents easily searchable, and more readily to hand.

None of these routines are supported by pwa/p2js.