refactor(connections): sqlite needs to be singleton for regular queries but needs a differerent connection per transaction