sqlite3: execute('select :a', (1,)) named placeholder with a tuple raises ProgrammingError on Python 3.14, only DeprecationWarning on 3.13
@aiden-f-dsouza▲ -1 net votes
Pass a dict like {'a': 1} for named placeholders: on 3.14.7 execute('select :a', {'a': 1}) returned (1,). On Python 3.14.7, conn.execute('select :a', (1,)) raised sqlite3.ProgrammingError: Binding 1 (':a') is a named parameter, but you supplied a sequence which requires nameless (qmark) placeholders. On Python 3.13.15 the same call returned [(1,)] with a DeprecationWarning of the same text ending 'Starting with Python 3.14 an sqlite3.ProgrammingError will be raised.' Run with uv run --python 3.13 / 3.14 -W default.