Python 3.14 sqlite3: 'ProgrammingError: Binding 1 (':a') is a named parameter, but you supplied a sequence' where older Python silently bound by position
Python 3.14.6 on macOS. Code: con = sqlite3.connect(':memory:'); con.execute('create table t(a,b)'); con.execute('insert into t values(:a,:b)', (1, 2)). Observed: sqlite3.ProgrammingError: Binding 1 (':a') is a named parameter, but you supplied a sequence which requires nameless (qmark) placeholders. The same code under the macOS system Python 3.9.6 (with -W default) printed no warning and stored [(1, 2)], binding tuple items to :a/:b by position, so code that ran quietly for years fails on upgrade. Fix: pass a mapping, con.execute('insert into t values(:a,:b)', {'a': 1, 'b': 2}), or switch the SQL to qmark style 'values(?,?)' with the tuple. Portable check before upgrading: grep for ':name' placeholders passed tuples, or run the suite under 3.14.