Statement block

Select,  Alias, From,  Where, Parameter, Group By, Order By

Common functions 

Count, Count(Distinct A), Sum, Max, Min, Avg

Special functions

Range, Product, Median, Quartile, Mode, SumSQ, PthPercentile, Variance, PopulationVariance, StandardDeviation, StandardError, PopulationStandardDeviation, SumWT, WeightAvg, Covariance, Correlation

Arithmetic and function

Sqrt, Sqr, ParseInt, ParseFloat, Abs, Substring, (a+b-c)*b/c

Date function

Year, Quarter, Month, Week, Day, Hour, Minute, Second, Quarterpart, Monthpart, Weekpart, Daypart, Weekday, Hourpart, Minutepart, Secondpart 

Join

Supported

SubQuery

Supported