# Index of Functions and SQL Constructs Supported in Feldera SQL

* `%`: [operators](operators.md#muldiv)
* `*`: [operators](operators.md#muldiv)
* `+`: [operators](operators.md#plusminus)
* `-`: [operators](operators.md#plusminus)
* `.`: [grammar](grammar.md#as)
* `/`: [operators](operators.md#muldiv)
* `::`: [casts](casts.md#coloncolon)
* `<`: [comparisons](comparisons.md#lt)
* `<=`: [comparisons](comparisons.md#lte)
* `<>`: [comparisons](comparisons.md#ne)
* `=`: [comparisons](comparisons.md#eq)
* `>`: [comparisons](comparisons.md#gt)
* `>=`: [comparisons](comparisons.md#gte)
* `ABS`: [decimal](decimal.md#abs), [float](float.md#abs), [integer](integer.md#abs)
* `ACOS`: [float](float.md#acos)
* `ACOSH`: [float](float.md#acosh)
* `AND`: [boolean](boolean.md#and)
* `ARG_MAX` (aggregate): [aggregates](aggregates.md#arg_max)
* `ARG_MIN` (aggregate): [aggregates](aggregates.md#arg_min)
* `ARRAY` (aggregate): [aggregates](aggregates.md#array)
* `ARRAYS_OVERLAP`: [array](array.md#overlap)
* `ARRAY_AGG` (aggregate): [aggregates](aggregates.md#array_agg)
* `ARRAY_APPEND`: [array](array.md#append)
* `ARRAY_COMPACT`: [array](array.md#compact)
* `ARRAY_CONCAT`: [array](array.md#concat)
* `ARRAY_CONTAINS`: [array](array.md#contains)
* `ARRAY_DISTINCT`: [array](array.md#distinct)
* `ARRAY_EXCEPT`: [array](array.md#except)
* `ARRAY_INSERT`: [array](array.md#insert)
* `ARRAY_INTERSECT`: [array](array.md#intersect)
* `ARRAY_JOIN`: [array](array.md#join)
* `ARRAY_LENGTH`: [array](array.md#length)
* `ARRAY_MAX`: [array](array.md#max)
* `ARRAY_MIN`: [array](array.md#min)
* `ARRAY_POSITION`: [array](array.md#position)
* `ARRAY_PREPEND`: [array](array.md#prepend)
* `ARRAY_REMOVE`: [array](array.md#remove)
* `ARRAY_REPEAT`: [array](array.md#repeat)
* `ARRAY_REVERSE`: [array](array.md#reverse)
* `ARRAY_SIZE`: [array](array.md#size)
* `ARRAY_TO_STRING`: [array](array.md#to_string)
* `ARRAY_UNION`: [array](array.md#union)
* `AS`: [grammar](grammar.md#as)
* `ASCII`: [string](string.md#ascii)
* `ASIN`: [float](float.md#asin)
* `ASINH`: [float](float.md#asinh)
* `ATAN`: [float](float.md#atan)
* `ATAN2`: [float](float.md#atan2)
* `ATANH`: [float](float.md#atanh)
* `AVG` (aggregate): [aggregates](aggregates.md#avg), [aggregates](aggregates.md#window-avg)
* `BETWEEN`: [comparisons](comparisons.md#between), [operators](operators.md#between)
* `BIT_AND` (aggregate): [aggregates](aggregates.md#bit_and)
* `BIT_OR` (aggregate): [aggregates](aggregates.md#bit_or)
* `BIT_XOR` (aggregate): [aggregates](aggregates.md#bit_xor)
* `BOOL_AND` (aggregate): [aggregates](aggregates.md#logical_and)
* `BOOL_OR` (aggregate): [aggregates](aggregates.md#logical_or)
* `CARDINALITY`: [array](array.md#cardinality), [map](map.md#cardinality)
* `CASE`: [comparisons](comparisons.md#case)
* `CAST`: [casts](casts.md#data-type-conversions)
* `CBRT`: [float](float.md#cbrt)
* `CEIL`: [decimal](decimal.md#ceil), [float](float.md#ceil), [datetime](datetime.md#date_ceil), [datetime](datetime.md#timestamp_ceil)
* `CHAR_LENGTH`: [string](string.md#char_length)
* `CHR`: [string](string.md#chr)
* `COALESCE`: [comparisons](comparisons.md#coalesce)
* `CONCAT`: [string](string.md#concat)
* `CONCAT_WS`: [string](string.md#concat_ws)
* `CONVERT`: [casts](casts.md#data-type-conversions)
* `COS`: [float](float.md#cos)
* `COSH`: [float](float.md#cosh)
* `COT`: [float](float.md#cot)
* `COTH`: [float](float.md#coth)
* `COUNT` (aggregate): [aggregates](aggregates.md#count), [aggregates](aggregates.md#countstar), [aggregates](aggregates.md#window-count), [aggregates](aggregates.md#window-countstar)
* `COUNTIF` (aggregate): [aggregates](aggregates.md#countif)
* `CSC`: [float](float.md#csc)
* `CSCH`: [float](float.md#csch)
* `CUBE`: [grammar](grammar.md#cube)
* `DATE`: [datetime](datetime.md#date-literals)
* `DATEADD`: [datetime](datetime.md#dateadd)
* `DATEDIFF`: [datetime](datetime.md#date_timestampdiff), [datetime](datetime.md#timestamp_timestampdiff)
* `DATE_ADD`: [datetime](datetime.md#date_add)
* `DATE_PART`: [datetime](datetime.md#date_extract), [datetime](datetime.md#time_extract), [datetime](datetime.md#timestamp_extract)
* `DATE_SUB`: [datetime](datetime.md#date_sub)
* `DATE_TRUNC`: [datetime](datetime.md#date_trunc)
* `DAYOFMONTH`: [datetime](datetime.md#date_dayofmonth), [datetime](datetime.md#timestamp_dayofmonth)
* `DEFAULT`: [grammar](grammar.md#default)
* `DEGREES`: [float](float.md#degrees)
* `DENSE_RANK` (aggregate): [aggregates](aggregates.md#dense_rank)
* `DESC`: [grammar](grammar.md#order)
* `DOW`: [datetime](datetime.md#date_dayofweek), [datetime](datetime.md#timestamp_dayofweek)
* `DOY`: [datetime](datetime.md#doy)
* `ELEMENT`: [array](array.md#element)
* `ESCAPE`: [string](string.md#like)
* `EVERY` (aggregate): [aggregates](aggregates.md#every)
* `EXCEPT`: [grammar](grammar.md#setop)
* `EXCEPT ALL`: [grammar](grammar.md#setop)
* `EXISTS`: [comparisons](comparisons.md#exists)
* `EXP`: [float](float.md#exp)
* `EXTRACT`: [datetime](datetime.md#time_extract), [datetime](datetime.md#date_extract), [datetime](datetime.md#timestamp_extract)
* `FILTER`: [aggregates](aggregates.md#filter)
* `FLOOR`: [decimal](decimal.md#floor), [float](float.md#floor), [datetime](datetime.md#date_floor), [datetime](datetime.md#timestamp_floor)
* `FORMAT_DATE`: [datetime](datetime.md#date-parsing-and-formatting)
* `GREATEST`: [comparisons](comparisons.md#greatest)
* `GROUPING`: [grammar](grammar.md#grouping)
* `GROUPING SETS`: [grammar](grammar.md#grouping-functions)
* `GUNZIP`: [binary](binary.md#gunzip)
* `HOP`: [table](table.md#hop)
* `HOUR`: [datetime](datetime.md#date_hour), [datetime](datetime.md#time_hour), [datetime](datetime.md#timestamp_hour)
* `IF`: [comparisons](comparisons.md#if)
* `IGNORE NULLS`: [grammar](grammar.md#window-aggregates)
* `ILIKE`: [string](string.md#ilike)
* `IN`: [comparisons](comparisons.md#in)
* `INITCAP`: [string](string.md#initcap)
* `INTERSECT`: [grammar](grammar.md#setop)
* `INTERVAL`: [datetime](datetime.md#time-intervals)
* `IS DISTINCT FROM`: [comparisons](comparisons.md#distinct)
* `IS FALSE`: [operators](operators.md#isnull)
* `IS NOT DISTINCT FROM`: [comparisons](comparisons.md#notdistinct)
* `IS NOT FALSE`: [operators](operators.md#isnull)
* `IS NOT NULL`: [comparisons](comparisons.md#isnotnull), [operators](operators.md#isnull)
* `IS NOT TRUE`: [operators](operators.md#isnull)
* `IS NOT UNKNOWN`: [operators](operators.md#isnull)
* `IS NULL`: [comparisons](comparisons.md#isnull), [operators](operators.md#isnull)
* `IS TRUE`: [operators](operators.md#isnull)
* `IS UNKNOWN`: [operators](operators.md#isnull)
* `IS_INF`: [float](float.md#is_inf)
* `IS_NAN`: [float](float.md#is_nan)
* `LAG` (aggregate): [aggregates](aggregates.md#lag)
* `LATERAL`: [grammar](grammar.md#lateral)
* `LEAD` (aggregate): [aggregates](aggregates.md#lead)
* `LEAST`: [comparisons](comparisons.md#least)
* `LEFT`: [string](string.md#left)
* `LEN`: [string](string.md#char_length)
* `LENGTH`: [string](string.md#char_length)
* `LIKE`: [string](string.md#like)
* `LN`: [decimal](decimal.md#ln), [float](float.md#ln)
* `LOG`: [float](float.md#log)
* `LOG10`: [decimal](decimal.md#log10), [float](float.md#log10)
* `LOGICAL_AND` (aggregate): [aggregates](aggregates.md#logical_and)
* `LOGICAL_OR` (aggregate): [aggregates](aggregates.md#logical_or)
* `LOWER`: [string](string.md#lower)
* `MAP` (aggregate): [aggregates](aggregates.md#map)
* `MAP_CONTAINS_KEY`: [map](map.md#map_contains_key)
* `MAX` (aggregate): [aggregates](aggregates.md#max), [aggregates](aggregates.md#window-max)
* `MIN` (aggregate): [aggregates](aggregates.md#min), [aggregates](aggregates.md#window-min)
* `MINUTE`: [datetime](datetime.md#date_minute), [datetime](datetime.md#time_minute), [datetime](datetime.md#timestamp_minute)
* `MOD`: [integer](integer.md#mod)
* `MONTH`: [datetime](datetime.md#month)
* `NOT`: [boolean](boolean.md#not)
* `NOT BETWEEN`: [comparisons](comparisons.md#notbetween)
* `NOT ILIKE`: [string](string.md#ilike)
* `NOT IN`: [comparisons](comparisons.md#in)
* `NOT LIKE`: [string](string.md#like)
* `NOT RLIKE`: [string](string.md#rlike)
* `NOW`: [datetime](datetime.md#now)
* `NULLIF`: [comparisons](comparisons.md#nullif)
* `NULLS FIRST`: [grammar](grammar.md#order)
* `NULLS LAST`: [grammar](grammar.md#order)
* `OCTET_LENGTH`: [binary](binary.md#octet_length)
* `OR`: [boolean](boolean.md#or)
* `OVER`: [grammar](grammar.md#window-aggregates)
* `OVERLAPS`: [operators](operators.md#between)
* `OVERLAY`: [string](string.md#overlay), [binary](binary.md#overlay)
* `PARSE_DATE`: [datetime](datetime.md#date-parsing-and-formatting)
* `PARSE_JSON`: [json](json.md#parse_json)
* `PARSE_TIME`: [datetime](datetime.md#date-parsing-and-formatting)
* `PARSE_TIMESTAMP`: [datetime](datetime.md#date-parsing-and-formatting)
* `PI`: [float](float.md#pi)
* `POSITION`: [string](string.md#position)
* `POWER`: [decimal](decimal.md#power), [float](float.md#power)
* `QUARTER`: [datetime](datetime.md#quarter)
* `RADIANS`: [float](float.md#radians)
* `RANK` (aggregate): [aggregates](aggregates.md#rank)
* `REGEXP_REPLACE`: [string](string.md#regexp_replace)
* `REPEAT`: [string](string.md#repeat)
* `REPLACE`: [string](string.md#replace)
* `RESPECT NULLS`: [grammar](grammar.md#window-aggregates)
* `RLIKE`: [string](string.md#rlike)
* `ROLLUP`: [grammar](grammar.md#cube)
* `ROUND`: [float](float.md#round), [float](float.md#round2), [decimal](decimal.md#round), [decimal](decimal.md#round2)
* `ROW`: [types](types.md#row_constructor)
* `ROW_NUMBER` (aggregate): [aggregates](aggregates.md#row_number)
* `SAFE_CAST`: [casts](casts.md#safe-casts)
* `SEC`: [float](float.md#sec)
* `SECH`: [float](float.md#sech)
* `SECOND`: [datetime](datetime.md#date_second), [datetime](datetime.md#time_second), [datetime](datetime.md#timestamp_second)
* `SEQUENCE`: [integer](integer.md#sequence)
* `SIGN`: [decimal](decimal.md#sign)
* `SIN`: [float](float.md#sin)
* `SINH`: [float](float.md#sinh)
* `SOME` (aggregate): [aggregates](aggregates.md#some)
* `SORT_ARRAY`: [array](array.md#sort)
* `SPLIT`: [string](string.md#split)
* `SPLIT_PART`: [string](string.md#split_part)
* `SQRT`: [decimal](decimal.md#sqrt), [float](float.md#sqrt)
* `STDDEV` (aggregate): [aggregates](aggregates.md#stddev)
* `STDDEV_POP` (aggregate): [aggregates](aggregates.md#stddev_pop)
* `STDDEV_SAMP` (aggregate): [aggregates](aggregates.md#stddev_samp)
* `SUBSTR`: [string](string.md#substr)
* `SUBSTRING`: [string](string.md#substring)
* `SUM` (aggregate): [aggregates](aggregates.md#sum), [aggregates](aggregates.md#window-sum)
* `TABLE`: [table](table.md#syntax)
* `TAN`: [float](float.md#tan)
* `TANH`: [float](float.md#tanh)
* `TIME`: [datetime](datetime.md#time-literals)
* `TIMESTAMP`: [datetime](datetime.md#timestamp-literals)
* `TIMESTAMPADD`: [datetime](datetime.md#timestampadd)
* `TIMESTAMPDIFF`: [datetime](datetime.md#date_timestampdiff), [datetime](datetime.md#timestamp_timestampdiff)
* `TIMESTAMP_TRUNC`: [datetime](datetime.md#timestamp_trunc)
* `TIME_TRUNC`: [datetime](datetime.md#time_trunc)
* `TO_HEX`: [binary](binary.md#to_hex)
* `TO_INT`: [binary](binary.md#to_int)
* `TO_JSON`: [json](json.md#to_json)
* `TRIM`: [string](string.md#trim)
* `TRUNC`: [decimal](decimal.md#trunc), [decimal](decimal.md#trunc2), [float](float.md#trunc)
* `TRUNCATE`: [decimal](decimal.md#truncate), [float](float.md#truncate)
* `TUMBLE`: [table](table.md#tumble)
* `UNION`: [grammar](grammar.md#setop)
* `UNION ALL`: [grammar](grammar.md#setop)
* `UNIQUE`: [comparisons](comparisons.md#unique)
* `UNNEST`: [array](array.md#the-unnest-sql-operator)
* `UPPER`: [string](string.md#upper)
* `VALUES`: [grammar](grammar.md#values)
* `WEEK`: [datetime](datetime.md#week)
* `YEAR`: [datetime](datetime.md#year)
* `||`: [string](string.md#concat), [binary](binary.md#concat)