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

SQL on anything

Low-code Python (data apps)

Specific examples of data transformations

Generate Union Query

Slow changing dimensions (history tables)