Celonis dynamic SQL or loops

Hi all,

I was wondering if it is possible to create dynamic sql in transformation. I tried to use loops and define sql variables, however I didn’t have any luck.

I have never worked with Vertica database and seen some place that vertica has no loops, no arrays, no variables just a plain SQL database. I am not sure if that’s true.

Is this a limitation of a some kind?

Thanks.