Multiple lines in Azure Synapse/ADF expression builder

Question

I would like to have all lines showed inside of the expression builder. I want to avoid the following:

This works in pipeline runs, but is hard to debug and check.

I want the following, which is easy to read and debug:

Unfortunately this leads to newline characters being introduced in the resulting expression, which breaks the pipeline.

Any suggestions to achieve the above solution?

Answer 1

String interpolation treats the enter as new line in result. As an alternative you can use concat() in dynamic content.

Example:

Result: