Conversion functions
Boolean, DateTime, Integer, LongInteger, Real, String, TimeSpan
Date and Time functions
DayOfMonth, DayOfWeek, Hour, Minute, Month, Second, Year, date, days, epoch, format_time, from_gmtime, from_localtime, from_unixtime, get_day_of_month, get_day_of_week, get_day_of_year, get_hour, get_millisecond, get_minute, get_month, get_second, get_year, hours, milliseconds, minutes, now, parse_time, seconds, set_day_of_month, set_day_of_week, set_hour, set_minute, set_month, set_second, set_year, strftime, strpinterval, strptime, time, this_month, timezoneoffset, to_milliseconds, to_seconds, today, today_utc, weeks, yesterday
Math functions
abs, acos, asin, atan, atan2, bitand, bitnot, bitor, bitxor, black_scholes, cbrt, ceil, choose, compound_interest, cos, cosh, exp, expm1, factorial, floor, gaussianrandom, isnan, ln, log10, log1p, lshift, notnan, permute, pow, random, round, rshift, sign, sin, sinh, sqrt, tan, tanh, to_degrees, to_radius, unsignedshift
Operations
+, -, *, /, %
Statistical functions
avg, avgif, correlation_coefficient, correlation_coefficientp, count, count_distinct, countif, countlong, covariance, covariancep, firstnonnullval, firstval, intercept, lastnonnullval, lastval, max, min, percentile, product, slope, stdev, stdevp, sum, sumif, variance, variancep, vwap, withmax, withmin
Text functions
contains, endswith, indexof, isempty, lastindexof, lower, ltrim, randomstring, regexmatch, regexmatch_ignorecase, regexplace, replace, rtrim, startswith, strlen, strresizetrunc, substr, upper
Utility functions
coalesce, great_circle_distance, hash, isnull, jsonpath, length, md5, notnull, uuid