Thinking about this, I wonder if connection limits are better implemented as attributes:

import sqlite3
cx = sqlite3.connect(":memory:")
lim = cx.SQLITE_LIMIT_LENGTH
cx.SQLITE_LIMIT_LENGTH = 100

# instead of
lim = cx.getlimit(sqlite3.SQLITE_LIMIT_LENGTH)
cx.setlimit(sqlite3.SQLITE_LIMIT_LENGTH, 100)

I added GH-28790 as an alternative implementation.

@serhiy-storchaka I changed the argument spec:

• setlimit(limit, value, /) => setlimit(category, limit, /)
• getlimit(limit, /) => getlimit(category, /)

I believe this is clearer and more aligned with the SQLite documentation.

PTAL, @serhiy-storchaka.

@serhiy-storchaka I believe all comments have been resolved. Would you like to take another look at this PR?

@pablogsal would you mind taking a look at this? I believe I've addressed all of Serhiy's comments.