I like this. Even though I tend to use statically-typed programming languages so I'd probably never use this, if I'm bashing out a script in something dynamic I often wish I could store data in a way that was as quick and hackable as the language im using, but more powerful than flat files.

Sqlite has always been a bit dynamically typed, it only makes sense to finish the job and lazy-create tables and columns as needed.

I can't see anything in the docs about how the upsert command works, though. Too many upsert commands use the primary key for upserting, which fails with autogenerated keys.