You can use it from python as follows:

    db = sqlite3.connect(...)
    db.enable_load_extension()
    db.load_extension("libsqlite_zstd.so")

You probably still have to figure out how to make that work cross-platform / how to ship that binary though.