Describe the feature

We need to support a few more SQLite methods for pruning and also transaction support. We should figure out what those methods are ahead of time, and build transaction support in from the beginning.

Additional context

No response