%: operators*: operators+: operators-: operators.: grammar/: operators::: casts<: comparisons<=: comparisons<=>: operators<>: comparisons=: comparisons>: comparisons>=: comparisonsABS: decimal, float, integer, datetimeACOS: floatACOSH: floatAND: booleanARG_MAX(aggregate): aggregatesARG_MIN(aggregate): aggregatesARRAY(aggregate): aggregatesARRAY: arrayARRAY_AGG(aggregate): aggregatesARRAY_APPEND: arrayARRAY_COMPACT: arrayARRAY_CONCAT: arrayARRAY_CONTAINS: arrayARRAY_DISTINCT: arrayARRAY_EXCEPT: arrayARRAY_EXISTS: arrayARRAY_INSERT: arrayARRAY_INTERSECT: arrayARRAY_JOIN: arrayARRAY_LENGTH: arrayARRAY_MAX: arrayARRAY_MIN: arrayARRAY_POSITION: arrayARRAY_PREPEND: arrayARRAY_REMOVE: arrayARRAY_REPEAT: arrayARRAY_REVERSE: arrayARRAY_SIZE: arrayARRAY_TO_STRING: arrayARRAY_UNION: arrayARRAYS_OVERLAP: arrayAS: grammarASCII: stringASIN: floatASINH: floatATAN: floatATAN2: floatATANH: floatAVG(aggregate): aggregates, aggregatesBETWEEN: comparisons, operatorsBETWEEN SYMMETRIC: comparisonsBIN2UTF8: binaryBIT_AND(aggregate): aggregatesBIT_OR(aggregate): aggregatesBIT_XOR(aggregate): aggregatesBOOL_AND(aggregate): aggregatesBOOL_OR(aggregate): aggregatesBROUND: decimalCARDINALITY: array, mapCASE: comparisonsCAST: castsCBRT: floatCEIL: decimal, float, datetime, datetime, datetimeCHAR_LENGTH: stringCHR: stringCOALESCE: comparisonsCONCAT: stringCONCAT_WS: stringCONNECTOR_METADATA: grammarCONTAINS: datetimeCOS: floatCOSH: floatCOT: floatCOTH: floatCOUNT(aggregate): aggregates, aggregates, aggregates, aggregatesCOUNTIF(aggregate): aggregatesCSC: floatCSCH: floatCUBE: grammarDATE: datetimeDATE_ADD: datetimeDATE_PART: datetime, datetime, datetimeDATE_SUB: datetimeDATE_TRUNC: datetimeDATEDIFF: datetime, datetimeDAYOFMONTH: datetime, datetimeDEFAULT: grammarDEGREES: floatDENSE_RANK(aggregate): aggregatesDESC: grammarDOW: datetime, datetimeDOY: datetimeELEMENT: arrayEQUALS: datetimeESCAPE: stringEVERY(aggregate): aggregatesEXCEPT: grammarEXCEPT ALL: grammarEXISTS: comparisonsEXP: floatEXTRACT: datetime, datetime, datetimeFILTER: aggregatesFLOOR: decimal, float, datetime, datetime, datetimeFORMAT_DATE: datetimeFORMAT_TIME: datetimeFORMAT_TIMESTAMP: datetimeGREATEST: comparisonsGREATEST_IGNORE_NULLS: comparisonsGROUPING: grammarGROUPING SETS: grammarGUNZIP: binaryHOP: tableHOUR: datetime, datetime, datetimeIF: comparisonsIFNULL: comparisonsIGNORE NULLS: grammarILIKE: stringIMMEDIATELY PRECEDES: datetimeIMMEDIATELY SUCCEEDS: datetimeIN: comparisonsINITCAP: stringINITCAP_SPACES: stringINTERSECT: grammarINTERVAL: datetimeIS DISTINCT FROM: comparisonsIS FALSE: operatorsIS NOT DISTINCT FROM: comparisonsIS NOT FALSE: operatorsIS NOT NULL: comparisons, operatorsIS NOT TRUE: operatorsIS NOT UNKNOWN: operatorsIS NULL: comparisons, operatorsIS TRUE: operatorsIS UNKNOWN: operatorsIS_INF: floatIS_NAN: floatLAG(aggregate): aggregatesLATERAL: grammarLEAD(aggregate): aggregatesLEAST: comparisonsLEAST_IGNORE_NULLS: comparisonsLEFT: string, binaryLEN: stringLENGTH: stringLIKE: stringLN: floatLOG: floatLOG10: floatLOGICAL_AND(aggregate): aggregatesLOGICAL_OR(aggregate): aggregatesLOWER: stringMAP(aggregate): aggregatesMAP: mapMAP_CONTAINS_KEY: mapMAP_KEYS: mapMAP_VALUES: mapMAX(aggregate): aggregates, aggregatesMD5: string, binaryMIN(aggregate): aggregates, aggregatesMINUTE: datetime, datetime, datetimeMOD: integerMONTH: datetimeNOT: booleanNOT BETWEEN: comparisonsNOT BETWEEN SYMMETRIC: comparisonsNOT ILIKE: stringNOT IN: comparisonsNOT LIKE: stringNOT RLIKE: stringNOW: datetimeNULLIF: comparisonsNULLS FIRST: grammarNULLS LAST: grammarOCTET_LENGTH: binaryOR: booleanOVER: grammarOVERLAPS: datetimeOVERLAY: string, binaryPARSE_DATE: datetimePARSE_JSON: jsonPARSE_TIME: datetimePARSE_TIMESTAMP: datetimePI: floatPOSITION: stringPOWER: floatPRECEDES: datetimeQUARTER: datetimeRADIANS: floatRANK(aggregate): aggregatesREGEXP_REPLACE: stringREPEAT: stringREPLACE: stringRESPECT NULLS: grammarRIGHT: string, binaryRLIKE: stringRLIKE: stringROLLUP: grammarROUND: float, float, decimal, decimalROW: typesROW_NUMBER(aggregate): aggregatesSAFE_CAST: castsSAFE_OFFSET: arraySEC: floatSECH: floatSECOND: datetime, datetime, datetimeSEQUENCE: integerSIGN: decimalSIN: floatSINH: floatSOME(aggregate): aggregatesSORT_ARRAY: arraySPLIT: stringSPLIT_PART: stringSQRT: floatSTDDEV(aggregate): aggregatesSTDDEV_POP(aggregate): aggregatesSTDDEV_SAMP(aggregate): aggregatesSUBSTR: stringSUBSTRING: stringSUCCEEDS: datetimeSUM(aggregate): aggregates, aggregatesTABLE: tableTAN: floatTANH: floatTIME: datetimeTIME_TRUNC: datetimeTIMESTAMP: datetimeTIMESTAMP_TRUNC: datetimeTIMESTAMPADD: datetimeTIMESTAMPDIFF: datetime, datetimeTO_HEX: binaryTO_INT: binaryTO_JSON: jsonTRANSFORM: arrayTRIM: stringTRUNC: decimal, floatTRUNCATE: decimal, decimal, float, floatTUMBLE: tableUNION: grammarUNION ALL: grammarUNNEST: array, mapUPPER: stringVALUES: grammarWEEK: datetimeYEAR: datetime||: string, binary