1"use strict";(globalThis.webpackChunkwebsite=globalThis.webpackChunkwebsite||[]).push([[8746],{1583(d,e,s){s.r(e),s.d(e,{assets:()=>c,contentTitle:()=>i,default:()=>j,frontMatter:()=>r,metadata:()=>l,toc:()=>h});const l=JSON.parse('{"id":"syntax/stdlib-reference","title":"Standard Library Reference","description":"\x3c!-- Generated from wvlet-stdlib/module/standard/*.wv. DO NOT EDIT.","source":"@site/docs/syntax/stdlib-reference.md","sourceDirName":"syntax","slug":"/syntax/stdlib-reference","permalink":"/wvlet/docs/syntax/stdlib-reference","draft":false,"unlisted":false,"editUrl":"https://github.com/wvlet/wvlet/tree/main/website/docs/syntax/stdlib-reference.md","tags":[],"version":"current","frontMatter":{"sidebar_label":"Stdlib Reference"},"sidebar":"tutorialSidebar","previous":{"title":"Data Models","permalink":"/wvlet/docs/syntax/data-models"},"next":{"title":"Standard Library Functions","permalink":"/wvlet/docs/syntax/stdlib"}}');var n=s(1058),t=s(6798);const r={sidebar_label:"Stdlib Reference"},i="Standard Library Reference",c={},h=[{value:"Any Values",id:"any-values",level:2},{value:"Numeric Values",id:"numeric-values",level:2},{value:"Int Values",id:"int-values",level:2},{value:"Long Values",id:"long-values",level:2},{value:"Float Values",id:"float-values",level:2},{value:"Real Values",id:"real-values",level:2},{value:"Double Values",id:"double-values",level:2},{value:"Decimal Values",id:"decimal-values",level:2},{value:"Boolean Values",id:"boolean-values",level:2},{value:"String Values",id:"string-values",level:2},{value:"Date Values",id:"date-values",level:2},{value:"Timestamp Values",id:"timestamp-values",level:2},{value:"JSON Values",id:"json-values",level:2},{value:"Null Values",id:"null-values",level:2},{value:"Array Values",id:"array-values",level:2},{value:"Map Values",id:"map-values",level:2},{value:"Top-Level Functions",id:"top-level-functions",level:2}];function x(d){const e={a:"a",code:"code",h1:"h1",h2:"h2",header:"header",p:"p",strong:"strong",table:"table",tbody:"tbody",td:"td",th:"th",thead:"thead",tr:"tr",...(0,t.R)(),...d.components};return(0,n.jsxs)(n.Fragment,{children:[(0,n.jsx)(e.header,{children:(0,n.jsx)(e.h1,{id:"standard-library-reference",children:"Standard Library Reference"})}),"\n",(0,n.jsxs)(e.p,{children:["Complete listing of the functions defined in the Wvlet standard library, generated from\nits sources. Call these with dot syntax on a value of the listed type (e.g. ",(0,n.jsx)(e.code,{children:"name.upper"}),",\n",(0,n.jsx)(e.code,{children:"price.round(2)"}),"). See ",(0,n.jsx)(e.a,{href:"/wvlet/docs/syntax/stdlib",children:"Standard Library Functions"})," for a guided tour with\nexamples."]}),"\n",(0,n.jsxs)(e.p,{children:["The ",(0,n.jsx)(e.strong,{children:"Engines"})," column lists the engines a definition is specialized for; ",(0,n.jsx)(e.strong,{children:"all"})," means a\nsingle dialect-neutral definition serves every supported engine (DuckDB, Trino, Hive,\nSnowflake, and BigQuery). Engine-specific SQL is selected automatically for the compile\ntarget."]}),"\n",(0,n.jsx)(e.h2,{id:"any-values",children:"Any Values"}),"\n",(0,n.jsx)(e.p,{children:"Available on values of every type."}),"\n",(0,n.jsxs)(e.table,{children:[(0,n.jsx)(e.thead,{children:(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.th,{children:"Function"}),(0,n.jsx)(e.th,{children:"Returns"}),(0,n.jsx)(e.th,{children:"Engines"}),(0,n.jsx)(e.th,{children:"Description"})]})}),(0,n.jsxs)(e.tbody,{children:[(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.td,{children:(0,n.jsx)(e.code,{children:"to_string"})}),(0,n.jsx)(e.td,{children:"string"}),(0,n.jsx)(e.td,{children:"all"}),(0,n.jsx)(e.td,{})]}),(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.td,{children:(0,n.jsx)(e.code,{children:"to_int"})}),(0,n.jsx)(e.td,{children:"int"}),(0,n.jsx)(e.td,{children:"all"}),(0,n.jsx)(e.td,{})]}),(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.td,{children:(0,n.jsx)(e.code,{children:"to_long"})}),(0,n.jsx)(e.td,{children:"long"}),(0,n.jsx)(e.td,{children:"all"}),(0,n.jsx)(e.td,{})]}),(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.td,{children:(0,n.jsx)(e.code,{children:"to_float"})}),(0,n.jsx)(e.td,{children:"float"}),(0,n.jsx)(e.td,{children:"all"}),(0,n.jsx)(e.td,{})]}),(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.td,{children:(0,n.jsx)(e.code,{children:"to_double"})}),(0,n.jsx)(e.td,{children:"double"}),(0,n.jsx)(e.td,{children:"all"}),(0,n.jsx)(e.td,{})]}),(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.td,{children:(0,n.jsx)(e.code,{children:"to_boolean"})}),(0,n.jsx)(e.td,{children:"boolean"}),(0,n.jsx)(e.td,{children:"all"}),(0,n.jsx)(e.td,{})]}),(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.td,{children:(0,n.jsx)(e.code,{children:"to_date"})}),(0,n.jsx)(e.td,{children:"date"}),(0,n.jsx)(e.td,{children:"all"}),(0,n.jsx)(e.td,{children:"Cast to the SQL date type"})]}),(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.td,{children:(0,n.jsx)(e.code,{children:"to_timestamp"})}),(0,n.jsx)(e.td,{children:"timestamp"}),(0,n.jsx)(e.td,{children:"all"}),(0,n.jsx)(e.td,{children:"Cast to the SQL timestamp type"})]}),(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.td,{children:(0,n.jsx)(e.code,{children:"is_null"})}),(0,n.jsx)(e.td,{children:"boolean"}),(0,n.jsx)(e.td,{children:"all"}),(0,n.jsx)(e.td,{children:"True if this value is null"})]}),(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.td,{children:(0,n.jsx)(e.code,{children:"is_not_null"})}),(0,n.jsx)(e.td,{children:"boolean"}),(0,n.jsx)(e.td,{children:"all"}),(0,n.jsx)(e.td,{})]}),(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.td,{children:(0,n.jsx)(e.code,{children:"or_else(other: any)"})}),(0,n.jsx)(e.td,{children:"any"}),(0,n.jsx)(e.td,{children:"all"}),(0,n.jsx)(e.td,{children:"Return the other value if this value is null"})]}),(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.td,{children:(0,n.jsx)(e.code,{children:"null_if(v: any)"})}),(0,n.jsx)(e.td,{children:"any"}),(0,n.jsx)(e.td,{children:"all"}),(0,n.jsx)(e.td,{children:"Return null if this value equals the given value"})]}),(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.td,{children:(0,n.jsx)(e.code,{children:"type_of"})}),(0,n.jsx)(e.td,{children:"string"}),(0,n.jsx)(e.td,{children:"all"}),(0,n.jsx)(e.td,{children:"Name of the runtime type of this value"})]}),(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.td,{children:(0,n.jsx)(e.code,{children:"to_json"})}),(0,n.jsx)(e.td,{children:"json"}),(0,n.jsx)(e.td,{children:"duckdb, trino"}),(0,n.jsx)(e.td,{})]})]})]}),"\n",(0,n.jsx)(e.h2,{id:"numeric-values",children:"Numeric Values"}),"\n",(0,n.jsx)(e.p,{children:"Shared by all numeric types (int, long, float, real, double, decimal)."}),"\n",(0,n.jsxs)(e.table,{children:[(0,n.jsx)(e.thead,{children:(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.th,{children:"Function"}),(0,n.jsx)(e.th,{children:"Returns"}),(0,n.jsx)(e.th,{children:"Engines"}),(0,n.jsx)(e.th,{children:"Description"})]})}),(0,n.jsxs)(e.tbody,{children:[(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.td,{children:(0,n.jsx)(e.code,{children:"round(decimal: int)"})}),(0,n.jsx)(e.td,{children:"double"}),(0,n.jsx)(e.td,{children:"all"}),(0,n.jsx)(e.td,{children:"Round to the given number of decimal places"})]}),(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.td,{children:(0,n.jsx)(e.code,{children:"sqrt"})}),(0,n.jsx)(e.td,{children:"double"}),(0,n.jsx)(e.td,{children:"all"}),(0,n.jsx)(e.td,{})]}),(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.td,{children:(0,n.jsx)(e.code,{children:"cbrt"})}),(0,n.jsx)(e.td,{children:"double"}),(0,n.jsx)(e.td,{children:"all"}),(0,n.jsx)(e.td,{})]}),(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.td,{children:(0,n.jsx)(e.code,{children:"exp"})}),(0,n.jsx)(e.td,{children:"double"}),(0,n.jsx)(e.td,{children:"all"}),(0,n.jsx)(e.td,{})]}),(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.td,{children:(0,n.jsx)(e.code,{children:"ln"})}),(0,n.jsx)(e.td,{children:"double"}),(0,n.jsx)(e.td,{children:"all"}),(0,n.jsx)(e.td,{})]}),(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.td,{children:(0,n.jsx)(e.code,{children:"log10"})}),(0,n.jsx)(e.td,{children:"double"}),(0,n.jsx)(e.td,{children:"all"}),(0,n.jsx)(e.td,{})]}),(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.td,{children:(0,n.jsx)(e.code,{children:"log2"})}),(0,n.jsx)(e.td,{children:"double"}),(0,n.jsx)(e.td,{children:"all"}),(0,n.jsx)(e.td,{})]}),(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.td,{children:(0,n.jsx)(e.code,{children:"power(exponent: double)"})}),(0,n.jsx)(e.td,{children:"double"}),(0,n.jsx)(e.td,{children:"all"}),(0,n.jsx)(e.td,{})]}),(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.td,{children:(0,n.jsx)(e.code,{children:"sign"})}),(0,n.jsx)(e.td,{children:"int"}),(0,n.jsx)(e.td,{children:"all"}),(0,n.jsx)(e.td,{})]}),(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.td,{children:(0,n.jsx)(e.code,{children:"in(v: any*)"})}),(0,n.jsx)(e.td,{children:"boolean"}),(0,n.jsx)(e.td,{children:"all"}),(0,n.jsx)(e.td,{})]}),(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.td,{children:(0,n.jsx)(e.code,{children:"not_in(v: any*)"})}),(0,n.jsx)(e.td,{children:"boolean"}),(0,n.jsx)(e.td,{children:"all"}),(0,n.jsx)(e.td,{})]})]})]}),"\n",(0,n.jsx)(e.h2,{id:"int-values",children:"Int Values"}),"\n",(0,n.jsxs)(e.table,{children:[(0,n.jsx)(e.thead,{children:(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.th,{children:"Function"}),(0,n.jsx)(e.th,{children:"Returns"}),(0,n.jsx)(e.th,{children:"Engines"}),(0,n.jsx)(e.th,{children:"Description"})]})}),(0,n.jsxs)(e.tbody,{children:[(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.td,{children:(0,n.jsx)(e.code,{children:"to_int"})}),(0,n.jsx)(e.td,{children:"int"}),(0,n.jsx)(e.td,{children:"all"}),(0,n.jsx)(e.td,{})]}),(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.td,{children:(0,n.jsx)(e.code,{children:"to_long"})}),(0,n.jsx)(e.td,{children:"long"}),(0,n.jsx)(e.td,{children:"all"}),(0,n.jsx)(e.td,{})]}),(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.td,{children:(0,n.jsx)(e.code,{children:"to_float"})}),(0,n.jsx)(e.td,{children:"float"}),(0,n.jsx)(e.td,{children:"all"}),(0,n.jsx)(e.td,{})]}),(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.td,{children:(0,n.jsx)(e.code,{children:"to_double"})}),(0,n.jsx)(e.td,{children:"double"}),(0,n.jsx)(e.td,{children:"all"}),(0,n.jsx)(e.td,{})]}),(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.td,{children:(0,n.jsx)(e.code,{children:"to_boolean"})}),(0,n.jsx)(e.td,{children:"boolean"}),(0,n.jsx)(e.td,{children:"all"}),(0,n.jsx)(e.td,{})]}),(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.td,{children:(0,n.jsx)(e.code,{children:"to_string"})}),(0,n.jsx)(e.td,{children:"string"}),(0,n.jsx)(e.td,{children:"all"}),(0,n.jsx)(e.td,{})]}),(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.td,{children:(0,n.jsx)(e.code,{children:"or_else(other: int)"})}),(0,n.jsx)(e.td,{children:"int"}),(0,n.jsx)(e.td,{children:"all"}),(0,n.jsx)(e.td,{})]}),(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.td,{children:(0,n.jsx)(e.code,{children:"abs"})}),(0,n.jsx)(e.td,{children:"int"}),(0,n.jsx)(e.td,{children:"all"}),(0,n.jsx)(e.td,{})]}),(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.td,{children:(0,n.jsx)(e.code,{children:"ceil"})}),(0,n.jsx)(e.td,{children:"int"}),(0,n.jsx)(e.td,{children:"all"}),(0,n.jsx)(e.td,{})]}),(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.td,{children:(0,n.jsx)(e.code,{children:"floor"})}),(0,n.jsx)(e.td,{children:"int"}),(0,n.jsx)(e.td,{children:"all"}),(0,n.jsx)(e.td,{})]}),(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.td,{children:(0,n.jsx)(e.code,{children:"mod(divisor: int)"})}),(0,n.jsx)(e.td,{children:"int"}),(0,n.jsx)(e.td,{children:"all"}),(0,n.jsx)(e.td,{})]}),(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.td,{children:(0,n.jsx)(e.code,{children:"from_unixtime"})}),(0,n.jsx)(e.td,{children:"timestamp"}),(0,n.jsx)(e.td,{children:"duckdb, trino, hive, snowflake, bigquery"}),(0,n.jsx)(e.td,{children:"Interpret this value as a unix epoch second (in UTC)"})]}),(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.td,{children:(0,n.jsx)(e.code,{children:"between(l: int, r: int)"})}),(0,n.jsx)(e.td,{children:"boolean"}),(0,n.jsx)(e.td,{children:"all"}),(0,n.jsx)(e.td,{})]})]})]}),"\n",(0,n.jsx)(e.h2,{id:"long-values",children:"Long Values"}),"\n",(0,n.jsxs)(e.table,{children:[(0,n.jsx)(e.thead,{children:(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.th,{children:"Function"}),(0,n.jsx)(e.th,{children:"Returns"}),(0,n.jsx)(e.th,{children:"Engines"}),(0,n.jsx)(e.th,{children:"Description"})]})}),(0,n.jsxs)(e.tbody,{children:[(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.td,{children:(0,n.jsx)(e.code,{children:"to_int"})}),(0,n.jsx)(e.td,{children:"int"}),(0,n.jsx)(e.td,{children:"all"}),(0,n.jsx)(e.td,{})]}),(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.td,{children:(0,n.jsx)(e.code,{children:"to_long"})}),(0,n.jsx)(e.td,{children:"long"}),(0,n.jsx)(e.td,{children:"all"}),(0,n.jsx)(e.td,{})]}),(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.td,{children:(0,n.jsx)(e.code,{children:"to_float"})}),(0,n.jsx)(e.td,{children:"float"}),(0,n.jsx)(e.td,{children:"all"}),(0,n.jsx)(e.td,{})]}),(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.td,{children:(0,n.jsx)(e.code,{children:"to_double"})}),(0,n.jsx)(e.td,{children:"double"}),(0,n.jsx)(e.td,{children:"all"}),(0,n.jsx)(e.td,{})]}),(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.td,{children:(0,n.jsx)(e.code,{children:"to_boolean"})}),(0,n.jsx)(e.td,{children:"boolean"}),(0,n.jsx)(e.td,{children:"all"}),(0,n.jsx)(e.td,{})]}),(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.td,{children:(0,n.jsx)(e.code,{children:"to_string"})}),(0,n.jsx)(e.td,{children:"string"}),(0,n.jsx)(e.td,{children:"all"}),(0,n.jsx)(e.td,{})]}),(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.td,{children:(0,n.jsx)(e.code,{children:"or_else(other: long)"})}),(0,n.jsx)(e.td,{children:"long"}),(0,n.jsx)(e.td,{children:"all"}),(0,n.jsx)(e.td,{})]}),(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.td,{children:(0,n.jsx)(e.code,{children:"abs"})}),(0,n.jsx)(e.td,{children:"long"}),(0,n.jsx)(e.td,{children:"all"}),(0,n.jsx)(e.td,{})]}),(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.td,{children:(0,n.jsx)(e.code,{children:"ceil"})}),(0,n.jsx)(e.td,{children:"long"}),(0,n.jsx)(e.td,{children:"all"}),(0,n.jsx)(e.td,{})]}),(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.td,{children:(0,n.jsx)(e.code,{children:"floor"})}),(0,n.jsx)(e.td,{children:"long"}),(0,n.jsx)(e.td,{children:"all"}),(0,n.jsx)(e.td,{})]}),(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.td,{children:(0,n.jsx)(e.code,{children:"mod(divisor: long)"})}),(0,n.jsx)(e.td,{children:"long"}),(0,n.jsx)(e.td,{children:"all"}),(0,n.jsx)(e.td,{})]}),(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.td,{children:(0,n.jsx)(e.code,{children:"from_unixtime"})}),(0,n.jsx)(e.td,{children:"timestamp"}),(0,n.jsx)(e.td,{children:"duckdb, trino, hive, snowflake, bigquery"}),(0,n.jsx)(e.td,{children:"Interpret this value as a unix epoch second (in UTC)"})]}),(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.td,{children:(0,n.jsx)(e.code,{children:"between(l: long, r: long)"})}),(0,n.jsx)(e.td,{children:"boolean"}),(0,n.jsx)(e.td,{children:"all"}),(0,n.jsx)(e.td,{})]}),(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.td,{children:(0,n.jsx)(e.code,{children:"within(duration: string)"})}),(0,n.jsx)(e.td,{children:"boolean"}),(0,n.jsx)(e.td,{children:"td_trino"}),(0,n.jsx)(e.td,{})]}),(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.td,{children:(0,n.jsx)(e.code,{children:"td_time_string(format: string)"})}),(0,n.jsx)(e.td,{children:"string"}),(0,n.jsx)(e.td,{children:"td_trino, td_hive"}),(0,n.jsx)(e.td,{})]}),(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.td,{children:(0,n.jsx)(e.code,{children:"td_interval(duration: string)"})}),(0,n.jsx)(e.td,{children:"boolean"}),(0,n.jsx)(e.td,{children:"td_hive"}),(0,n.jsx)(e.td,{})]})]})]}),"\n",(0,n.jsx)(e.h2,{id:"float-values",children:"Float Values"}),"\n",(0,n.jsxs)(e.table,{children:[(0,n.jsx)(e.thead,{children:(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.th,{children:"Function"}),(0,n.jsx)(e.th,{children:"Returns"}),(0,n.jsx)(e.th,{children:"Engines"}),(0,n.jsx)(e.th,{children:"Description"})]})}),(0,n.jsxs)(e.tbody,{children:[(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.td,{children:(0,n.jsx)(e.code,{children:"to_int"})}),(0,n.jsx)(e.td,{children:"int"}),(0,n.jsx)(e.td,{children:"all"}),(0,n.jsx)(e.td,{})]}),(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.td,{children:(0,n.jsx)(e.code,{children:"to_long"})}),(0,n.jsx)(e.td,{children:"long"}),(0,n.jsx)(e.td,{children:"all"}),(0,n.jsx)(e.td,{})]}),(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.td,{children:(0,n.jsx)(e.code,{children:"to_float"})}),(0,n.jsx)(e.td,{children:"float"}),(0,n.jsx)(e.td,{children:"all"}),(0,n.jsx)(e.td,{})]}),(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.td,{children:(0,n.jsx)(e.code,{children:"to_double"})}),(0,n.jsx)(e.td,{children:"double"}),(0,n.jsx)(e.td,{children:"all"}),(0,n.jsx)(e.td,{})]}),(0,n.jsxs)(e.tr,{ch
1ildren:[(0,n.jsx)(e.td,{children:(0,n.jsx)(e.code,{children:"to_boolean"})}),(0,n.jsx)(e.td,{children:"boolean"}),(0,n.jsx)(e.td,{children:"all"}),(0,n.jsx)(e.td,{})]}),(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.td,{children:(0,n.jsx)(e.code,{children:"to_string"})}),(0,n.jsx)(e.td,{children:"string"}),(0,n.jsx)(e.td,{children:"all"}),(0,n.jsx)(e.td,{})]}),(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.td,{children:(0,n.jsx)(e.code,{children:"or_else(other: float)"})}),(0,n.jsx)(e.td,{children:"float"}),(0,n.jsx)(e.td,{children:"all"}),(0,n.jsx)(e.td,{})]}),(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.td,{children:(0,n.jsx)(e.code,{children:"abs"})}),(0,n.jsx)(e.td,{children:"float"}),(0,n.jsx)(e.td,{children:"all"}),(0,n.jsx)(e.td,{})]}),(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.td,{children:(0,n.jsx)(e.code,{children:"ceil"})}),(0,n.jsx)(e.td,{children:"float"}),(0,n.jsx)(e.td,{children:"all"}),(0,n.jsx)(e.td,{})]}),(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.td,{children:(0,n.jsx)(e.code,{children:"floor"})}),(0,n.jsx)(e.td,{children:"float"}),(0,n.jsx)(e.td,{children:"all"}),(0,n.jsx)(e.td,{})]}),(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.td,{children:(0,n.jsx)(e.code,{children:"is_nan"})}),(0,n.jsx)(e.td,{children:"boolean"}),(0,n.jsx)(e.td,{children:"duckdb, trino, bigquery"}),(0,n.jsx)(e.td,{})]}),(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.td,{children:(0,n.jsx)(e.code,{children:"is_finite"})}),(0,n.jsx)(e.td,{children:"boolean"}),(0,n.jsx)(e.td,{children:"duckdb, trino, bigquery"}),(0,n.jsx)(e.td,{})]}),(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.td,{children:(0,n.jsx)(e.code,{children:"is_infinite"})}),(0,n.jsx)(e.td,{children:"boolean"}),(0,n.jsx)(e.td,{children:"duckdb, trino, bigquery"}),(0,n.jsx)(e.td,{})]}),(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.td,{children:(0,n.jsx)(e.code,{children:"between(l: float, r: float)"})}),(0,n.jsx)(e.td,{children:"boolean"}),(0,n.jsx)(e.td,{children:"all"}),(0,n.jsx)(e.td,{})]})]})]}),"\n",(0,n.jsx)(e.h2,{id:"real-values",children:"Real Values"}),"\n",(0,n.jsxs)(e.table,{children:[(0,n.jsx)(e.thead,{children:(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.th,{children:"Function"}),(0,n.jsx)(e.th,{children:"Returns"}),(0,n.jsx)(e.th,{children:"Engines"}),(0,n.jsx)(e.th,{children:"Description"})]})}),(0,n.jsxs)(e.tbody,{children:[(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.td,{children:(0,n.jsx)(e.code,{children:"to_int"})}),(0,n.jsx)(e.td,{children:"int"}),(0,n.jsx)(e.td,{children:"all"}),(0,n.jsx)(e.td,{})]}),(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.td,{children:(0,n.jsx)(e.code,{children:"to_long"})}),(0,n.jsx)(e.td,{children:"long"}),(0,n.jsx)(e.td,{children:"all"}),(0,n.jsx)(e.td,{})]}),(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.td,{children:(0,n.jsx)(e.code,{children:"to_float"})}),(0,n.jsx)(e.td,{children:"float"}),(0,n.jsx)(e.td,{children:"all"}),(0,n.jsx)(e.td,{})]}),(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.td,{children:(0,n.jsx)(e.code,{children:"to_double"})}),(0,n.jsx)(e.td,{children:"double"}),(0,n.jsx)(e.td,{children:"all"}),(0,n.jsx)(e.td,{})]}),(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.td,{children:(0,n.jsx)(e.code,{children:"to_boolean"})}),(0,n.jsx)(e.td,{children:"boolean"}),(0,n.jsx)(e.td,{children:"all"}),(0,n.jsx)(e.td,{})]}),(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.td,{children:(0,n.jsx)(e.code,{children:"to_string"})}),(0,n.jsx)(e.td,{children:"string"}),(0,n.jsx)(e.td,{children:"all"}),(0,n.jsx)(e.td,{})]}),(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.td,{children:(0,n.jsx)(e.code,{children:"or_else(other: real)"})}),(0,n.jsx)(e.td,{children:"real"}),(0,n.jsx)(e.td,{children:"all"}),(0,n.jsx)(e.td,{})]}),(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.td,{children:(0,n.jsx)(e.code,{children:"abs"})}),(0,n.jsx)(e.td,{children:"real"}),(0,n.jsx)(e.td,{children:"all"}),(0,n.jsx)(e.td,{})]}),(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.td,{children:(0,n.jsx)(e.code,{children:"ceil"})}),(0,n.jsx)(e.td,{children:"real"}),(0,n.jsx)(e.td,{children:"all"}),(0,n.jsx)(e.td,{})]}),(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.td,{children:(0,n.jsx)(e.code,{children:"floor"})}),(0,n.jsx)(e.td,{children:"real"}),(0,n.jsx)(e.td,{children:"all"}),(0,n.jsx)(e.td,{})]}),(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.td,{children:(0,n.jsx)(e.code,{children:"between(l: real, r: real)"})}),(0,n.jsx)(e.td,{children:"boolean"}),(0,n.jsx)(e.td,{children:"all"}),(0,n.jsx)(e.td,{})]})]})]}),"\n",(0,n.jsx)(e.h2,{id:"double-values",children:"Double Values"}),"\n",(0,n.jsxs)(e.table,{children:[(0,n.jsx)(e.thead,{children:(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.th,{children:"Function"}),(0,n.jsx)(e.th,{children:"Returns"}),(0,n.jsx)(e.th,{children:"Engines"}),(0,n.jsx)(e.th,{children:"Description"})]})}),(0,n.jsxs)(e.tbody,{children:[(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.td,{children:(0,n.jsx)(e.code,{children:"to_int"})}),(0,n.jsx)(e.td,{children:"int"}),(0,n.jsx)(e.td,{children:"all"}),(0,n.jsx)(e.td,{})]}),(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.td,{children:(0,n.jsx)(e.code,{children:"to_long"})}),(0,n.jsx)(e.td,{children:"long"}),(0,n.jsx)(e.td,{children:"all"}),(0,n.jsx)(e.td,{})]}),(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.td,{children:(0,n.jsx)(e.code,{children:"to_float"})}),(0,n.jsx)(e.td,{children:"float"}),(0,n.jsx)(e.td,{children:"all"}),(0,n.jsx)(e.td,{})]}),(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.td,{children:(0,n.jsx)(e.code,{children:"to_double"})}),(0,n.jsx)(e.td,{children:"double"}),(0,n.jsx)(e.td,{children:"all"}),(0,n.jsx)(e.td,{})]}),(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.td,{children:(0,n.jsx)(e.code,{children:"to_boolean"})}),(0,n.jsx)(e.td,{children:"boolean"}),(0,n.jsx)(e.td,{children:"all"}),(0,n.jsx)(e.td,{})]}),(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.td,{children:(0,n.jsx)(e.code,{children:"to_string"})}),(0,n.jsx)(e.td,{children:"string"}),(0,n.jsx)(e.td,{children:"all"}),(0,n.jsx)(e.td,{})]}),(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.td,{children:(0,n.jsx)(e.code,{children:"or_else(other: double)"})}),(0,n.jsx)(e.td,{children:"double"}),(0,n.jsx)(e.td,{children:"all"}),(0,n.jsx)(e.td,{})]}),(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.td,{children:(0,n.jsx)(e.code,{children:"abs"})}),(0,n.jsx)(e.td,{children:"double"}),(0,n.jsx)(e.td,{children:"all"}),(0,n.jsx)(e.td,{})]}),(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.td,{children:(0,n.jsx)(e.code,{children:"ceil"})}),(0,n.jsx)(e.td,{children:"double"}),(0,n.jsx)(e.td,{children:"all"}),(0,n.jsx)(e.td,{})]}),(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.td,{children:(0,n.jsx)(e.code,{children:"floor"})}),(0,n.jsx)(e.td,{children:"double"}),(0,n.jsx)(e.td,{children:"all"}),(0,n.jsx)(e.td,{})]}),(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.td,{children:(0,n.jsx)(e.code,{children:"degrees"})}),(0,n.jsx)(e.td,{children:"double"}),(0,n.jsx)(e.td,{children:"all"}),(0,n.jsx)(e.td,{})]}),(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.td,{children:(0,n.jsx)(e.code,{children:"radians"})}),(0,n.jsx)(e.td,{children:"double"}),(0,n.jsx)(e.td,{children:"all"}),(0,n.jsx)(e.td,{})]}),(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.td,{children:(0,n.jsx)(e.code,{children:"sin"})}),(0,n.jsx)(e.td,{children:"double"}),(0,n.jsx)(e.td,{children:"all"}),(0,n.jsx)(e.td,{})]}),(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.td,{children:(0,n.jsx)(e.code,{children:"cos"})}),(0,n.jsx)(e.td,{children:"double"}),(0,n.jsx)(e.td,{children:"all"}),(0,n.jsx)(e.td,{})]}),(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.td,{children:(0,n.jsx)(e.code,{children:"tan"})}),(0,n.jsx)(e.td,{children:"double"}),(0,n.jsx)(e.td,{children:"all"}),(0,n.jsx)(e.td,{})]}),(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.td,{children:(0,n.jsx)(e.code,{children:"asin"})}),(0,n.jsx)(e.td,{children:"double"}),(0,n.jsx)(e.td,{children:"all"}),(0,n.jsx)(e.td,{})]}),(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.td,{children:(0,n.jsx)(e.code,{children:"acos"})}),(0,n.jsx)(e.td,{children:"double"}),(0,n.jsx)(e.td,{children:"all"}),(0,n.jsx)(e.td,{})]}),(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.td,{children:(0,n.jsx)(e.code,{children:"atan"})}),(0,n.jsx)(e.td,{children:"double"}),(0,n.jsx)(e.td,{children:"all"}),(0,n.jsx)(e.td,{})]}),(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.td,{children:(0,n.jsx)(e.code,{children:"truncate"})}),(0,n.jsx)(e.td,{children:"double"}),(0,n.jsx)(e.td,{children:"duckdb, trino, hive, snowflake, bigquery"}),(0,n.jsx)(e.td,{children:"Drop the fractional part of this value"})]}),(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.td,{children:(0,n.jsx)(e.code,{children:"is_nan"})}),(0,n.jsx)(e.td,{children:"boolean"}),(0,n.jsx)(e.td,{children:"duckdb, trino, bigquery"}),(0,n.jsx)(e.td,{})]}),(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.td,{children:(0,n.jsx)(e.code,{children:"is_finite"})}),(0,n.jsx)(e.td,{children:"boolean"}),(0,n.jsx)(e.td,{children:"duckdb, trino, bigquery"}),(0,n.jsx)(e.td,{})]}),(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.td,{children:(0,n.jsx)(e.code,{children:"is_infinite"})}),(0,n.jsx)(e.td,{children:"boolean"}),(0,n.jsx)(e.td,{children:"duckdb, trino, bigquery"}),(0,n.jsx)(e.td,{})]}),(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.td,{children:(0,n.jsx)(e.code,{children:"between(l: double, r: double)"})}),(0,n.jsx)(e.td,{children:"boolean"}),(0,n.jsx)(e.td,{children:"all"}),(0,n.jsx)(e.td,{})]})]})]}),"\n",(0,n.jsx)(e.h2,{id:"decimal-values",children:"Decimal Values"}),"\n",(0,n.jsxs)(e.table,{children:[(0,n.jsx)(e.thead,{children:(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.th,{children:"Function"}),(0,n.jsx)(e.th,{children:"Returns"}),(0,n.jsx)(e.th,{children:"Engines"}),(0,n.jsx)(e.th,{children:"Description"})]})}),(0,n.jsxs)(e.tbody,{children:[(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.td,{children:(0,n.jsx)(e.code,{children:"to_int"})}),(0,n.jsx)(e.td,{children:"int"}),(0,n.jsx)(e.td,{children:"all"}),(0,n.jsx)(e.td,{})]}),(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.td,{children:(0,n.jsx)(e.code,{children:"to_long"})}),(0,n.jsx)(e.td,{children:"long"}),(0,n.jsx)(e.td,{children:"all"}),(0,n.jsx)(e.td,{})]}),(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.td,{children:(0,n.jsx)(e.code,{children:"to_float"})}),(0,n.jsx)(e.td,{children:"float"}),(0,n.jsx)(e.td,{children:"all"}),(0,n.jsx)(e.td,{})]}),(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.td,{children:(0,n.jsx)(e.code,{children:"to_double"})}),(0,n.jsx)(e.td,{children:"double"}),(0,n.jsx)(e.td,{children:"all"}),(0,n.jsx)(e.td,{})]}),(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.td,{children:(0,n.jsx)(e.code,{children:"to_boolean"})}),(0,n.jsx)(e.td,{children:"boolean"}),(0,n.jsx)(e.td,{children:"all"}),(0,n.jsx)(e.td,{})]}),(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.td,{children:(0,n.jsx)(e.code,{children:"to_string"})}),(0,n.jsx)(e.td,{children:"string"}),(0,n.jsx)(e.td,{children:"all"}),(0,n.jsx)(e.td,{})]}),(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.td,{children:(0,n.jsx)(e.code,{children:"or_else(other: decimal)"})}),(0,n.jsx)(e.td,{children:"decimal"}),(0,n.jsx)(e.td,{children:"all"}),(0,n.jsx)(e.td,{})]}),(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.td,{children:(0,n.jsx)(e.code,{children:"abs"})}),(0,n.jsx)(e.td,{children:"decimal"}),(0,n.jsx)(e.td,{children:"all"}),(0,n.jsx)(e.td,{})]}),(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.td,{children:(0,n.jsx)(e.code,{children:"ceil"})}),(0,n.jsx)(e.td,{children:"decimal"}),(0,n.jsx)(e.td,{children:"all"}),(0,n.jsx)(e.td,{})]}),(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.td,{children:(0,n.jsx)(e.code,{children:"floor"})}),(0,n.jsx)(e.td,{children:"decimal"}),(0,n.jsx)(e.td,{children:"all"}),(0,n.jsx)(e.td,{})]}),(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.td,{children:(0,n.jsx)(e.code,{children:"mod(divisor: decimal)"})}),(0,n.jsx)(e.td,{children:"decimal"}),(0,n.jsx)(e.td,{children:"all"}),(0,n.jsx)(e.td,{})]}),(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.td,{children:(0,n.jsx)(e.code,{children:"truncate"})}),(0,n.jsx)(e.td,{children:"decimal"}),(0,n.jsx)(e.td,{children:"duckdb, trino, hive, snowflake, bigquery"}),(0,n.jsx)(e.td,{children:"Drop the fractional part of this value"})]}),(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.td,{children:(0,n.jsx)(e.code,{children:"between(l: decimal, r: decimal)"})}),(0,n.jsx)(e.td,{children:"boolean"}),(0,n.jsx)(e.td,{children:"all"}),(0,n.jsx)(e.td,{})]})]})]}),"\n",(0,n.jsx)(e.h2,{id:"boolean-values",children:"Boolean Values"}),"\n",(0,n.jsxs)(e.table,{children:[(0,n.jsx)(e.thead,{children:(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.th,{children:"Function"}),(0,n.jsx)(e.th,{children:"Returns"}),(0,n.jsx)(e.th,{children:"Engines"}),(0,n.jsx)(e.th,{children:"Description"})]})}),(0,n.jsxs)(e.tbody,{children:[(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.td,{children:(0,n.jsx)(e.code,{children:"to_int"})}),(0,n.jsx)(e.td,{children:"int"}),(0,n.jsx)(e.td,{children:"all"}),(0,n.jsx)(e.td,{})]}),(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.td,{children:(0,n.jsx)(e.code,{children:"to_long"})}),(0,n.jsx)(e.td,{children:"long"}),(0,n.jsx)(e.td,{children:"all"}),(0,n.jsx)(e.td,{})]}),(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.td,{children:(0,n.jsx)(e.code,{children:"to_string"})}),(0,n.jsx)(e.td,{children:"string"}),(0,n.jsx)(e.td,{children:"all"}),(0,n.jsx)(e.td,{})]}),(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.td,{children:(0,n.jsx)(e.code,{children:"or_else(other: boolean)"})}),(0,n.jsx)(e.td,{children:"boolean"}),(0,n.jsx)(e.td,{children:"all"}),(0,n.jsx)(e.td,{children:"if the value is null, return the given default value"})]})]})]}),"\n",(0,n.jsx)(e.h2,{id:"string-values",children:"String Values"}),"\n",(0,n.jsxs)(e.table,{children:[(0,n.jsx)(e.thead,{children:(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.th,{children:"Function"}),(0,n.jsx)(e.th,{children:"Returns"}),(0,n.jsx)(e.th,{children:"Engines"}),(0,n.jsx)(e.th,{children:"Description"})]})}),(0,n.jsxs)(e.tbody,{children:[(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.td,{children:(0,n.jsx)(e.code,{children:"to_int"})}),(0,n.jsx)(e.td,{children:"int"}),(0,n.jsx)(e.td,{children:"all"}),(0,n.jsx)(e.td,{})]}),(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.td,{children:(0,n.jsx)(e.code,{children:"to_long"})}),(0,n.jsx)(e.td,{children:"long"}),(0,n.jsx)(e.td,{children:"all"}),(0,n.jsx)(e.td,{})]}),(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.td,{children:(0,n.jsx)(e.code,{children:"to_float"})}),(0,n.jsx)(e.td,{children:"float"}),(0,n.jsx)(e.td,{children:"all"}),(0,n.jsx)(e.td,{})]}),(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.td,{children:(0,n.jsx)(e.code,{children:"to_double"})}),(0,n.jsx)(e.td,{children:"double"}),(0,n.jsx)(e.td,{children:"all"}),(0,n.jsx)(e.td,{})]}),(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.td,{children:(0,n.jsx)(e.code,{children:"to_boolean"})}),(0,n.jsx)(e.td,{children:"boolean"}),(0,n.jsx)(e.td,{children:"all"}),(0,n.jsx)(e.td,{})]}),(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.td,{children:(0,n.jsx)(e.code,{children:"to_date"})}),(0,n.jsx)(e.td,{children:"date"}),(0,n.jsx)(e.td,{children:"all"}),(0,n.jsx)(e.td,{})]}),(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.td,{children:(0,n.jsx)(e.code,{children:"to_timestamp"})}),(0,n.jsx)(e.td,{children:"timestamp"}),(0,n.jsx)(e.td,{children:"all"}),(0,n.jsx)(e.td,{})]}),(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.td,{children:(0,n.jsx)(e.code,{children:"or_else(other: string)"})}),(0,n.jsx)(e.td,{children:"string"}),(0,n.jsx)(e.td,{children:"all"}),(0,n.jsx)(e.td,{children:"if the string is null, return the default value"})]}),(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.td,{children:(0,n.jsx)(e.code,{children:"length"})}),(0,n.jsx)(e.td,{children:"int"}),(0,n.jsx)(e.td,{children:"all"}),(0,n.jsx)(e.td,{children:"Number of characters in the string"})]}),(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.td,{children:(0,n.jsx)(e.code,{children:"upper"})}),(0,n.jsx)(e.td,{children:"string"}),(0,n.jsx)(e.td,{children:"all"}),(0,n.jsx)(e.td,{})]}),(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.td,{children:(0,n.jsx)(e.code,{children:"lower"})}),(0,n.jsx)(e.td,{children:"string"}),(0,n.jsx)(e.td,{children:"all"}),(0,n.jsx)(e.td,{})]}),(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.td,{children:(0,n.jsx)(e.code,{children:"trim"})}),(0,n.jsx)(e.td,{children:"string"}),(0,n.jsx)(e.td,{children:"all"}),(0,n.jsx)(e.td,{})]}),(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.td,{children:(0,n.jsx)(e.code,{children:"ltrim"})}),(0,n.jsx)(e.td,{children:"string"}),(0,n.jsx)(e.td,{children:"all"}),(0,n.jsx)(e.td,{})]}),(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.td,{children:(0,n.jsx)(e.code,{children:"rtrim"})}),(0,n.jsx)(e.td,{children:"string"}),(0,n.jsx)(e.td,{children:"all"}),(0,n.jsx)(e.td,{})]}),(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.td,{children:(0,n.jsx)(e.code,{children:"reverse"})}),(0,n.jsx)(e.td,{children:"string"}),(0,n.jsx)(e.td,{children:"all"}),(0,n.jsx)(e.td,{})]}),(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.td,{children:(0,n.jsx
1)(e.code,{children:"concat(other: string)"})}),(0,n.jsx)(e.td,{children:"string"}),(0,n.jsx)(e.td,{children:"all"}),(0,n.jsx)(e.td,{children:"Concatenate the given string after this string"})]}),(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.td,{children:(0,n.jsx)(e.code,{children:"replace(search: string, replacement: string)"})}),(0,n.jsx)(e.td,{children:"string"}),(0,n.jsx)(e.td,{children:"all"}),(0,n.jsx)(e.td,{children:"Replace all occurrences of the search string with the replacement string"})]}),(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.td,{children:(0,n.jsx)(e.code,{children:"lpad(length: int, pad: string)"})}),(0,n.jsx)(e.td,{children:"string"}),(0,n.jsx)(e.td,{children:"all"}),(0,n.jsx)(e.td,{children:"Pad the string to the given length by prepending (lpad) or appending (rpad) the pad string"})]}),(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.td,{children:(0,n.jsx)(e.code,{children:"rpad(length: int, pad: string)"})}),(0,n.jsx)(e.td,{children:"string"}),(0,n.jsx)(e.td,{children:"all"}),(0,n.jsx)(e.td,{})]}),(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.td,{children:(0,n.jsx)(e.code,{children:"strpos(substr: string)"})}),(0,n.jsx)(e.td,{children:"int"}),(0,n.jsx)(e.td,{children:"all"}),(0,n.jsx)(e.td,{children:"1-origin position of the first occurrence of the substring (0 if not found)"})]}),(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.td,{children:(0,n.jsx)(e.code,{children:"like(pattern: string)"})}),(0,n.jsx)(e.td,{children:"boolean"}),(0,n.jsx)(e.td,{children:"all"}),(0,n.jsx)(e.td,{})]}),(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.td,{children:(0,n.jsx)(e.code,{children:"substring(start: int)"})}),(0,n.jsx)(e.td,{children:"string"}),(0,n.jsx)(e.td,{children:"all"}),(0,n.jsx)(e.td,{children:"Substring from the 1-origin start position (to the end, or of the given length)"})]}),(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.td,{children:(0,n.jsx)(e.code,{children:"substring(start: int, length: int)"})}),(0,n.jsx)(e.td,{children:"string"}),(0,n.jsx)(e.td,{children:"all"}),(0,n.jsx)(e.td,{})]}),(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.td,{children:(0,n.jsx)(e.code,{children:"regexp_extract(pattern: string)"})}),(0,n.jsx)(e.td,{children:"string"}),(0,n.jsx)(e.td,{children:"all"}),(0,n.jsx)(e.td,{children:"Extract the first substring matching the regular expression"})]}),(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.td,{children:(0,n.jsx)(e.code,{children:"regexp_extract(pattern: string, group_index: int)"})}),(0,n.jsx)(e.td,{children:"string"}),(0,n.jsx)(e.td,{children:"all"}),(0,n.jsx)(e.td,{})]}),(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.td,{children:(0,n.jsx)(e.code,{children:"starts_with(prefix: string)"})}),(0,n.jsx)(e.td,{children:"boolean"}),(0,n.jsx)(e.td,{children:"all"}),(0,n.jsx)(e.td,{})]}),(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.td,{children:(0,n.jsx)(e.code,{children:"in(v: any*)"})}),(0,n.jsx)(e.td,{children:"boolean"}),(0,n.jsx)(e.td,{children:"all"}),(0,n.jsx)(e.td,{})]}),(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.td,{children:(0,n.jsx)(e.code,{children:"not_in(expr: any*)"})}),(0,n.jsx)(e.td,{children:"boolean"}),(0,n.jsx)(e.td,{children:"all"}),(0,n.jsx)(e.td,{})]}),(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.td,{children:(0,n.jsx)(e.code,{children:"regexp_like(pattern: string)"})}),(0,n.jsx)(e.td,{children:"boolean"}),(0,n.jsx)(e.td,{children:"duckdb, trino, hive, snowflake, bigquery"}),(0,n.jsx)(e.td,{children:"Snowflake's REGEXP_LIKE matches the entire string, so use REGEXP_INSTR for the partial-match semantics of the other engines"})]}),(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.td,{children:(0,n.jsx)(e.code,{children:"regexp_replace(pattern: string, replacement: string)"})}),(0,n.jsx)(e.td,{children:"string"}),(0,n.jsx)(e.td,{children:"duckdb, trino, hive, snowflake, bigquery"}),(0,n.jsx)(e.td,{children:"Replace every substring matching the regular expression with the replacement"})]}),(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.td,{children:(0,n.jsx)(e.code,{children:"contains(substr: string)"})}),(0,n.jsx)(e.td,{children:"boolean"}),(0,n.jsx)(e.td,{children:"duckdb, trino, hive, snowflake, bigquery"}),(0,n.jsx)(e.td,{})]}),(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.td,{children:(0,n.jsx)(e.code,{children:"ends_with(suffix: string)"})}),(0,n.jsx)(e.td,{children:"boolean"}),(0,n.jsx)(e.td,{children:"duckdb, trino, hive, snowflake, bigquery"}),(0,n.jsx)(e.td,{})]}),(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.td,{children:(0,n.jsx)(e.code,{children:"split(separator: string)"})}),(0,n.jsx)(e.td,{children:"array[string]"}),(0,n.jsx)(e.td,{children:"duckdb, trino, hive, snowflake, bigquery"}),(0,n.jsx)(e.td,{children:"Split the string by the separator into an array of str
1ings"})]}),(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.td,{children:(0,n.jsx)(e.code,{children:"md5"})}),(0,n.jsx)(e.td,{children:"string"}),(0,n.jsx)(e.td,{children:"duckdb, trino, hive, snowflake, bigquery"}),(0,n.jsx)(e.td,{children:"Hex-encoded digest strings"})]}),(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.td,{children:(0,n.jsx)(e.code,{children:"sha256"})}),(0,n.jsx)(e.td,{children:"string"}),(0,n.jsx)(e.td,{children:"duckdb, trino, hive, snowflake, bigquery"}),(0,n.jsx)(e.td,{})]}),(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.td,{children:(0,n.jsx)(e.code,{children:"levenshtein(other: string)"})}),(0,n.jsx)(e.td,{children:"int"}),(0,n.jsx)(e.td,{children:"duckdb, trino, hive, snowflake, bigquery"}),(0,n.jsx)(e.td,{children:"Edit distance between two strings"})]}),(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.td,{children:(0,n.jsx)(e.code,{children:"json_extract(path: string)"})}),(0,n.jsx)(e.td,{children:"json"}),(0,n.jsx)(e.td,{children:"duckdb, trino, hive, snowflake, bigquery"}),(0,n.jsx)(e.td,{children:"Extract a JSON value from a string holding JSON text"})]}),(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.td,{children:(0,n.jsx)(e.code,{children:"json_extract_string(path: string)"})}),(0,n.jsx)(e.td,{children:"string"}),(0,n.jsx)(e.td,{children:"duckdb, trino, hive, snowflake, bigquery"}),(0,n.jsx)(e.td,{})]})]})]}),"\n",(0,n.jsx)(e.h2,{id:"date-values",children:"Date Values"}),"\n",(0,n.jsxs)(e.table,{children:[(0,n.jsx)(e.thead,{children:(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.th,{children:"Function"}),(0,n.jsx)(e.th,{children:"Returns"}),(0,n.jsx)(e.th,{children:"Engines"}),(0,n.jsx)(e.th,{children:"Description"})]})}),(0,n.jsxs)(e.tbody,{children:[(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.td,{children:(0,n.jsx)(e.code,{children:"extract(field: string)"})}),(0,n.jsx)(e.td,{children:"int"}),(0,n.jsx)(e.td,{children:"all"}),(0,n.jsx)(e.td,{})]}),(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.td,{children:(0,n.jsx)(e.code,{children:"year"})}),(0,n.jsx)(e.td,{children:"int"}),(0,n.jsx)(e.td,{children:"all"}),(0,n.jsx)(e.td,{})]}),(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.td,{children:(0,n.jsx)(e.code,{children:"month"})}),(0,n.jsx)(e.td,{children:"int"}),(0,n.jsx)(e.td,{children:"all"}),(0,n.jsx)(e.td,{})]}),(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.td,{children:(0,n.jsx)(e.code,{children:"day"})}),(0,n.jsx)(e.td,{children:"int"}),(0,n.jsx)(e.td,{children:"all"}),(0,n.jsx)(e.td,{})]}),(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.td,{children:(0,n.jsx)(e.code,{children:"quarter"})}),(0,n.jsx)(e.td,{children:"int"}),(0,n.jsx)(e.td,{children:"all"}),(0,n.jsx)(e.td,{})]}),(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.td,{children:(0,n.jsx)(e.code,{children:"week"})}),(0,n.jsx)(e.td,{children:"int"}),(0,n.jsx)(e.td,{children:"all"}),(0,n.jsx)(e.td,{})]}),(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.td,{children:(0,n.jsx)(e.code,{children:"or_else(other: date)"})}),(0,n.jsx)(e.td,{children:"date"}),(0,n.jsx)(e.td,{children:"all"}),(0,n.jsx)(e.td,{})]}),(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.td,{children:(0,n.jsx)(e.code,{children:"truncate_to(unit: string)"})}),(0,n.jsx)(e.td,{children:"date"}),(0,n.jsx)(e.td,{children:"all"}),(0,n.jsx)(e.td,{children:"Truncate to the given unit ('year', 'quarter', 'month', 'week', 'day')"})]}),(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.td,{children:(0,n.jsx)(e.code,{children:"diff_days(other: date)"})}),(0,n.jsx)(e.td,{children:"long"}),(0,n.jsx)(e.td,{children:"all"}),(0,n.jsx)(e.td,{children:"Difference between this and the other date, in the given unit"})]}),(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.td,{children:(0,n.jsx)(e.code,{children:"diff_months(other: date)"})}),(0,n.jsx)(e.td,{children:"long"}),(0,n.jsx)(e.td,{children:"all"}),(0,n.jsx)(e.td,{})]}),(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.td,{children:(0,n.jsx)(e.code,{children:"diff_years(other: date)"})}),(0,n.jsx)(e.td,{children:"long"}),(0,n.jsx)(e.td,{children:"all"}),(0,n.jsx)(e.td,{})]}),(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.td,{children:(0,n.jsx)(e.code,{children:"between(l: date, r: date)"})}),(0,n.jsx)(e.td,{children:"boolean"}),(0,n.jsx)(e.td,{children:"all"}),(0,n.jsx)(e.td,{})]}),(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.td,{children:(0,n.jsx)(e.code,{children:"day_of_week"})}),(0,n.jsx)(e.td,{children:"int"}),(0,n.jsx)(e.td,{children:"duckdb, trino, hive, snowflake, bigquery"}),(0,n.jsx)(e.td,{children:"ISO day of week (1 = Monday, 7 = Sunday) and day of year"})]}),(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.td,{children:(0,n.jsx)(e.code,{children:"day_of_year"})}),(0,n.jsx)(e.td,{children:"int"}),(0,n.jsx)(e.td,{children:"duckdb, trino, hive, snowflake, bigquery"}),(0,n.jsx)(e.td,{})]}),(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.td,{children:(0,n.jsx)(e.code,{children:"add_days(n: int)"})}),(0,n.jsx)(e.td,{children:"date"}),(0,n.jsx)(e.td,{children:"duckdb, trino, hive, snowflake, bigquery"}),(0,n.jsx)(e.td,{})]}),(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.td,{children:(0,n.jsx)(e.code,{children:"add_months(n: int)"})}),(0,n.jsx)(e.td,{children:"date"}),(0,n.jsx)(e.td,{children:"duckdb, trino, hive, snowflake, bigquery"}),(0,n.jsx)(e.td,{})]}),(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.td,{children:(0,n.jsx)(e.code,{children:"add_years(n: int)"})}),(0,n.jsx)(e.td,{children:"date"}),(0,n.jsx)(e.td,{children:"duckdb, trino, hive, snowflake, bigquery"}),(0,n.jsx)(e.td,{})]}),(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.td,{children:(0,n.jsx)(e.code,{children:"format(pattern: string)"})}),(0,n.jsx)(e.td,{children:"string"}),(0,n.jsx)(e.td,{children:"duckdb, trino, hive, snowflake, bigquery"}),(0,n.jsx)(e.td,{children:"Format the date with a strftime-style pattern (e.g. '%Y-%m-%d')"})]}),(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.td,{children:(0,n.jsx)(e.code,{children:"last_day"})}),(0,n.jsx)(e.td,{children:"date"}),(0,n.jsx)(e.td,{children:"duckdb, trino, hive, snowflake, bigquery"}),(0,n.jsx)(e.td,{children:"The last day of the month of this date"})]})]})]}),"\n",(0,n.jsx)(e.h2,{id:"timestamp-values",children:"Timestamp Values"}),"\n",(0,n.jsxs)(e.table,{children:[(0,n.jsx)(e.thead,{children:(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.th,{children:"Function"}),(0,n.jsx)(e.th,{children:"Returns"}),(0,n.jsx)(e.th,{children:"Engines"}),(0,n.jsx)(e.th,{children:"Description"})]})}),(0,n.jsxs)(e.tbody,{children:[(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.td,{children:(0,n.jsx)(e.code,{children:"extract(field: string)"})}),(0,n.jsx)(e.td,{children:"int"}),(0,n.jsx)(e.td,{children:"all"}),(0,n.jsx)(e.td,{})]}),(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.td,{children:(0,n.jsx)(e.code,{children:"year"})}),(0,n.jsx)(e.td,{children:"int"}),(0,n.jsx)(e.td,{children:"all"}),(0,n.jsx)(e.td,{})]}),(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.td,{children:(0,n.jsx)(e.code,{children:"month"})}),(0,n.jsx)(e.td,{children:"int"}),(0,n.jsx)(e.td,{children:"all"}),(0,n.jsx)(e.td,{})]}),(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.td,{children:(0,n.jsx)(e.code,{children:"day"})}),(0,n.jsx)(e.td,{children:"int"}),(0,n.jsx)(e.td,{children:"all"}),(0,n.jsx)(e.td,{})]}),(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.td,{children:(0,n.jsx)(e.code,{children:"hour"})}),(0,n.jsx)(e.td,{children:"int"}),(0,n.jsx)(e.td,{children:"all"}),(0,n.jsx)(e.td,{})]}),(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.td,{children:(0,n.jsx)(e.code,{children:"minute"})}),(0,n.jsx)(e.td,{children:"int"}),(0,n.jsx)(e.td,{children:"all"}),(0,n.jsx)(e.td,{})]}),(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.td,{children:(0,n.jsx)(e.code,{children:"second"})}),(0,n.jsx)(e.td,{children:"int"}),(0,n.jsx)(e.td,{children:"all"}),(0,n.jsx)(e.td,{})]}),(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.td,{children:(0,n.jsx)(e.code,{children:"quarter"})}),(0,n.jsx)(e.td,{children:"int"}),(0,n.jsx)(e.td,{children:"all"}),(0,n.jsx)(e.td,{})]}),(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.td,{children:(0,n.jsx)(e.code,{children:"week"})}),(0,n.jsx)(e.td,{children:"int"}),(0,n.jsx)(e.td,{children:"all"}),(0,n.jsx)(e.td,{})]}),(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.td,{children:(0,n.jsx)(e.code,{children:"or_else(other: timestamp)"})}),(0,n.jsx)(e.td,{children:"timestamp"}),(0,n.jsx)(e.td,{children:"all"}),(0,n.jsx)(e.td,{})]}),(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.td,{children:(0,n.jsx)(e.code,{children:"to_date"})}),(0,n.jsx)(e.td,{children:"date"}),(0,n.jsx)(e.td,{children:"all"}),(0,n.jsx)(e.td,{})]}),(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.td,{children:(0,n.jsx)(e.code,{children:"truncate_to(unit: string)"})}),(0,n.jsx)(e.td,{children:"timestamp"}),(0,n.jsx)(e.td,{children:"all"}),(0,n.jsx)(e.td,{children:"Truncate to the given unit ('year', 'month', 'day', 'hour', 'minute', 'second')"})]}),(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.td,{children:(0,n.jsx)(e.code,{children:"diff_seconds(other: timestamp)"})}),(0,n.jsx)(e.td,{children:"long"}),(0,n.jsx)(e.td,{children:"all"}),(0,n.jsx)(e.td,{children:"Difference between this and the other timestamp, in the given unit"})]}),(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.td,{children:(0,n.jsx)(e.code,{children:"diff_minutes(other: timestamp)"})}),(0,n.jsx)(e.td,{children:"long"}),(0,n.jsx)(e.td,{children:"all"}),(0,n.jsx)(e.td,{})]}),(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.td,{children:(0,n.jsx)(e.code,{children:"diff_hours(other: timestamp)"})}),(0,n.jsx)(e.td,{children:"long"}),(0,n.jsx)(e.td,{children:"all"}),(0,n.jsx)(e.td,{})]}),(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.td,{children:(0,n.jsx)(e.code,{children:"diff_days(other: timestamp)"})}),(0,n.jsx)(e.td,{children:"long"}),(0,n.jsx)(e.td,{children:"all"}),(0,n.jsx)(e.td,{})]}),(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.td,{children:(0,n.jsx)(e.code,{children:"between(l: timestamp, r: timestamp)"})}),(0,n.jsx)(e.td,{children:"boolean"}),(0,n.jsx)(e.td,{children:"all"}),(0,n.jsx)(e.td,{})]}),(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.td,{children:(0,n.jsx)(e.code,{children:"day_of_week"})}),(0,n.jsx)(e.td,{children:"int"}),(0,n.jsx)(e.td,{children:"duckdb, trino, hive, snowflake, bigquery"}),(0,n.jsx)(e.td,{children:"ISO day of week (1 = Monday, 7 = Sunday) and day of year"})]}),(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.td,{children:(0,n.jsx)(e.code,{children:"day_of_year"})}),(0,n.jsx)(e.td,{children:"int"}),(0,n.jsx)(e.td,{children:"duckdb, trino, hive, snowflake, bigquery"}),(0,n.jsx)(e.td,{})]}),(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.td,{children:(0,n.jsx)(e.code,{children:"add_seconds(n: int)"})}),(0,n.jsx)(e.td,{children:"timestamp"}),(0,n.jsx)(e.td,{children:"duckdb, trino, hive, snowflake, bigquery"}),(0,n.jsx)(e.td,{children:"Timestamp arithmetic via unix epoch seconds (Hive has no timestamp interval functions)"})]}),(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.td,{children:(0,n.jsx)(e.code,{children:"add_minutes(n: int)"})}),(0,n.jsx)(e.td,{children:"timestamp"}),(0,n.jsx)(e.td,{children:"duckdb, trino, hive, snowflake, bigquery"}),(0,n.jsx)(e.td,{})]}),(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.td,{children:(0,n.jsx)(e.code,{children:"add_hours(n: int)"})}),(0,n.jsx)(e.td,{children:"timestamp"}),(0,n.jsx)(e.td,{children:"duckdb, trino, hive, snowflake, bigquery"}),(0,n.jsx)(e.td,{})]}),(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.td,{children:(0,n.jsx)(e.code,{children:"add_days(n: int)"})}),(0,n.jsx)(e.td,{children:"timestamp"}),(0,n.jsx)(e.td,{children:"duckdb, trino, hive, snowflake, bigquery"}),(0,n.jsx)(e.td,{})]}),(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.td,{children:(0,n.jsx)(e.code,{children:"add_months(n: int)"})}),(0,n.jsx)(e.td,{children:"timestamp"}),(0,n.jsx)(e.td,{children:"duckdb, trino, snowflake"}),(0,n.jsx)(e.td,{})]}),(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.td,{children:(0,n.jsx)(e.code,{children:"add_years(n: int)"})}),(0,n.jsx)(e.td,{children:"timestamp"}),(0,n.jsx)(e.td,{children:"duckdb, trino, snowflake"}),(0,n.jsx)(e.td,{})]}),(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.td,{children:(0,n.jsx)(e.code,{children:"format(pattern: string)"})}),(0,n.jsx)(e.td,{children:"string"}),(0,n.jsx)(e.td,{children:"duckdb, trino, hive, snowflake, bigquery"}),(0,n.jsx)(e.td,{children:"Format the timestamp with a strftime-style pattern (e.g. '%Y-%m-%d %H:%M:%S')"})]}),(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.td,{children:(0,n.jsx)(e.code,{children:"to_unixtime"})}),(0,n.jsx)(e.td,{children:"long"}),(0,n.jsx)(e.td,{children:"duckdb, trino, hive, snowflake, bigquery"}),(0,n.jsx)(e.td,{children:"Unix epoch seconds of this timestamp"})]}),(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.td,{children:(0,n.jsx)(e.code,{children:"to_string"})}),(0,n.jsx)(e.td,{children:"string"}),(0,n.jsx)(e.td,{children:"duckdb, trino, hive, snowflake, bigquery"}),(0,n.jsxs)(e.td,{children:["Render as 'YYYY-MM-DD HH:MM",":SS","'. Overridden per engine so the rendering is identical"]})]})]})]}),"\n",(0,n.jsx)(e.h2,{id:"json-values",children:"JSON Values"}),"\n",(0,n.jsxs)(e.table,{children:[(0,n.jsx)(e.thead,{children:(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.th,{children:"Function"}),(0,n.jsx)(e.th,{children:"Returns"}),(0,n.jsx)(e.th,{children:"Engines"}),(0,n.jsx)(e.th,{children:"Description"})]})}),(0,n.jsxs)(e.tbody,{children:[(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.td,{children:(0,n.jsx)(e.code,{children:"json_extract(path: string)"})}),(0,n.jsx)(e.td,{children:"json"}),(0,n.jsx)(e.td,{children:"all"}),(0,n.jsx)(e.td,{children:"Extract the JSON value at the JSONPath expression (e.g. '$.store.book')"})]}),(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.td,{children:(0,n.jsx)(e.code,{children:"json_extract_string(path: string)"})}),(0,n.jsx)(e.td,{children:"string"}),(0,n.jsx)(e.td,{children:"duckdb, trino"}),(0,n.jsx)(e.td,{children:"Extract the value at the JSONPath expression as a plain string"})]})]})]}),"\n",(0,n.jsx)(e.h2,{id:"null-values",children:"Null Values"}),"\n",(0,n.jsxs)(e.table,{children:[(0,n.jsx)(e.thead,{children:(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.th,{children:"Function"}),(0,n.jsx)(e.th,{children:"Returns"}),(0,n.jsx)(e.th,{children:"Engines"}),(0,n.jsx)(e.th,{children:"Description"})]})}),(0,n.jsxs)(e.tbody,{children:[(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.td,{children:(0,n.jsx)(e.code,{children:"to_int"})}),(0,n.jsx)(e.td,{children:"int"}),(0,n.jsx)(e.td,{children:"all"}),(0,n.jsx)(e.td,{})]}),(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.td,{children:(0,n.jsx)(e.code,{children:"to_long"})}),(0,n.jsx)(e.td,{children:"long"}),(0,n.jsx)(e.td,{children:"all"}),(0,n.jsx)(e.td,{})]}),(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.td,{children:(0,n.jsx)(e.code,{children:"to_float"})}),(0,n.jsx)(e.td,{children:"float"}),(0,n.jsx)(e.td,{children:"all"}),(0,n.jsx)(e.td,{})]}),(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.td,{children:(0,n.jsx)(e.code,{children:"to_double"})}),(0,n.jsx)(e.td,{children:"double"}),(0,n.jsx)(e.td,{children:"all"}),(0,n.jsx)(e.td,{})]}),(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.td,{children:(0,n.jsx)(e.code,{children:"to_boolean"})}),(0,n.jsx)(e.td,{children:"boolean"}),(0,n.jsx)(e.td,{children:"all"}),(0,n.jsx)(e.td,{})]}),(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.td,{children:(0,n.jsx)(e.code,{children:"to_date"})}),(0,n.jsx)(e.td,{children:"date"}),(0,n.jsx)(e.td,{children:"all"}),(0,n.jsx)(e.td,{})]}),(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.td,{children:(0,n.jsx)(e.code,{children:"to_timestamp"})}),(0,n.jsx)(e.td,{children:"timestamp"}),(0,n.jsx)(e.td,{children:"all"}),(0,n.jsx)(e.td,{})]}),(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.td,{children:(0,n.jsx)(e.code,{children:"to_string"})}),(0,n.jsx)(e.td,{children:"string"}),(0,n.jsx)(e.td,{children:"all"}),(0,n.jsx)(e.td,{})]})]})]}),"\n",(0,n.jsx)(e.h2,{id:"array-values",children:"Array Values"}),"\n",(0,n.jsxs)(e.p,{children:["A column reference after ",(0,n.jsx)(e.code,{children:"group by"})," also has an array type, so aggregation functions apply to it with the same syntax."]}),"\n",(0,n.jsxs)(e.table,{children:[(0,n.jsx)(e.thead,{children:(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.th,{children:"Function"}),(0,n.jsx)(e.th,{children:"Returns"}),(0,n.jsx)(e.th,{children:"Engines"}),(0,n.jsx)(e.th,{children:"Description"})]})}),(0,n.jsxs)(e.tbody,{children:[(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.td,{children:(0,n.jsx)(e.code,{children:"length"})}),(0,n.jsx)(e.td,{children:"int"}),(0,n.jsx)(e.td,{children:"duckdb, trino, hive, snowflake, bigquery"}),(0,n.jsx)(e.td,{})]}),(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.td,{children:(0,n.jsx)(e.code,{children:"size"})}),(0,n.jsx)(e.td,{children:"int"}),(0,n.jsx)(e.td,{children:"duckdb, trino, hive, snowflake, bigquery"}),(0,n.jsx)(e.td,{})]}),(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.td,{children:(0,n.jsx)(e.code,{children:"get(index: int)"})}),(0,n.jsx)(e.td
1,{children:"A"}),(0,n.jsx)(e.td,{children:"all"}),(0,n.jsx)(e.td,{})]}),(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.td,{children:(0,n.jsx)(e.code,{children:"count"})}),(0,n.jsx)(e.td,{children:"int"}),(0,n.jsx)(e.td,{children:"all"}),(0,n.jsx)(e.td,{})]}),(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.td,{children:(0,n.jsx)(e.code,{children:"count_distinct"})}),(0,n.jsx)(e.td,{children:"int"}),(0,n.jsx)(e.td,{children:"all"}),(0,n.jsx)(e.td,{})]}),(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.td,{children:(0,n.jsx)(e.code,{children:"count_if(cond: boolean)"})}),(0,n.jsx)(e.td,{children:"int"}),(0,n.jsx)(e.td,{children:"all"}),(0,n.jsx)(e.td,{})]}),(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.td,{children:(0,n.jsx)(e.code,{children:"count_approx_distinct"})}),(0,n.jsx)(e.td,{children:"int"}),(0,n.jsx)(e.td,{children:"trino, duckdb, snowflake, bigquery"}),(0,n.jsx)(e.td,{children:"Fast and memory-efficient approximate counting of distinct elements"})]}),(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.td,{children:(0,n.jsx)(e.code,{children:"arbitrary"})}),(0,n.jsx)(e.td,{children:"A"}),(0,n.jsx)(e.td,{children:"all"}),(0,n.jsx)(e.td,{})]}),(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.td,{children:(0,n.jsx)(e.code,{children:"any"})}),(0,n.jsx)(e.td,{children:"A"}),(0,n.jsx)(e.td,{children:"all"}),(0,n.jsx)(e.td,{})]}),(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.td,{children:(0,n.jsx)(e.code,{children:"min"})}),(0,n.jsx)(e.td,{children:"A"}),(0,n.jsx)(e.td,{children:"all"}),(0,n.jsx)(e.td,{})]}),(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.td,{children:(0,n.jsx)(e.code,{children:"max"})}),(0,n.jsx)(e.td,{children:"A"}),(0,n.jsx)(e.td,{children:"all"}),(0,n.jsx)(e.td,{})]}),(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.td,{children:(0,n.jsx)(e.code,{children:"min_by(expr: sql)"})}),(0,n.jsx)(e.td,{children:"A"}),(0,n.jsx)(e.td,{children:"all"}),(0,n.jsx)(e.td,{})]}),(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.td,{children:(0,n.jsx)(e.code,{children:"max_by(expr: sql)"})}),(0,n.jsx)(e.td,{children:"A"}),(0,n.jsx)(e.td,{children:"all"}),(0,n.jsx)(e.td,{})]}),(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.td,{children:(0,n.jsx)(e.code,{children:"to_array"})}),(0,n.jsx)(e.td,{children:"array[A]"}),(0,n.jsx)(e.td,{children:"all"}),(0,n.jsx)(e.td,{})]}),(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.td,{children:(0,n.jsx)(e.code,{children:"bool_and"})}),(0,n.jsx)(e.td,{children:"boolean"}),(0,n.jsx)(e.td,{children:"all"}),(0,n.jsx)(e.td,{children:"Aggregate boolean values of a grouped column"})]}),(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.td,{children:(0,n.jsx)(e.code,{children:"bool_or"})}),(0,n.jsx)(e.td,{children:"boolean"}),(0,n.jsx)(e.td,{children:"all"}),(0,n.jsx)(e.td,{})]}),(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.td,{children:(0,n.jsx)(e.code,{children:"string_agg(separator: string)"})}),(0,n.jsx)(e.td,{children:"string"}),(0,n.jsx)(e.td,{children:"duckdb, trino, hive, snowflake, bigquery"}),(0,n.jsx)(e.td,{children:"Concatenate grouped string values with the separator"})]}),(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.td,{children:(0,n.jsx)(e.code,{children:"exclude(arr: sql)"})}),(0,n.jsx)(e.td,{children:"array[A]"}),(0,n.jsx)(e.td,{children:"duckdb, trino"}),(0,n.jsx)(e.td,{})]}),(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.td,{children:(0,n.jsx)(e.code,{children:"exists"})}),(0,n.jsx)(e.td,{children:"boolean"}),(0,n.jsx)(e.td,{children:"all"}),(0,n.jsx)(e.td,{})]}),(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.td,{children:(0,n.jsx)(e.code,{children:"not_exists"})}),(0,n.jsx)(e.td,{children:"boolean"}),(0,n.jsx)(e.td,{children:"all"}),(0,n.jsx)(e.td,{})]}),(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.td,{children:(0,n.jsx)(e.code,{children:"contains(elem: A)"})}),(0,n.jsx)(e.td,{children:"boolean"}),(0,n.jsx)(e.td,{children:"all"}),(0,n.jsx)(e.td,{children:"True if the array contains the given element"})]}),(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.td,{children:(0,n.jsx)(e.code,{children:"mk_string"})}),(0,n.jsx)(e.td,{children:"string"}),(0,n.jsx)(e.td,{children:"duckdb, trino, hive, snowflake, bigquery"}),(0,n.jsx)(e.td,{children:"Concatenate the array elements into a string without a separator"})]}),(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.td,{children:(0,n.jsx)(e.code,{children:"mk_string(separator: string)"})}),(0,n.jsx)(e.td,{children:"string"}),(0,n.jsx)(e.td,{children:"duckdb, trino, hive, snowflake, bigquery"}),(0,n.jsx)(e.td,{children:"Concatenate the array elements into a string with the separator"})]}),(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.td,{children:(0,n.jsx)(e.code,{children:"distinct"})}),(0,n.jsx)(e.td,{children:"array[A]"}),(0,n.jsx)(e.td,{children:"all"}),(0,n.jsx)(e.td,{children:"Remove duplicate elements"})]}),(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.td,{children:(0,n.jsx)(e.code,{children:"flatten"})}),(0,n.jsx)(e.td,{children:"array[A]"}),(0,n.jsx)(e.td,{children:"all"}),(0,n.jsx)(e.td,{children:"Flatten an array of arrays into a single array"})]}),(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.td,{children:(0,n.jsx)(e.code,{children:"sort"})}),(0,n.jsx)(e.td,{children:"array[A]"}),(0,n.jsx)(e.td,{children:"duckdb, trino, hive, snowflake"}),(0,n.jsx)(e.td,{})]}),(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.td,{children:(0,n.jsx)(e.code,{children:"reverse"})}),(0,n.jsx)(e.td,{children:"array[A]"}),(0,n.jsx)(e.td,{children:"duckdb, trino, snowflake, bigquery"}),(0,n.jsx)(e.td,{})]}),(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.td,{children:(0,n.jsx)(e.code,{children:"index_of(elem: A)"})}),(0,n.jsx)(e.td,{children:"int"}),(0,n.jsx)(e.td,{children:"duckdb, trino, snowflake"}),(0,n.jsx)(e.td,{children:"1-origin position of the first occurrence of the element (0 if not found)"})]}),(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.td,{children:(0,n.jsx)(e.code,{children:"concat(other: any)"})}),(0,n.jsx)(e.td,{children:"array[A]"}),(0,n.jsx)(e.td,{children:"duckdb, trino, snowflake, bigquery"}),(0,n.jsx)(e.td,{})]}),(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.td,{children:(0,n.jsx)(e.code,{children:"lag"})}),(0,n.jsx)(e.td,{children:"A"}),(0,n.jsx)(e.td,{children:"all"}),(0,n.jsx)(e.td,{children:"Value of the column at a preceding row of the window"})]}),(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.td,{children:(0,n.jsx)(e.code,{children:"lag(offset: int)"})}),(0,n.jsx)(e.td,{children:"A"}),(0,n.jsx)(e.td,{children:"all"}),(0,n.jsx)(e.td,{})]}),(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.td,{children:(0,n.jsx)(e.code,{children:"lag(offset: int, default: any)"})}),(0,n.jsx)(e.td,{children:"A"}),(0,n.jsx)(e.td,{children:"all"}),(0,n.jsx)(e.td,{})]}),(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.td,{children:(0,n.jsx)(e.code,{children:"lead"})}),(0,n.jsx)(e.td,{children:"A"}),(0,n.jsx)(e.td,{children:"all"}),(0,n.jsx)(e.td,{children:"Value of the column at a following row of the window"})]}),(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.td,{children:(0,n.jsx)(e.code,{children:"lead(offset: int)"})}),(0,n.jsx)(e.td,{children:"A"}),(0,n.jsx)(e.td,{children:"all"}),(0,n.jsx)(e.td,{})]}),(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.td,{children:(0,n.jsx)(e.code,{children:"lead(offset: int, default: any)"})}),(0,n.jsx)(e.td,{children:"A"}),(0,n.jsx)(e.td,{children:"all"}),(0,n.jsx)(e.td,{})]}),(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.td,{children:(0,n.jsx)(e.code,{children:"first_value"})}),(0,n.jsx)(e.td,{children:"A"}),(0,n.jsx)(e.td,{children:"all"}),(0,n.jsx)(e.td,{children:"First value of the window"})]}),(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.td,{children:(0,n.jsx)(e.code,{children:"last_value"})}),(0,n.jsx)(e.td,{children:"A"}),(0,n.jsx)(e.td,{children:"all"}),(0,n.jsx)(e.td,{children:"Last value of the window"})]}),(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.td,{children:(0,n.jsx)(e.code,{children:"nth_value(n: int)"})}),(0,n.jsx)(e.td,{children:"A"}),(0,n.jsx)(e.td,{children:"all"}),(0,n.jsx)(e.td,{children:"Value at the n-th row (1-origin) of the window"})]}),(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.td,{children:(0,n.jsx)(e.code,{children:"sum"})}),(0,n.jsx)(e.td,{children:"A"}),(0,n.jsx)(e.td,{children:"all"}),(0,n.jsx)(e.td,{})]}),(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.td,{children:(0,n.jsx)(e.code,{children:"avg"})}),(0,n.jsx)(e.td,{children:"A"}),(0,n.jsx)(e.td,{children:"all"}),(0,n.jsx)(e.td,{})]}),(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.td,{children:(0,n.jsx)(e.code,{children:"median"})}),(0,n.jsx)(e.td,{children:"A"}),(0,n.jsx)(e.td,{children:"all"}),(0,n.jsx)(e.td,{})]}),(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.td,{children:(0,n.jsx)(e.code,{children:"variance"})}),(0,n.jsx)(e.td,{children:"A"}),(0,n.jsx)(e.td,{children:"all"}),(0,n.jsx)(e.td,{})]}),(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.td,{children:(0,n.jsx)(e.code,{children:"stddev"})}),(0,n.jsx)(e.td,{children:"A"}),(0,n.jsx)(e.td,{children:"all"}),(0,n.jsx)(e.td,{})]}),(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.td,{children:(0,n.jsx)(e.code,{children:"stddev_pop"})}),(0,n.jsx)(e.td,{children:"A"}),(0,n.jsx)(e.td,{children:"all"}),(0,n.jsx)(e.td,{})]}),(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.td,{children:(0,n.jsx)(e.code,{children:"stddev_samp"})}),(0,n.jsx)(e.td,{children:"A"}),(0,n.jsx)(e.td,{children:"all"}),(0,n.jsx)(e.td,{})]}),(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.td,{children:(0,n.jsx)(e.code,{children:"var_pop"})}),(0,n.jsx)(e.td,{children:"A"}),(0,n.jsx)(e.td,{children:"all"}),(0,n.jsx)(e.td,{})]}),(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.td,{children:(0,n.jsx)(e.code,{children:"var_samp"})}),(0,n.jsx)(e.td,{children:"A"}),(0,n.jsx)(e.td,{children:"all"}),(0,n.jsx)(e.td,{})]}),(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.td,{children:(0,n.jsx)(e.code,{children:"approx_quantile(pos: double)"})}),(0,n.jsx)(e.td,{children:"A"}),(0,n.jsx)(e.td,{children:"trino, duckdb, hive, snowflake, bigquery"}),(0,n.jsx)(e.td,{})]})]})]}),"\n",(0,n.jsx)(e.h2,{id:"map-values",children:"Map Values"}),"\n",(0,n.jsxs)(e.table,{children:[(0,n.jsx)(e.thead,{children:(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.th,{children:"Function"}),(0,n.jsx)(e.th,{children:"Returns"}),(0,n.jsx)(e.th,{children:"Engines"}),(0,n.jsx)(e.th,{children:"Description"})]})}),(0,n.jsxs)(e.tbody,{children:[(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.td,{children:(0,n.jsx)(e.code,{children:"size"})}),(0,n.jsx)(e.td,{children:"int"}),(0,n.jsx)(e.td,{children:"all"}),(0,n.jsx)(e.td,{children:"Number of entries in the map"})]}),(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.td,{children:(0,n.jsx)(e.code,{children:"keys"})}),(0,n.jsx)(e.td,{children:"array[K]"}),(0,n.jsx)(e.td,{children:"all"}),(0,n.jsx)(e.td,{})]}),(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.td,{children:(0,n.jsx)(e.code,{children:"values"})}),(0,n.jsx)(e.td,{children:"array[V]"}),(0,n.jsx)(e.td,{children:"all"}),(0,n.jsx)(e.td,{})]}),(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.td,{children:(0,n.jsx)(e.code,{children:"contains_key(key: K)"})}),(0,n.jsx)(e.td,{children:"boolean"}),(0,n.jsx)(e.td,{children:"all"}),(0,n.jsx)(e.td,{children:"True if the map contains the given key"})]}),(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.td,{children:(0,n.jsx)(e.code,{children:"get(key: K)"})}),(0,n.jsx)(e.td,{children:"V"}),(0,n.jsx)(e.td,{children:"duckdb, trino, hive, snowflake"}),(0,n.jsx)(e.td,{children:"The value for the given key, or null if the key is absent"})]})]})]}),"\n",(0,n.jsx)(e.h2,{id:"top-level-functions",children:"Top-Level Functions"}),"\n",(0,n.jsxs)(e.p,{children:["Called without a receiver value (window functions require an ",(0,n.jsx)(e.code,{children:"over(...)"})," clause)."]}),"\n",(0,n.jsxs)(e.table,{children:[(0,n.jsx)(e.thead,{children:(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.th,{children:"Function"}),(0,n.jsx)(e.th,{children:"Returns"}),(0,n.jsx)(e.th,{children:"Engines"}),(0,n.jsx)(e.th,{children:"Description"})]})}),(0,n.jsxs)(e.tbody,{children:[(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.td,{children:(0,n.jsx)(e.code,{children:"ulid_string"})}),(0,n.jsx)(e.td,{children:"string"}),(0,n.jsx)(e.td,{children:"all"}),(0,n.jsx)(e.td,{children:"Generate a new ULID"})]}),(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.td,{children:(0,n.jsx)(e.code,{children:"row_number"})}),(0,n.jsx)(e.td,{children:"long"}),(0,n.jsx)(e.td,{children:"all"}),(0,n.jsx)(e.td,{children:"Sequential row number within the window (1, 2, 3, ...)"})]}),(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.td,{children:(0,n.jsx)(e.code,{children:"rank"})}),(0,n.jsx)(e.td,{children:"long"}),(0,n.jsx)(e.td,{children:"all"}),(0,n.jsx)(e.td,{children:"Rank with gaps after ties (1, 1, 3, ...)"})]}),(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.td,{children:(0,n.jsx)(e.code,{children:"dense_rank"})}),(0,n.jsx)(e.td,{children:"long"}),(0,n.jsx)(e.td,{children:"all"}),(0,n.jsx)(e.td,{children:"Rank without gaps after ties (1, 1, 2, ...)"})]}),(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.td,{children:(0,n.jsx)(e.code,{children:"percent_rank"})}),(0,n.jsx)(e.td,{children:"double"}),(0,n.jsx)(e.td,{children:"all"}),(0,n.jsx)(e.td,{children:"Relative rank in [0, 1]: (rank - 1) / (rows - 1)"})]}),(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.td,{children:(0,n.jsx)(e.code,{children:"cume_dist"})}),(0,n.jsx)(e.td,{children:"double"}),(0,n.jsx)(e.td,{children:"all"}),(0,n.jsx)(e.td,{children:"Cumulative distribution in (0, 1]: rows preceding or peer / rows"})]}),(0,n.jsxs)(e.tr,{children:[(0,n.jsx)(e.td,{children:(0,n.jsx)(e.code,{children:"ntile(n: int)"})}),(0,n.jsx)(e.td,{children:"long"}),(0,n.jsx)(e.td,{children:"all"}),(0,n.jsx)(e.td,{children:"Bucket number when the window is divided into n groups"})]})]})]})]})}function j(d={}){const{wrapper:e}={...(0,t.R)(),...d.components};return e?(0,n.jsx)(e,{...d,children:(0,n.jsx)(x,{...d})}):x(d)}},6798(d,e,s){s.d(e,{R:()=>r,x:()=>i});var l=s(3706);const n={},t=l.createContext(n);function r(d){const e=l.useContext(t);return l.useMemo(function(){return"function"==typeof d?d(e):{...e,...d}},[e,d])}function i(d){let e;return e=d.disableParentContext?"function"==typeof d.components?d.components(n):d.components||n:r(d.components),l.createElement(t.Provider,{value:e},d.children)}}}]);
Line numbers count LF bytes from the start of the resource, as the search results do. Vendor segments are library code the classifier recognised; they are stored but not indexed. Bytes are shown as Latin1 characters, one per byte.