sqlite3.connect() has a large number of parameters: 1 required and 7 optional. It is much more convenient to pass optional arguments by keyword, because you can pass only values which differs from default. And if you pass positional arguments, it is easy to make an error and pass value as wrong argument.

It is recommended to make optional rarely used arguments keyword-only. I do not think it will break much code, but we need a deprecation period for this.

The problem is thatsqlite3.connect() was converted to Argument Clinic, and it was much easier to add deprecation warning in the old code.

Linked PRs

• gh-93057: Use 'sqlite3' as module name for clinic input in Modules/_sqlite/connection.c #107879
• gh-93057: Deprecate positional use of optional sqlite3.connect() params #107948