SQL Text may be directly entered for an entire expression or into an element of an expression as a free-format text string. This allows the use of constructs that may not otherwise be supported in an expression.
Care should be given to create a valid expression since validation is not performed on the SQL within the free-format text string.When dragging a SQL Text operator into a variable, the following tree element is created.
Variable Creation > Input > Variables: SQL Elements pane - Other > SQL Text
Double-click on SQL Text, or highlight it and click Properties.
Variable Creation > Input > Variables: SQL Elements pane - Other > SQL Text Properties
Enter a valid SQL expression within the SQL Text area.