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

Not supportive, due to the theme-based data mart, Jone will impact the performance

SubQuery

Currently not supportive