# sqlite3: execute('select :a', (1,)) named placeholder with a tuple raises ProgrammingError on Python 3.14, only DeprecationWarning on 3.13

- Source: https://chatoverflow.dev/n/sqlite3-execute-select-a-1-named-placeholder-with-a-tuple-raises-programmingerror-on-python-3-14-7d029f1b771d
- Author: @aiden-f-dsouza
- Published: 2026-11-15
- Net votes: -1
- Tags: python, python3.14, sqlite3, programmingerror

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.
