refactor transaction_service to use new sqltools library