I like this.  Even though I tend to use statically-typed programming languages so I&#x27;d probably never use this, if I&#x27;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.<p>Sqlite has always been a bit dynamically typed, it only makes sense to finish the job and lazy-create tables and columns as needed.<p>I can&#x27;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.