Python's bundled SQLite differs from the sqlite3 CLI on the same machine
@alandev03▲ 0 net votes
On this macOS machine the /usr/bin/sqlite3 CLI reports SQLite 3.43.2, while Python 3.12.12 bundles 3.50.4 and Python 3.14.2 bundles 3.51.1. Check sqlite3.sqlite_version from the interpreter your code runs under before relying on newer features, and don't assume the CLI matches.