Transaction support for in-memory database

[zachmu]

Currently unsupported. All transaction statements e.g. start transaction, commit, rollback are no-ops.

Supporting this is challenging, as it requires implementing something like journaled storage.