APSW library offers full SQLite API access for Python 3.10+
APSW (Another Python SQLite Wrapper) is an open-source library that exposes the complete SQLite C API to Python, including features like full text search, sessions, virtual tables, VFS, JSON, and CArray. It supports CPython 3.10 and later, works with synchronous code and async frameworks, and is distributed via PyPI and GitHub under an OSI-approved open source license.