Column substitution in Jitterbit App Builder

It is possible to refer to other columns (typically calculated) in an mvSql expression. The column substitution also works in the where expression.

Example

select
    length(Name) as NameLen,
    {{NameLen}} + 1 as NameLen1,
    {{NameLen1}} + 1 as NameLen2
from Company
where
    {{NameLen2}} >= 20

The syntax is {{ columnName }} where column name is the name mvSQL expression.