sorry for asking, but how can I use the with statement in a custom sql query?
I know how to use it in SQL, that’s not the problem.
My problem is the node converting the custom sql into: select * from ( <given_sql_statement> ).
I just don’t know the correct knime syntax, if there is one.
Can anyone help me? (Legacy nodes don’t have that problem, I know)
All the best,