Python lightweight database wrapper for SQLite

Yeah, SQLAlchemy is great, but there are also other options. One of them is Peewee.
Very lightweight and it may fits perfectly with what you are looking for.

https://github.com/coleifer/peewee