Suggesting to backport this, in order to easier backport docstring updates.

cc. @serhiy-storchaka, if you want to look this over; it is a trivial change

Yes, that is true, but as you say, it is a long way into the future. For now, it makes it simpler for us to do stuff like deprecating positional use of parameters.

BTW, after making all optional arguments keyword-only, why not implement connect() in Python?

def connect(database, *, factory=Connection, **kwargs):
    return factory(database, **kwargs)

BTW, after making all optional arguments keyword-only, why not implement connect() in Python?

def connect(database, *, factory=Connection, **kwargs):
    return factory(database, **kwargs)

That is a very good idea.

BTW, I've toyed the idea of with turning _sqlite3 into a small extension module that simply exposes the relevant SQLite APIs, and then implement Lib/sqlite3.py using _sqlite3. It would probably have a performance impact, but it would make maintenance easier.

Ah, of course, we cannot backport this because the clone __init__ feature in Argument Clinic is only present in main. Well, backporting is not very important; the spec of sqlite3.connect and sqlite3.Connection.__init__ should not change in 3.12 and 3.11.