are multiline sql statements possible in visual expression builder in data flows?

Question

The source in my dataflow is a sql server, and i am obtaining the data using a sql query. The Visual expression builder throws errors and says the expression is incorrect if i try to do this over multiline (see below images).

Am i doing something incorrectly, or does the IDE still not allow multi line statements?

Single line, no errors

multi line - errors on each line break

Answer 1

Thank you @ray & @Benedikt for your valuable input, posting it as an answer to help other community members.

If you use a direct query without including parameters, you can write your multi-line SQL query in the source query builder.

Use visual expression builder if you want to pass the query dynamically to include expression elements.

Here, use Concat() function to build a multi-line query in the expression builder.