optimize sofia sql by using new core transaction processor we will no longer support databases that do not support transactions