fold the last round of sql manager changes back into the core and use it for the central db and simplify the algorithm

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