[Feature Request]: A safe single threaded pipeline engine

[mattcasters]

What would you like to happen?

The pipeline engine would execute every transform one by one, never in multiple copies.
The rows are serialized to disk after every transform execution in a safe, configurable, location.
When the pipeline fails it should be possible to simply execute the pipeline with the same again and it will continue with the transform that failed the last time around.

Most of the code already exists. We essentially only need a spooling rowset implementation of IRowSet.

Issue Priority

Priority: 3

Issue Component

Component: Pipelines

[CarlosJuncher03]

That would be great, in fact I had already requested a similar activity which is #6537. It could be reviewed to see if it can be combined with your request.

[CarlosJuncher03]

At least in my opinion, we could approach something similar to what some tools offer in terms of development, such as execution from errors, execution caching, and line-by-line execution (in the case of transformation to transformation).