Index of functions and SQL constructs supported in Feldera SQL

%: operators *: operators +: operators -: operators .: grammar /: operators ::: casts <: comparisons <=: comparisons <>: comparisons =: comparisons >: comparisons >=: comparisons ABS: decimal, float, integer ACOS: float ACOSH: float AND: grammar ARG_MAX (aggregate): aggregates ARG_MIN (aggregate): aggregates ARRAY (aggregate): aggregates ARRAYS_OVERLAP: array ARRAY_AGG (aggregate): aggregates ARRAY_APPEND: array ARRAY_COMPACT: array ARRAY_CONTAINS: array ARRAY_DISTINCT: array ARRAY_JOIN: array ARRAY_LENGTH: array ARRAY_MAX: array ARRAY_MIN: array ARRAY_POSITION: array ARRAY_PREPEND: array ARRAY_REMOVE: array ARRAY_REPEAT: array ARRAY_REVERSE: array ARRAY_SIZE: array ARRAY_TO_STRING: array AS: grammar ASCII: string ASIN: float ASINH: float ATAN: float ATAN2: float ATANH: float AVG (aggregate): aggregates BETWEEN: comparisons, datetime, operators BIT_AND (aggregate): aggregates BIT_OR (aggregate): aggregates BIT_XOR (aggregate): aggregates BOOL_AND (aggregate): aggregates BOOL_OR (aggregate): aggregates CARDINALITY: array, map CASE: comparisons CAST: casts CBRT: float CEIL: decimal, float CHAR_LENGTH: string CHR: string COALESCE: comparisons CONCAT: string CONCAT_WS: string CONVERT: casts COS: float COSH: float COT: float COTH: float COUNT (aggregate): aggregates COUNTIF (aggregate): aggregates CSC: float CSCH: float CUBE: grammar DATE: datetime DATEADD: datetime DATEDIFF: datetime DATE_ADD: datetime DATE_PART: datetime DATE_SUB: datetime DATE_TRUNC: datetime DAY: datetime DEFAULT: grammar DEGREES: float DENSE_RANK (aggregate): aggregates DESC: grammar DOW: datetime DOY: datetime ELEMENT: array ESCAPE: string EVERY (aggregate): aggregates EXCEPT: grammar EXISTS: comparisons EXP: float EXTRACT: datetime FILTER: aggregates FLOOR: decimal, float FORMAT_DATE: datetime GREATEST: comparisons GROUPING: grammar GROUPING SETS: grammar GUNZIP: binary HOP: table HOUR: datetime IGNORE NULLS: grammar ILIKE: string IN: grammar INITCAP: string INTERSECT: grammar INTERVAL: datetime IS DISTINCT FROM: comparisons IS FALSE: operators IS NOT DISTINCT FROM: comparisons IS NOT FALSE: operators IS NOT NULL: comparisons IS NOT TRUE: operators IS NOT UNKNOWN: operators IS NULL: comparisons IS TRUE: operators IS UNKNOWN: operators IS_INF: float IS_NAN: float LAG (aggregate): aggregates LATERAL: grammar LEAD (aggregate): aggregates LEAST: comparisons LEFT: string LEN: string LENGTH: string LIKE: string LN: decimal, float LOG: float LOG10: decimal, float LOGICAL_OR (aggregate): aggregates LOWER: string MAP: map MAX (aggregate): aggregates MIN (aggregate): aggregates MINUTE: datetime MOD: integer MONTH: datetime NOT: boolean NOT BETWEEN: comparisons NOT ILIKE: string NOT LIKE: string NOT RLIKE: string NOW: datetime NULLIF: comparisons NULLS FIRST: grammar NULLS LAST: grammar OCTET_LENGTH: binary OR: boolean OVER: grammar OVERLAPS: operators OVERLAY: string, binary PARSE_JSON: json PI: float POSITION: string POWER: decimal, float QUARTER: datetime RADIANS: float RANK (aggregate): aggregates REGEXP_REPLACE: string REPEAT: string REPLACE: string RESPECT NULLS: grammar RLIKE: string ROLLUP: grammar ROUND: float, decimal ROW: types ROW_NUMBER (aggregate): aggregates SEC: float SECH: float SECOND: datetime SEQUENCE: integer SIGN: decimal SIMILAR TO: string SIN: float SINH: float SOME (aggregate): aggregates SORT_ARRAY: array SPLIT: string SPLIT_PART: string SQRT: decimal, float STDDEV (aggregate): aggregates STDDEV_POP (aggregate): aggregates STDDEV_SAMP (aggregate): aggregates SUBSTR: string SUBSTRING: string SUM (aggregate): aggregates TABLE: table TAN: float TANH: float TIME: datetime TIMESTAMP: datetime TIMESTAMPADD: datetime TIMESTAMPDIFF: datetime TIMESTAMP_TRUNC: datetime TIME_TRUNC: datetime TO_HEX: binary TO_INT: binary TO_JSON: json TRIM: string TRUNC: decimal, float TRUNCATE: decimal, float TUMBLE: table UNION: grammar UNIQUE: comparisons UNNEST: array UPPER: string VALUES: grammar WEEK: datetime YEAR: datetime ||: string, binary