Not an extension, but I wanted to add that sqlite-utils is an incredible Python library for working with SQLite dbs. Great for squashing several lines of SQL into a one-liner.

https://sqlite-utils.datasette.io/en/stable/index.html