They're probably talking about the addition of the autocommit flag, which hides more fine-grained transaction control in favor of more uniform behavior across multiple databases:

https://docs.python.org/3/library/sqlite3.html#sqlite3.Conne...

You can still use previous behavior with "legacy" mode that lets you control when transactions are opened in which isolation level.

Pythons options are here: https://docs.python.org/3/library/sqlite3.html

SQLite behavior is here: https://sqlite.org/lang_transaction.html . The regular implicit transactions there plus explicit where needed aren’t supported in any python mode.