im asking from ignorance, what the difference in effect this context of not having the library itself?
I imagine this is because SQLite is VERY easy to bundle with Python itself. So on some platforms the OS SQLite is used, but on others it gets shipped as part of the Python installation itself.
It even works in WebAssembly via Pyodide!