Best Python packages for SQLite?

[badlydrawnrob]

Always ask: what is my purpose? My goals?
"To prototype web apps in the simplest way possible"

1. By default SQLite does not use async (plugin required)
2. Be careful when you use raw SQL (easy for malicious injection)
3. Make sure an ORM is super easy to understand and implement (Peewee + FastApi is not)¹

This is also an important consideration if you're considering migrating from Python to some other language. How easy is its language to understand?

Footnotes

1. If the ORM is harder to understand than your average SQL statement, why would you even consider using it?! FastApi allows using any SQL database (or ORM) but now suggests to use SQLModel which is designed by the author of FastApi and extends SQLAlchemy. ↩