Use savepoint instead of transactions for compatibility with outer transactions

[phiresky]

If e.g. zstd_enable_transparent is called within a transaction, it will fail because zstd_enable_transparent internally starts a transaction. Replacing that with savepoints should fix this.

Implementing this would fix https://github.com/sqlitebrowser/sqlitebrowser/issues/3244

PRs welcome :)