Maybe I missed it, but are there any examples of how to interact with the SQLite database through an embedded python script? I'd like to create my own database tables and insert my own data. Ultimately, this code will likely end up as a plug-in, but for now, I'd like to start with an embedded python script if I can.
Thanks in advance.

EDIT: I'm asking about the proper way to CREATE and INSERT into tables within the indigo_history.sqlite file through embedded python, I'm not asking about what the actual SQL commands should be. Also, should I stay away from indigo_history.sqlite and use my own database?

I think using your own database would be a better idea - if you add stuff to the db file used by the SQL Logger plugin and we revise it sometime in the future it may break your plugin (table name conflicts, etc.). I suppose if your plugin is augmenting (joining against for instance) the log database created by the SQL logger then you could go ahead - I'd just caution that while we don't have any plans to move/rename the file or alter the existing structure we reserve the right to do so in the future as necessary.