If you’re going to use SQLite regularly, you’ll need some extra infrastructure. OP’s post provides some boilerplate that would help you on your way.

What has really made the difference for me recently though, is Simon Willison’s sqlite_utils package. It’s heavier weight than OP’s wrapper classes, but it’s infinitely more powerful and has made using a local database a joy instead of the kludge I usually make of it. I’ll be bummed to writing stuff for PostGres when I have to do that