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.