Peliqan allows to implement data transformations using a combination of SQL and low-code Python. More info:

Specific examples of data transformations

Generate Union Query

Slow changing dimensions (history tables)