Feature or enhancement

Proposal:

This is a meta issue for the following tasks:

• The sqlite3 docs say that the return value of sqlite3_reset and sqlite3_finalize must be checked and handled accordingly, but we do not do this.
• We have some functions that are called but can fail, and we don't free resources.

Has this already been discussed elsewhere?

This is a minor feature, which does not need previous discussion elsewhere

Links to previous discussion of this feature:

No response

Linked PRs

• gh-139327: fix some reference leaks in sqlite3 error branches #139328
• gh-139327: consolidate sqlite3_finalize and sqlite3_reset usages #139329
• [3.14] gh-139327: fix some reference leaks in sqlite3 error branches (GH-139328) #139471
• [3.13] gh-139327: fix some reference leaks in sqlite3 error branches (GH-139328) #139472