How sqlite7 Works

sqlite7 is not an ORM. You still write SQL when you want to. The library focuses on making raw SQLite access cleaner and safer.

There are two layers:

1. Direct SQL methods like execute(), fetch_all(), and script()

2. Convenience helpers like select(), insert(), update(), delete(), and upsert()

The helper methods validate table and column names before interpolating them into SQL, while query values are still passed as parameters.

---