Column substitution¶
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.