K i?0dZgdZgdZgdZgdZgdZy)z pygments.lexers._googlesql_builtins ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Autogenerated data files for the GoogleSQL lexer. :copyright: Copyright 2006-2025 by the Pygments team, see AUTHORS. :license: BSD, see LICENSE for details. )FALSENULLTRUEUNKNOWN(ABSACOSACOSHzAEAD.DECRYPT_BYTESzAEAD.DECRYPT_STRINGz AEAD.ENCRYPTzAEAD.ENVELOPE_DECRYPT_BYTESzAEAD.ENVELOPE_DECRYPT_STRINGzAEAD.ENVELOPE_ENCRYPT ALL_DIFFERENTANON_AVG ANON_COUNTr ANON_PERCENTILE_CONTANON_QUANTILESANON_STDDEV_POPANON_SUM ANON_VAR_POP ANY_VALUEAPPROX_COSINE_DISTANCEAPPROX_COUNT_DISTINCTAPPROX_DOT_PRODUCTAPPROX_EUCLIDEAN_DISTANCEAPPROX_QUANTILESAPPROX_TOP_COUNTAPPROX_TOP_SUMz ARRAY[KEY()]zARRAY[SAFE_KEY()] ARRAY_AGG ARRAY_AVG ARRAY_CONCATARRAY_CONCAT_AGG ARRAY_FILTER ARRAY_FINDARRAY_FIND_ALL ARRAY_FIRST ARRAY_FIRST_NARRAY_INCLUDESARRAY_INCLUDES_ALLARRAY_INCLUDES_ANYARRAY_IS_DISTINCT ARRAY_LAST ARRAY_LAST_N ARRAY_LENGTH ARRAY_MAX ARRAY_MIN ARRAY_OFFSET ARRAY_OFFSETSARRAY_REMOVE_FIRST_NARRAY_REMOVE_LAST_N ARRAY_REVERSE ARRAY_SLICE ARRAY_SUMARRAY_TO_STRINGARRAY_TRANSFORM ARRAY_ZIPASCIIASINASINHATANATAN2ATANHAVGBIT_AND BIT_COUNTBIT_ORBIT_XORBOOL BOOL_ARRAY BYTE_LENGTHCASECASTCBRTCEILCEILINGCHARACTER_LENGTH CHAR_LENGTHCHRCOALESCECODE_POINTS_TO_BYTESCODE_POINTS_TO_STRINGCOLLATECONCATCORRCOSCOSHCOSINE_DISTANCECOTCOTHCOUNTzCOUNT(*)COUNTIF COVAR_POP COVAR_SAMPCSCCSCH CUME_DIST CURRENT_DATECURRENT_DATETIME CURRENT_TIMECURRENT_TIMESTAMPzD3A_COUNT.EXTRACTzD3A_COUNT.INITzD3A_COUNT.MERGEzD3A_COUNT.MERGE_PARTIALzD3A_COUNT.TO_HLLDATEDATETIME DATETIME_ADDDATETIME_BUCKET DATETIME_DIFF DATETIME_SUBDATETIME_TRUNCDATE_ADD DATE_BUCKET DATE_DIFFDATE_FROM_UNIX_DATEDATE_SUB DATE_TRUNC DENSE_RANKDESTINATION_NODE_IDDETERMINISTIC_DECRYPT_BYTESDETERMINISTIC_DECRYPT_STRINGDETERMINISTIC_ENCRYPTDIV DOT_PRODUCTEDGES EDIT_DISTANCEELEMENTWISE_AVGELEMENTWISE_SUMELEMENT_DEFINITION_NAME ELEMENT_ID ENDS_WITHENUM_VALUE_DESCRIPTOR_PROTOERROREUCLIDEAN_DISTANCEEXPEXTRACT$EXTRACT_FOR_DP_APPROX_COUNT_DISTINCTFARM_FINGERPRINT FILTER_FIELDS FIRST_VALUEFLATTENFLOAT32 FLOAT32_ARRAYFLOAT64 FLOAT64_ARRAYFLOORFORMAT FORMAT_DATEFORMAT_DATETIME FORMAT_TIMEFORMAT_TIMESTAMP FROM_BASE32 FROM_BASE64FROM_HEXGENERATE_ARRAYGENERATE_DATE_ARRAYGENERATE_RANGE_ARRAYGENERATE_TIMESTAMP_ARRAY GENERATE_UUIDGREATESTGROUPINGzHLL_COUNT.EXTRACTzHLL_COUNT.INITzHLL_COUNT.MERGEzHLL_COUNT.MERGE_PARTIAL IEEE_DIVIDEIFIFERRORIFNULLz IN UNNESTINITCAP!INIT_FOR_DP_APPROX_COUNT_DISTINCTINSTRINT64 INT64_ARRAYzIS DESTINATION OFzIS DISTINCT FROMzIS NOT DISTINCT FROMz IS SOURCE OFISERROR IS_ACYCLICIS_INFIS_NAN IS_SIMPLEIS_TRAIL JSON_ARRAYJSON_ARRAY_APPENDJSON_ARRAY_INSERT JSON_CONTAINS JSON_EXTRACTJSON_EXTRACT_ARRAYJSON_EXTRACT_SCALARJSON_EXTRACT_STRING_ARRAY JSON_KEYS JSON_OBJECT JSON_QUERYJSON_QUERY_ARRAY JSON_REMOVEJSON_SETJSON_STRIP_NULLS JSON_TYPE JSON_VALUEJSON_VALUE_ARRAY JUSTIFY_DAYS JUSTIFY_HOURSJUSTIFY_INTERVALzKEYS.ADD_KEY_FROM_RAW_BYTESzKEYS.KEYSET_CHAINzKEYS.KEYSET_FROM_JSONzKEYS.KEYSET_LENGTHzKEYS.KEYSET_TO_JSONzKEYS.NEW_KEYSETzKEYS.NEW_WRAPPED_KEYSETzKEYS.REWRAP_KEYSETzKEYS.ROTATE_KEYSETzKEYS.ROTATE_WRAPPED_KEYSETzKLL_QUANTILES.EXTRACT_FLOAT64zKLL_QUANTILES.EXTRACT_INT64z#KLL_QUANTILES.EXTRACT_POINT_FLOAT64z!KLL_QUANTILES.EXTRACT_POINT_INT64zKLL_QUANTILES.INIT_FLOAT64zKLL_QUANTILES.INIT_INT64zKLL_QUANTILES.MERGE_FLOAT64zKLL_QUANTILES.MERGE_INT64zKLL_QUANTILES.MERGE_PARTIALz!KLL_QUANTILES.MERGE_POINT_FLOAT64zKLL_QUANTILES.MERGE_POINT_INT64L1_NORML2_NORMLABELSLAGLAST_DAY LAST_VALUELAX_BOOLLAX_BOOL_ARRAY LAX_FLOAT32LAX_FLOAT32_ARRAY LAX_FLOAT64LAX_FLOAT64_ARRAY LAX_INT64LAX_INT64_ARRAY LAX_STRINGLAX_STRING_ARRAYLEADLEASTLEFTLENGTHzLIKE ALLzLIKE ALL UNNESTzLIKE ANYzLIKE ANY UNNESTLNLOGLOG10 LOGICAL_AND LOGICAL_ORLOWERLPADLTRIM MAKE_INTERVALMANHATTAN_DISTANCEMAP_CARDINALITYMAP_CONTAINS_KEY MAP_DELETE MAP_EMPTYMAP_ENTRIES_SORTEDMAP_ENTRIES_UNSORTED MAP_FILTERMAP_FROM_ARRAYMAP_GET MAP_INSERTMAP_INSERT_OR_REPLACEMAP_KEYS_SORTEDMAP_KEYS_UNSORTED MAP_REPLACEMAP_VALUES_SORTEDMAP_VALUES_SORTED_BY_KEYMAP_VALUES_UNSORTEDMAXMD5*MERGE_PARTIAL_FOR_DP_APPROX_COUNT_DISTINCTMINMODzNET.HOSTzNET.IPV4_FROM_INT64zNET.IPV4_TO_INT64zNET.IP_FROM_STRINGzNET.IP_NET_MASKzNET.IP_TO_STRINGz NET.IP_TRUNCzNET.PUBLIC_SUFFIXzNET.REG_DOMAINzNET.SAFE_IP_FROM_STRINGNEW_UUIDNODES NORMALIZENORMALIZE_AND_CASEFOLDz NOT LIKE ALLzNOT LIKE ALL UNNESTz NOT LIKE ANYzNOT LIKE ANY UNNEST NTH_VALUENTILENULLIF NULLIFERROR NULLIFZERO OCTET_LENGTHOFFSETORDINALPARSE_BIGNUMERIC PARSE_DATEPARSE_DATETIME PARSE_JSON PARSE_NUMERIC PARSE_TIMEPARSE_TIMESTAMPPATH PATH_FIRST PATH_LAST PATH_LENGTHPERCENTILE_CONTPERCENTILE_DISC PERCENT_RANKPIPIVOT PI_BIGNUMERIC PI_NUMERICPOWPOWERPROPERTY_EXISTSPROPERTY_NAMESPROTO_MAP_CONTAINS_KEYPROTO_MODIFY_MAPRANDRANGE RANGE_BUCKETRANGE_CONTAINS RANGE_ENDRANGE_INTERSECTRANGE_IS_END_UNBOUNDEDRANGE_IS_START_UNBOUNDEDRANGE_OVERLAPS RANGE_STARTRANKREGEXP_CONTAINSREGEXP_EXTRACTREGEXP_EXTRACT_ALL REGEXP_INSTRREGEXP_REPLACE REGEXP_SUBSTRREPEATREPLACEREVERSERIGHTROUND ROW_NUMBERRPADRTRIMS2_CELLIDFROMPOINTS2_COVERINGCELLIDSSAFE_ADDSAFE_CONVERT_BYTES_TO_STRING SAFE_DIVIDE SAFE_MULTIPLY SAFE_NEGATE SAFE_OFFSET SAFE_ORDINAL SAFE_SUBTRACT SAFE_TO_JSONSAMESECSECH SESSION_USERSHA1SHA256SHA512SIGNSINSINHSOUNDEXSOURCE_NODE_IDSPLIT SPLIT_SUBSTRSQRT STARTS_WITHSTDDEV STDDEV_POP STDDEV_SAMPSTRING STRING_AGG STRING_ARRAYSTRPOSST_ANGLEST_AREA ST_ASBINARY ST_ASGEOJSONST_ASKML ST_ASTEXT ST_AZIMUTH ST_BOUNDARYST_BOUNDINGBOX ST_BUFFERST_BUFFERWITHTOLERANCE ST_CENTROIDST_CENTROID_AGGST_CLOSESTPOINTST_CLUSTERDBSCAN ST_CONTAINS ST_CONVEXHULL ST_COVEREDBY ST_COVERS ST_DIFFERENCE ST_DIMENSION ST_DISJOINT ST_DISTANCEST_DUMP ST_DUMPPOINTS ST_DWITHIN ST_ENDPOINT ST_EQUALS ST_EXTENTST_EXTERIORRING ST_GEOGFROMST_GEOGFROMGEOJSONST_GEOGFROMKMLST_GEOGFROMTEXTST_GEOGFROMWKB ST_GEOGPOINTST_GEOGPOINTFROMGEOHASH ST_GEOHASHST_GEOMETRYTYPEST_HAUSDORFFDISTANCEST_HAUSDORFFDWITHINST_INTERIORRINGSST_INTERSECTION ST_INTERSECTSST_INTERSECTSBOX ST_ISCLOSEDST_ISCOLLECTION ST_ISEMPTY ST_ISRING ST_LENGTHST_LINEINTERPOLATEPOINTST_LINELOCATEPOINTST_LINESUBSTRING ST_MAKELINEST_MAKEPOLYGONST_MAKEPOLYGONORIENTEDST_MAXDISTANCEST_NEAREST_NEIGHBORS ST_NPOINTSST_NUMGEOMETRIES ST_NUMPOINTS ST_PERIMETER ST_POINTN ST_SIMPLIFY ST_SNAPTOGRID ST_STARTPOINT ST_TOUCHES ST_UNARYUNIONST_UNION ST_UNION_AGG ST_WITHINST_XST_YSUBSTR SUBSTRINGSUMTANTANHTIME TIMESTAMP TIMESTAMP_ADDTIMESTAMP_BUCKETTIMESTAMP_DIFFTIMESTAMP_FROM_UNIX_MICROSTIMESTAMP_FROM_UNIX_MILLISTIMESTAMP_FROM_UNIX_SECONDSTIMESTAMP_MICROSTIMESTAMP_MILLISTIMESTAMP_SECONDS TIMESTAMP_SUBTIMESTAMP_TRUNCTIME_ADD TIME_DIFFTIME_SUB TIME_TRUNC TO_BASE32 TO_BASE64TO_CODE_POINTSTO_HEXTO_JSONTO_JSON_STRING TRANSLATETRIMTRUNCTYPEOFUNICODE UNIX_DATE UNIX_MICROS UNIX_MILLIS UNIX_SECONDSUNNESTUNPIVOTUPPERVARIANCEVAR_POPVAR_SAMP ZEROIFNULL(HABORTACCESSACTIONACYCLICADDAFTER AGGREGATEALLALTERALWAYSANALYZEANDANYAPPROXAREASASC ASCENDINGASSERTASSERT_ROWS_MODIFIEDATBATCHBEGINBETWEEN BIGDECIMALBREAKBYCALLCASCADErCrDCHECKCLAMPEDCLONECLUSTERrNCOLUMNCOLUMNSCOMMITCONFLICT CONNECTIONCONSTANT CONSTRAINTCONTAINSCONTINUECOPY CORRESPONDINGCREATECROSSCUBECURRENTCYCLEDATADATABASEDAY DAYOFWEEK DAYOFYEARDECIMALDECLAREDEFAULTDEFINEDEFINERDELETEDELETIONDEPTHDESC DESCENDINGDESCRIBE DESCRIPTOR DESTINATION DETERMINISTICDISTINCTDODROPEDGEELSEELSEIFENDENFORCEDr}ESCAPEEXCEPT EXCEPTIONEXCLUDEEXECUTEEXISTSEXPLAINEXPORTEXTENDEXTERNALrrFETCHFIELDFILESFILLFILTERFIRST FOLLOWINGFORFOREIGNFORKrFRIDAYFROMFULLFUNCTION GENERATEDGRANTGRAPH GRAPH_TABLEGROUPrGROUPS GROUP_ROWSHASHASHHAVINGHIDDENHOURIDENTITYrIGNORE IMMEDIATE IMMUTABLEIMPORTININCLUDE INCREMENTINDEXINNERINOUTINPUTINSERT INTERLEAVE INTERSECTINTOINVOKERIS ISOLATIONzISOWEEK ISOYEARITERATEJOINKEYLABELLABELEDLANGUAGELASTLATERALLEAVErLETLEVELLIKELIMITLOADrLOOKUPLOOPMACROMATCHMATCHEDMATCH_RECOGNIZE MATERIALIZEDrMAXVALUEMEASURESMERGEMESSAGEMETADATA MICROSECOND MILLISECONDrMINUTEMINVALUEMODELMODULEMONDAYMONTHNAME NANOSECONDNATURALNEWNEXTNONODENOTNOTHINGrNULLS NULL_FILTEREDOFrON ONEOF_CASEONLYOPTIONALOPTIONSORORDEROUTOUTEROUTPUTOVER OVERWRITEPARENT PARTITION PARTITIONSPASTrPATHSPATTERNPERCENTr POLICIESPOLICY PRECEDINGPRIMARYPRIVATE PRIVILEGE PRIVILEGES PROCEDUREPROJECT PROPERTIESPROPERTYPUBLICQUALIFYQUARTERRAISERAWREAD RECURSIVE REFERENCESREMOTEREMOVERENAMEr' REPEATABLEr(REPLACE_FIELDSREPLICAREPORTRESPECTRESTRICT RESTRICTIONRETURNRETURNSREVOKEr*ROLLBACKROLLUPROWROWSRUN SAFE_CASTSATURDAYSCHEMASEARCHzSECOND SECURITYSELECTSEQUENCESETSETSSHORTESTSHOWSIMPLESKIPSNAPSHOTSOMESOURCESQLSTABLESTARTSTATIC_DESCRIBESTOREDSTORINGSTRICTSUNDAYSYSTEM SYSTEM_TIMETABLETABLES TABLESAMPLETARGETTEMP TEMPORARYTHENTHURSDAYTOTRAIL TRANSACTION TRANSFORMTREATrTRUNCATETUESDAYTYPE UNBOUNDEDUNDROPUNIONUNIQUErrrUNTILUPDATEUSINGVALUEVALUESVECTORVIEWVIEWSVOLATILEWALK WEDNESDAYWEEKWEIGHTWHENWHEREWHILEWINDOWWITHWITHINWRITEYEARZONE)z!=&*+-/z>=z>>^|z||~)ARRAY BIGNUMERICr@BYTESrarbDOUBLEENUMEXTENDEDFLOAT GEOGRAPHY GRAPH_ELEMENT GRAPH_PATHINT32rINTERVALJSONMAPMEASURENUMERICPROTOrrMSTRUCTrrTIMESTAMP_PICOS TOKENLISTUINT32UINT64UUIDN)__doc__ constants functionnameskeywords operatorstypesi/mnt/ssd/data/python-lab/Trading/venv/lib/python3.12/site-packages/pygments/lexers/_googlesql_builtins.pyrs1  @ DI V   ( r