Implement commit/rollback on workflows and pipelines

let's create a generic system which allows plugins so we it can be built for relational and non-relational databases.
The idea is to do a rollback or a commit on all used database connections (which support it) based upon the successful execution of a workflow or a pipeline.