[Task]: prevent self-referencing workflows and pipelines

[bamaer]

What needs to happen?

Actions or transforms that run child workflows or pipelines should have a check to prevent self-references (calling the current workflow or pipeline as a child). This applies to (at least)

• [x] action: Repeat
• [x] action: Workflow
• [x] transform: ETL metadata injection
• [x] transform: Kafka consumer (#2578)
• [x] transform: Pipeline executor
• [x] transform: Simple mapping

Issue Priority

Priority: 2

Issue Component

Component: Actions, Component: Transforms

[bamaer]

.take-issue