The SQLite library up to at least 3.7.17 won't work with spinedb_api as discussed in spine-tools/Spine-Toolbox#1538. On my system I have 3.35.5 which works just fine. Perhaps we should check for compatible version when connecting to a sqlite database? Or add a troubleshooting note to README.md? The version can be found with
import sqlite3
sqlite3.sqlite_version