You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@datafusion.apache.org by gi...@apache.org on 2026/06/05 08:05:15 UTC
(datafusion) branch asf-site updated: Publish built docs triggered by 2ec0ab50e39970592c8e7d25b330c92c68c3fca8
This is an automated email from the ASF dual-hosted git repository.
github-actions[bot] pushed a commit to branch asf-site
in repository https://gitbox.apache.org/repos/asf/datafusion.git
The following commit(s) were added to refs/heads/asf-site by this push:
new a2107d2af6 Publish built docs triggered by 2ec0ab50e39970592c8e7d25b330c92c68c3fca8
a2107d2af6 is described below
commit a2107d2af62d5d298ed1acd9cceb72f22df4fab6
Author: github-actions[bot] <gi...@users.noreply.github.com>
AuthorDate: Fri Jun 5 08:05:10 2026 +0000
Publish built docs triggered by 2ec0ab50e39970592c8e7d25b330c92c68c3fca8
---
.../library-user-guide/upgrading/54.0.0.md.txt | 38 ++
.../library-user-guide/upgrading/55.0.0.md.txt | 106 +++
.../library-user-guide/working-with-exprs.md.txt | 2 +-
_sources/user-guide/sql/scalar_functions.md.txt | 33 +
library-user-guide/upgrading/54.0.0.html | 33 +
library-user-guide/upgrading/55.0.0.html | 97 +++
library-user-guide/working-with-exprs.html | 2 +-
searchindex.js | 2 +-
user-guide/sql/scalar_functions.html | 723 +++++++++++----------
9 files changed, 693 insertions(+), 343 deletions(-)
diff --git a/_sources/library-user-guide/upgrading/54.0.0.md.txt b/_sources/library-user-guide/upgrading/54.0.0.md.txt
index 8245793ec0..aa90cca10b 100644
--- a/_sources/library-user-guide/upgrading/54.0.0.md.txt
+++ b/_sources/library-user-guide/upgrading/54.0.0.md.txt
@@ -339,6 +339,44 @@ This produces two user-visible changes:
`ScalarSubqueryExpr` expression. Code that walks or transforms `LogicalPlan` /
`ExecutionPlan` trees, as well as `EXPLAIN` output, may need updating.
+### Filter predicate evaluation order may differ from query text
+
+The logical optimizer now reorders filters so that cheap predicates (most binary
+comparisons, `IS NULL`, `Between`, `InList`, etc.) evaluate before expensive
+ones (`LIKE`, regex, scalar function calls, subqueries). For example,
+`WHERE col LIKE '%foo%' AND col2 = 5` may evaluate `col2 = 5` before
+`col LIKE '%foo%'`.
+
+**Evaluation order has never been guaranteed to match the order written in the
+query.** The SQL standard explicitly allows implementations to evaluate operands
+in any order; major engines (PostgreSQL, SQL Server, Oracle, MySQL) document the
+same. Queries should not rely on left-to-right evaluation or short-circuit
+semantics for `AND` or `OR`. Previous versions of DataFusion already reordered
+predicates (e.g., as part of expression simplification or predicate pushdown);
+the new reordering pass just increases the scenarios where the optimizer will
+change predicate evaluation order.
+
+**Fallible-predicate patterns are particularly affected.** For example:
+
+```sql
+WHERE s ~ '^[0-9]+$' AND CAST(s AS INT) > 0
+```
+
+The intent is likely to filter non-numeric strings before the `CAST` runs,
+but this depends on evaluation-order behavior the SQL standard does not
+guaranteed. The new reorder makes this kind of pattern more likely to fail
+at runtime if the optimizer moves the `CAST` ahead of the regex. To force
+conditional evaluation, rewrite using `CASE`, which has standardized
+short-circuit semantics:
+
+```sql
+WHERE CASE WHEN s ~ '^[0-9]+$' THEN CAST(s AS INT) > 0 ELSE false END
+```
+
+Volatile expressions (`random()`, `now()`, etc.) are exempt — their position
+in the conjunct list is preserved so the number of times they evaluate per
+query does not change.
+
### `datafusion-proto`: expression deserialization now takes a `TaskContext`
`Serializeable::from_bytes_with_registry` is renamed to `from_bytes_with_ctx`
diff --git a/_sources/library-user-guide/upgrading/55.0.0.md.txt b/_sources/library-user-guide/upgrading/55.0.0.md.txt
index d3988c33a4..ad50a37cb9 100644
--- a/_sources/library-user-guide/upgrading/55.0.0.md.txt
+++ b/_sources/library-user-guide/upgrading/55.0.0.md.txt
@@ -97,6 +97,112 @@ as a supertrait:
+ pub trait QueryPlanner: Any + Debug
```
+### `DdlStatement::CreateExternalTable` and `CreateFunction` are now boxed
+
+The two largest variants of `datafusion_expr::DdlStatement` are now
+`Box`ed:
+
+```rust,ignore
+// Before
+pub enum DdlStatement {
+ CreateExternalTable(CreateExternalTable),
+ // ...
+ CreateFunction(CreateFunction),
+ // ...
+}
+
+// After
+pub enum DdlStatement {
+ CreateExternalTable(Box<CreateExternalTable>),
+ // ...
+ CreateFunction(Box<CreateFunction>),
+ // ...
+}
+```
+
+`CreateExternalTable` is 312 bytes and `CreateFunction` is 288 bytes, so
+without boxing they forced the entire `LogicalPlan` enum to 320 bytes
+even on SELECT-only query paths that never instantiate them. Boxing
+shrinks `LogicalPlan` from 320 → 176 bytes (−45%), making every
+`mem::take` / `mem::swap` / `Arc<LogicalPlan>` store on the planning
+hot path move a smaller payload.
+
+**Who is affected:**
+
+- Users who construct `DdlStatement::CreateExternalTable(...)` or
+ `DdlStatement::CreateFunction(...)` from an owned struct.
+- Users who pattern-match these variants and destructure the inner
+ struct in the same pattern (e.g.
+ `DdlStatement::CreateExternalTable(CreateExternalTable { name, .. })`).
+- Code that consumes the inner struct out of these variants (e.g. to
+ pass `CreateExternalTable` by value to another function).
+
+**Migration guide:**
+
+When constructing the variants, wrap the inner struct in `Box::new`:
+
+```rust,ignore
+// Before
+let stmt = DdlStatement::CreateFunction(CreateFunction { name, args, .. });
+
+// After
+let stmt = DdlStatement::CreateFunction(Box::new(CreateFunction {
+ name,
+ args,
+ ..
+}));
+```
+
+When pattern-matching, bind the boxed value and either access fields
+through it (Rust auto-derefs the `Box`) or destructure via `.as_ref()`:
+
+```rust,ignore
+// Before
+match ddl {
+ DdlStatement::CreateExternalTable(CreateExternalTable {
+ name, location, ..
+ }) => { /* use name, location */ }
+}
+
+// After — access fields through the box
+match ddl {
+ DdlStatement::CreateExternalTable(ce) => {
+ let name = &ce.name;
+ let location = &ce.location;
+ /* ... */
+ }
+}
+
+// After — destructure the dereferenced struct
+match ddl {
+ DdlStatement::CreateExternalTable(ce) => {
+ let CreateExternalTable { name, location, .. } = ce.as_ref();
+ /* ... */
+ }
+}
+```
+
+When you need an owned `CreateExternalTable` / `CreateFunction` out of
+the variant, dereference the box with `*`:
+
+```rust,ignore
+// Before
+match plan {
+ LogicalPlan::Ddl(DdlStatement::CreateExternalTable(cmd)) => Ok(cmd),
+ _ => { /* ... */ }
+}
+
+// After
+match plan {
+ LogicalPlan::Ddl(DdlStatement::CreateExternalTable(cmd)) => Ok(*cmd),
+ _ => { /* ... */ }
+}
+```
+
+See [PR #22733](https://github.com/apache/datafusion/pull/22733) for
+details, including the per-variant size breakdown and benchmark
+results.
+
### Spark map functions now reject duplicate keys by default
The Spark-compatibility map-construction functions (`map_from_arrays`,
diff --git a/_sources/library-user-guide/working-with-exprs.md.txt b/_sources/library-user-guide/working-with-exprs.md.txt
index 472ab24813..2f15fa9061 100644
--- a/_sources/library-user-guide/working-with-exprs.md.txt
+++ b/_sources/library-user-guide/working-with-exprs.md.txt
@@ -167,7 +167,7 @@ In DataFusion, an `OptimizerRule` is a trait that supports rewriting `Expr`s tha
We'll call our rule `AddOneInliner` and implement the `OptimizerRule` trait. The `OptimizerRule` trait has two methods:
- `name` - returns the name of the rule
-- `try_optimize` - takes a `LogicalPlan` and returns an `Option<LogicalPlan>`. If the rule is able to optimize the plan, it returns `Some(LogicalPlan)` with the optimized plan. If the rule is not able to optimize the plan, it returns `None`.
+- `rewrite` - takes a `LogicalPlan` and `&dyn OptimizerConfig`, and returns a `Result<Transformed<LogicalPlan>>`. If the rule is able to optimize the plan, it returns `Transformed::yes` with the optimized plan. If the rule is not able to optimize the plan, it returns `Transformed::no`.
```rust
use std::sync::Arc;
diff --git a/_sources/user-guide/sql/scalar_functions.md.txt b/_sources/user-guide/sql/scalar_functions.md.txt
index a3e83409b8..d7026eec09 100644
--- a/_sources/user-guide/sql/scalar_functions.md.txt
+++ b/_sources/user-guide/sql/scalar_functions.md.txt
@@ -3276,6 +3276,7 @@ _Alias of [current_date](#current_date)._
- [array_position](#array_position)
- [array_positions](#array_positions)
- [array_prepend](#array_prepend)
+- [array_product](#array_product)
- [array_push_back](#array_push_back)
- [array_push_front](#array_push_front)
- [array_remove](#array_remove)
@@ -3334,6 +3335,7 @@ _Alias of [current_date](#current_date)._
- [list_position](#list_position)
- [list_positions](#list_positions)
- [list_prepend](#list_prepend)
+- [list_product](#list_product)
- [list_push_back](#list_push_back)
- [list_push_front](#list_push_front)
- [list_remove](#list_remove)
@@ -4136,6 +4138,33 @@ array_prepend(element, array)
- array_push_front
- list_push_front
+### `array_product`
+
+Returns the product of the elements in the input numeric array. NULL elements inside the array are skipped (matching SQL aggregate convention). Returns NULL if the input is NULL, every element is NULL, or the array is empty. The result is always returned as `Float64`.
+
+```sql
+array_product(array)
+```
+
+#### Arguments
+
+- **array**: Array expression. Can be a constant, column, or function, and any combination of array operators.
+
+#### Example
+
+```sql
+> select array_product([1.0, 2.0, 3.0]);
++------------------------------------+
+| array_product(List([1.0,2.0,3.0])) |
++------------------------------------+
+| 6.0 |
++------------------------------------+
+```
+
+#### Aliases
+
+- list_product
+
### `array_push_back`
_Alias of [array_append](#array_append)._
@@ -4959,6 +4988,10 @@ _Alias of [array_positions](#array_positions)._
_Alias of [array_prepend](#array_prepend)._
+### `list_product`
+
+_Alias of [array_product](#array_product)._
+
### `list_push_back`
_Alias of [array_append](#array_append)._
diff --git a/library-user-guide/upgrading/54.0.0.html b/library-user-guide/upgrading/54.0.0.html
index 8d570875bc..a3222b0612 100644
--- a/library-user-guide/upgrading/54.0.0.html
+++ b/library-user-guide/upgrading/54.0.0.html
@@ -775,6 +775,38 @@ corresponding physical plan contains a new <code class="docutils literal notrans
<code class="docutils literal notranslate"><span class="pre">ExecutionPlan</span></code> trees, as well as <code class="docutils literal notranslate"><span class="pre">EXPLAIN</span></code> output, may need updating.</p></li>
</ul>
</section>
+<section id="filter-predicate-evaluation-order-may-differ-from-query-text">
+<h3>Filter predicate evaluation order may differ from query text<a class="headerlink" href="#filter-predicate-evaluation-order-may-differ-from-query-text" title="Link to this heading">#</a></h3>
+<p>The logical optimizer now reorders filters so that cheap predicates (most binary
+comparisons, <code class="docutils literal notranslate"><span class="pre">IS</span> <span class="pre">NULL</span></code>, <code class="docutils literal notranslate"><span class="pre">Between</span></code>, <code class="docutils literal notranslate"><span class="pre">InList</span></code>, etc.) evaluate before expensive
+ones (<code class="docutils literal notranslate"><span class="pre">LIKE</span></code>, regex, scalar function calls, subqueries). For example,
+<code class="docutils literal notranslate"><span class="pre">WHERE</span> <span class="pre">col</span> <span class="pre">LIKE</span> <span class="pre">'%foo%'</span> <span class="pre">AND</span> <span class="pre">col2</span> <span class="pre">=</span> <span class="pre">5</span></code> may evaluate <code class="docutils literal notranslate"><span class="pre">col2</span> <span class="pre">=</span> <span class="pre">5</span></code> before
+<code class="docutils literal notranslate"><span class="pre">col</span> <span class="pre">LIKE</span> <span class="pre">'%foo%'</span></code>.</p>
+<p><strong>Evaluation order has never been guaranteed to match the order written in the
+query.</strong> The SQL standard explicitly allows implementations to evaluate operands
+in any order; major engines (PostgreSQL, SQL Server, Oracle, MySQL) document the
+same. Queries should not rely on left-to-right evaluation or short-circuit
+semantics for <code class="docutils literal notranslate"><span class="pre">AND</span></code> or <code class="docutils literal notranslate"><span class="pre">OR</span></code>. Previous versions of DataFusion already reordered
+predicates (e.g., as part of expression simplification or predicate pushdown);
+the new reordering pass just increases the scenarios where the optimizer will
+change predicate evaluation order.</p>
+<p><strong>Fallible-predicate patterns are particularly affected.</strong> For example:</p>
+<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="k">WHERE</span><span class="w"> </span><span class="n">s</span><span class="w"> </span><span class="o">~</span><span class="w"> </span><span class="s1">'^[0-9]+$'</span><span class="w"> </span><span class="k">AND</span><span class="w"> </span><span class="k">CAST</span><span class="p">(</span><span class="n">s</span><span class="w"> </span><span class="k">AS</span><span class="w"> </span> [...]
+</pre></div>
+</div>
+<p>The intent is likely to filter non-numeric strings before the <code class="docutils literal notranslate"><span class="pre">CAST</span></code> runs,
+but this depends on evaluation-order behavior the SQL standard does not
+guaranteed. The new reorder makes this kind of pattern more likely to fail
+at runtime if the optimizer moves the <code class="docutils literal notranslate"><span class="pre">CAST</span></code> ahead of the regex. To force
+conditional evaluation, rewrite using <code class="docutils literal notranslate"><span class="pre">CASE</span></code>, which has standardized
+short-circuit semantics:</p>
+<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="k">WHERE</span><span class="w"> </span><span class="k">CASE</span><span class="w"> </span><span class="k">WHEN</span><span class="w"> </span><span class="n">s</span><span class="w"> </span><span class="o">~</span><span class="w"> </span><span class="s1">'^[0-9]+$'</span><span class="w"> </span><span class="k">THEN</span><span class="w"> </span><span class="k">CAST</span><span class="p">(< [...]
+</pre></div>
+</div>
+<p>Volatile expressions (<code class="docutils literal notranslate"><span class="pre">random()</span></code>, <code class="docutils literal notranslate"><span class="pre">now()</span></code>, etc.) are exempt — their position
+in the conjunct list is preserved so the number of times they evaluate per
+query does not change.</p>
+</section>
<section id="datafusion-proto-expression-deserialization-now-takes-a-taskcontext">
<h3><code class="docutils literal notranslate"><span class="pre">datafusion-proto</span></code>: expression deserialization now takes a <code class="docutils literal notranslate"><span class="pre">TaskContext</span></code><a class="headerlink" href="#datafusion-proto-expression-deserialization-now-takes-a-taskcontext" title="Link to this heading">#</a></h3>
<p><code class="docutils literal notranslate"><span class="pre">Serializeable::from_bytes_with_registry</span></code> is renamed to <code class="docutils literal notranslate"><span class="pre">from_bytes_with_ctx</span></code>
@@ -1315,6 +1347,7 @@ so user-defined higher-order functions can be registered</p>
<li class="toc-h3 nav-item toc-entry"><a class="reference internal nav-link" href="#avro-api-and-timestamp-decoding-changes">Avro API and timestamp decoding changes</a></li>
<li class="toc-h3 nav-item toc-entry"><a class="reference internal nav-link" href="#lpad-rpad-and-translate-now-operate-on-unicode-codepoints-instead-of-grapheme-clusters"><code class="docutils literal notranslate"><span class="pre">lpad</span></code>, <code class="docutils literal notranslate"><span class="pre">rpad</span></code>, and <code class="docutils literal notranslate"><span class="pre">translate</span></code> now operate on Unicode codepoints instead of grapheme clusters</a></li>
<li class="toc-h3 nav-item toc-entry"><a class="reference internal nav-link" href="#scalar-subquery-execution-changes">Scalar subquery execution changes</a></li>
+<li class="toc-h3 nav-item toc-entry"><a class="reference internal nav-link" href="#filter-predicate-evaluation-order-may-differ-from-query-text">Filter predicate evaluation order may differ from query text</a></li>
<li class="toc-h3 nav-item toc-entry"><a class="reference internal nav-link" href="#datafusion-proto-expression-deserialization-now-takes-a-taskcontext"><code class="docutils literal notranslate"><span class="pre">datafusion-proto</span></code>: expression deserialization now takes a <code class="docutils literal notranslate"><span class="pre">TaskContext</span></code></a></li>
<li class="toc-h3 nav-item toc-entry"><a class="reference internal nav-link" href="#datafusion-proto-physicalprotoconverterextension-reshaped"><code class="docutils literal notranslate"><span class="pre">datafusion-proto</span></code>: <code class="docutils literal notranslate"><span class="pre">PhysicalProtoConverterExtension</span></code> reshaped</a></li>
<li class="toc-h3 nav-item toc-entry"><a class="reference internal nav-link" href="#executionprops-has-new-fields"><code class="docutils literal notranslate"><span class="pre">ExecutionProps</span></code> has new fields</a></li>
diff --git a/library-user-guide/upgrading/55.0.0.html b/library-user-guide/upgrading/55.0.0.html
index 5f3623c9be..f941d77389 100644
--- a/library-user-guide/upgrading/55.0.0.html
+++ b/library-user-guide/upgrading/55.0.0.html
@@ -516,6 +516,102 @@ as a supertrait:</p>
</pre></div>
</div>
</section>
+<section id="ddlstatement-createexternaltable-and-createfunction-are-now-boxed">
+<h3><code class="docutils literal notranslate"><span class="pre">DdlStatement::CreateExternalTable</span></code> and <code class="docutils literal notranslate"><span class="pre">CreateFunction</span></code> are now boxed<a class="headerlink" href="#ddlstatement-createexternaltable-and-createfunction-are-now-boxed" title="Link to this heading">#</a></h3>
+<p>The two largest variants of <code class="docutils literal notranslate"><span class="pre">datafusion_expr::DdlStatement</span></code> are now
+<code class="docutils literal notranslate"><span class="pre">Box</span></code>ed:</p>
+<div class="highlight-rust notranslate"><div class="highlight"><pre><span></span><span class="c1">// Before</span>
+<span class="k">pub</span><span class="w"> </span><span class="k">enum</span><span class="w"> </span><span class="nc">DdlStatement</span><span class="w"> </span><span class="p">{</span>
+<span class="w"> </span><span class="n">CreateExternalTable</span><span class="p">(</span><span class="n">CreateExternalTable</span><span class="p">),</span>
+<span class="w"> </span><span class="c1">// ...</span>
+<span class="w"> </span><span class="n">CreateFunction</span><span class="p">(</span><span class="n">CreateFunction</span><span class="p">),</span>
+<span class="w"> </span><span class="c1">// ...</span>
+<span class="p">}</span>
+
+<span class="c1">// After</span>
+<span class="k">pub</span><span class="w"> </span><span class="k">enum</span><span class="w"> </span><span class="nc">DdlStatement</span><span class="w"> </span><span class="p">{</span>
+<span class="w"> </span><span class="n">CreateExternalTable</span><span class="p">(</span><span class="nb">Box</span><span class="o"><</span><span class="n">CreateExternalTable</span><span class="o">></span><span class="p">),</span>
+<span class="w"> </span><span class="c1">// ...</span>
+<span class="w"> </span><span class="n">CreateFunction</span><span class="p">(</span><span class="nb">Box</span><span class="o"><</span><span class="n">CreateFunction</span><span class="o">></span><span class="p">),</span>
+<span class="w"> </span><span class="c1">// ...</span>
+<span class="p">}</span>
+</pre></div>
+</div>
+<p><code class="docutils literal notranslate"><span class="pre">CreateExternalTable</span></code> is 312 bytes and <code class="docutils literal notranslate"><span class="pre">CreateFunction</span></code> is 288 bytes, so
+without boxing they forced the entire <code class="docutils literal notranslate"><span class="pre">LogicalPlan</span></code> enum to 320 bytes
+even on SELECT-only query paths that never instantiate them. Boxing
+shrinks <code class="docutils literal notranslate"><span class="pre">LogicalPlan</span></code> from 320 → 176 bytes (−45%), making every
+<code class="docutils literal notranslate"><span class="pre">mem::take</span></code> / <code class="docutils literal notranslate"><span class="pre">mem::swap</span></code> / <code class="docutils literal notranslate"><span class="pre">Arc<LogicalPlan></span></code> store on the planning
+hot path move a smaller payload.</p>
+<p><strong>Who is affected:</strong></p>
+<ul class="simple">
+<li><p>Users who construct <code class="docutils literal notranslate"><span class="pre">DdlStatement::CreateExternalTable(...)</span></code> or
+<code class="docutils literal notranslate"><span class="pre">DdlStatement::CreateFunction(...)</span></code> from an owned struct.</p></li>
+<li><p>Users who pattern-match these variants and destructure the inner
+struct in the same pattern (e.g.
+<code class="docutils literal notranslate"><span class="pre">DdlStatement::CreateExternalTable(CreateExternalTable</span> <span class="pre">{</span> <span class="pre">name,</span> <span class="pre">..</span> <span class="pre">})</span></code>).</p></li>
+<li><p>Code that consumes the inner struct out of these variants (e.g. to
+pass <code class="docutils literal notranslate"><span class="pre">CreateExternalTable</span></code> by value to another function).</p></li>
+</ul>
+<p><strong>Migration guide:</strong></p>
+<p>When constructing the variants, wrap the inner struct in <code class="docutils literal notranslate"><span class="pre">Box::new</span></code>:</p>
+<div class="highlight-rust notranslate"><div class="highlight"><pre><span></span><span class="c1">// Before</span>
+<span class="kd">let</span><span class="w"> </span><span class="n">stmt</span><span class="w"> </span><span class="o">=</span><span class="w"> </span><span class="n">DdlStatement</span><span class="p">::</span><span class="n">CreateFunction</span><span class="p">(</span><span class="n">CreateFunction</span><span class="w"> </span><span class="p">{</span><span class="w"> </span><span class="n">name</span><span class="p">,</span><span class="w"> </span><span class="n">args</span><span clas [...]
+
+<span class="c1">// After</span>
+<span class="kd">let</span><span class="w"> </span><span class="n">stmt</span><span class="w"> </span><span class="o">=</span><span class="w"> </span><span class="n">DdlStatement</span><span class="p">::</span><span class="n">CreateFunction</span><span class="p">(</span><span class="nb">Box</span><span class="p">::</span><span class="n">new</span><span class="p">(</span><span class="n">CreateFunction</span><span class="w"> </span><span class="p">{</span>
+<span class="w"> </span><span class="n">name</span><span class="p">,</span>
+<span class="w"> </span><span class="n">args</span><span class="p">,</span>
+<span class="w"> </span><span class="o">..</span>
+<span class="p">}));</span>
+</pre></div>
+</div>
+<p>When pattern-matching, bind the boxed value and either access fields
+through it (Rust auto-derefs the <code class="docutils literal notranslate"><span class="pre">Box</span></code>) or destructure via <code class="docutils literal notranslate"><span class="pre">.as_ref()</span></code>:</p>
+<div class="highlight-rust notranslate"><div class="highlight"><pre><span></span><span class="c1">// Before</span>
+<span class="k">match</span><span class="w"> </span><span class="n">ddl</span><span class="w"> </span><span class="p">{</span>
+<span class="w"> </span><span class="n">DdlStatement</span><span class="p">::</span><span class="n">CreateExternalTable</span><span class="p">(</span><span class="n">CreateExternalTable</span><span class="w"> </span><span class="p">{</span>
+<span class="w"> </span><span class="n">name</span><span class="p">,</span><span class="w"> </span><span class="n">location</span><span class="p">,</span><span class="w"> </span><span class="o">..</span>
+<span class="w"> </span><span class="p">})</span><span class="w"> </span><span class="o">=></span><span class="w"> </span><span class="p">{</span><span class="w"> </span><span class="cm">/* use name, location */</span><span class="w"> </span><span class="p">}</span>
+<span class="p">}</span>
+
+<span class="c1">// After — access fields through the box</span>
+<span class="k">match</span><span class="w"> </span><span class="n">ddl</span><span class="w"> </span><span class="p">{</span>
+<span class="w"> </span><span class="n">DdlStatement</span><span class="p">::</span><span class="n">CreateExternalTable</span><span class="p">(</span><span class="n">ce</span><span class="p">)</span><span class="w"> </span><span class="o">=></span><span class="w"> </span><span class="p">{</span>
+<span class="w"> </span><span class="kd">let</span><span class="w"> </span><span class="n">name</span><span class="w"> </span><span class="o">=</span><span class="w"> </span><span class="o">&</span><span class="n">ce</span><span class="p">.</span><span class="n">name</span><span class="p">;</span>
+<span class="w"> </span><span class="kd">let</span><span class="w"> </span><span class="n">location</span><span class="w"> </span><span class="o">=</span><span class="w"> </span><span class="o">&</span><span class="n">ce</span><span class="p">.</span><span class="n">location</span><span class="p">;</span>
+<span class="w"> </span><span class="cm">/* ... */</span>
+<span class="w"> </span><span class="p">}</span>
+<span class="p">}</span>
+
+<span class="c1">// After — destructure the dereferenced struct</span>
+<span class="k">match</span><span class="w"> </span><span class="n">ddl</span><span class="w"> </span><span class="p">{</span>
+<span class="w"> </span><span class="n">DdlStatement</span><span class="p">::</span><span class="n">CreateExternalTable</span><span class="p">(</span><span class="n">ce</span><span class="p">)</span><span class="w"> </span><span class="o">=></span><span class="w"> </span><span class="p">{</span>
+<span class="w"> </span><span class="kd">let</span><span class="w"> </span><span class="n">CreateExternalTable</span><span class="w"> </span><span class="p">{</span><span class="w"> </span><span class="n">name</span><span class="p">,</span><span class="w"> </span><span class="n">location</span><span class="p">,</span><span class="w"> </span><span class="o">..</span><span class="w"> </span><span class="p">}</span><span class="w"> </span><span class="o">=</span><span class="w"> </sp [...]
+<span class="w"> </span><span class="cm">/* ... */</span>
+<span class="w"> </span><span class="p">}</span>
+<span class="p">}</span>
+</pre></div>
+</div>
+<p>When you need an owned <code class="docutils literal notranslate"><span class="pre">CreateExternalTable</span></code> / <code class="docutils literal notranslate"><span class="pre">CreateFunction</span></code> out of
+the variant, dereference the box with <code class="docutils literal notranslate"><span class="pre">*</span></code>:</p>
+<div class="highlight-rust notranslate"><div class="highlight"><pre><span></span><span class="c1">// Before</span>
+<span class="k">match</span><span class="w"> </span><span class="n">plan</span><span class="w"> </span><span class="p">{</span>
+<span class="w"> </span><span class="n">LogicalPlan</span><span class="p">::</span><span class="n">Ddl</span><span class="p">(</span><span class="n">DdlStatement</span><span class="p">::</span><span class="n">CreateExternalTable</span><span class="p">(</span><span class="n">cmd</span><span class="p">))</span><span class="w"> </span><span class="o">=></span><span class="w"> </span><span class="nb">Ok</span><span class="p">(</span><span class="n">cmd</span><span class="p">),</span>
+<span class="w"> </span><span class="n">_</span><span class="w"> </span><span class="o">=></span><span class="w"> </span><span class="p">{</span><span class="w"> </span><span class="cm">/* ... */</span><span class="w"> </span><span class="p">}</span>
+<span class="p">}</span>
+
+<span class="c1">// After</span>
+<span class="k">match</span><span class="w"> </span><span class="n">plan</span><span class="w"> </span><span class="p">{</span>
+<span class="w"> </span><span class="n">LogicalPlan</span><span class="p">::</span><span class="n">Ddl</span><span class="p">(</span><span class="n">DdlStatement</span><span class="p">::</span><span class="n">CreateExternalTable</span><span class="p">(</span><span class="n">cmd</span><span class="p">))</span><span class="w"> </span><span class="o">=></span><span class="w"> </span><span class="nb">Ok</span><span class="p">(</span><span class="o">*</span><span class="n">cmd</span><sp [...]
+<span class="w"> </span><span class="n">_</span><span class="w"> </span><span class="o">=></span><span class="w"> </span><span class="p">{</span><span class="w"> </span><span class="cm">/* ... */</span><span class="w"> </span><span class="p">}</span>
+<span class="p">}</span>
+</pre></div>
+</div>
+<p>See <a class="reference external" href="https://github.com/apache/datafusion/pull/22733">PR #22733</a> for
+details, including the per-variant size breakdown and benchmark
+results.</p>
+</section>
<section id="spark-map-functions-now-reject-duplicate-keys-by-default">
<h3>Spark map functions now reject duplicate keys by default<a class="headerlink" href="#spark-map-functions-now-reject-duplicate-keys-by-default" title="Link to this heading">#</a></h3>
<p>The Spark-compatibility map-construction functions (<code class="docutils literal notranslate"><span class="pre">map_from_arrays</span></code>,
@@ -598,6 +694,7 @@ silently or raised a non-configurable error.</p></li>
<li class="toc-h3 nav-item toc-entry"><a class="reference internal nav-link" href="#is-dynamic-physical-expr-is-deprecated"><code class="docutils literal notranslate"><span class="pre">is_dynamic_physical_expr</span></code> is deprecated</a></li>
<li class="toc-h3 nav-item toc-entry"><a class="reference internal nav-link" href="#filepruner-try-new-no-longer-builds-a-pruner-for-static-predicates-without-statistics"><code class="docutils literal notranslate"><span class="pre">FilePruner::try_new</span></code> no longer builds a pruner for static predicates without statistics</a></li>
<li class="toc-h3 nav-item toc-entry"><a class="reference internal nav-link" href="#queryplanner-adds-any-as-a-supertrait"><code class="docutils literal notranslate"><span class="pre">QueryPlanner</span></code> adds <code class="docutils literal notranslate"><span class="pre">Any</span></code> as a supertrait</a></li>
+<li class="toc-h3 nav-item toc-entry"><a class="reference internal nav-link" href="#ddlstatement-createexternaltable-and-createfunction-are-now-boxed"><code class="docutils literal notranslate"><span class="pre">DdlStatement::CreateExternalTable</span></code> and <code class="docutils literal notranslate"><span class="pre">CreateFunction</span></code> are now boxed</a></li>
<li class="toc-h3 nav-item toc-entry"><a class="reference internal nav-link" href="#spark-map-functions-now-reject-duplicate-keys-by-default">Spark map functions now reject duplicate keys by default</a></li>
</ul>
</li>
diff --git a/library-user-guide/working-with-exprs.html b/library-user-guide/working-with-exprs.html
index 342a313ed2..55b5f6d3cf 100644
--- a/library-user-guide/working-with-exprs.html
+++ b/library-user-guide/working-with-exprs.html
@@ -566,7 +566,7 @@
<p>We’ll call our rule <code class="docutils literal notranslate"><span class="pre">AddOneInliner</span></code> and implement the <code class="docutils literal notranslate"><span class="pre">OptimizerRule</span></code> trait. The <code class="docutils literal notranslate"><span class="pre">OptimizerRule</span></code> trait has two methods:</p>
<ul class="simple">
<li><p><code class="docutils literal notranslate"><span class="pre">name</span></code> - returns the name of the rule</p></li>
-<li><p><code class="docutils literal notranslate"><span class="pre">try_optimize</span></code> - takes a <code class="docutils literal notranslate"><span class="pre">LogicalPlan</span></code> and returns an <code class="docutils literal notranslate"><span class="pre">Option<LogicalPlan></span></code>. If the rule is able to optimize the plan, it returns <code class="docutils literal notranslate"><span class="pre">Some(LogicalPlan)</span></code> with the optimized plan. If the rule [...]
+<li><p><code class="docutils literal notranslate"><span class="pre">rewrite</span></code> - takes a <code class="docutils literal notranslate"><span class="pre">LogicalPlan</span></code> and <code class="docutils literal notranslate"><span class="pre">&dyn</span> <span class="pre">OptimizerConfig</span></code>, and returns a <code class="docutils literal notranslate"><span class="pre">Result<Transformed<LogicalPlan>></span></code>. If the rule is able to optimize the plan [...]
</ul>
<div class="highlight-rust notranslate"><div class="highlight"><pre><span></span><span class="k">use</span><span class="w"> </span><span class="n">std</span><span class="p">::</span><span class="n">sync</span><span class="p">::</span><span class="n">Arc</span><span class="p">;</span>
<span class="k">use</span><span class="w"> </span><span class="n">datafusion</span><span class="p">::</span><span class="n">common</span><span class="p">::</span><span class="nb">Result</span><span class="p">;</span>
diff --git a/searchindex.js b/searchindex.js
index 0e63e7d5da..0ecd29960a 100644
--- a/searchindex.js
+++ b/searchindex.js
@@ -1 +1 @@
-Search.setIndex({"alltitles":{"!=":[[74,"op-neq"]],"!~":[[74,"op-re-not-match"]],"!~*":[[74,"op-re-not-match-i"]],"!~~":[[74,"id19"]],"!~~*":[[74,"id20"]],"#":[[74,"op-bit-xor"]],"%":[[74,"op-modulo"]],"&":[[74,"op-bit-and"]],"(relation, name) tuples in logical fields and logical columns are unique":[[15,"relation-name-tuples-in-logical-fields-and-logical-columns-are-unique"]],"*":[[74,"op-multiply"]],"+":[[74,"op-plus"]],"-":[[74,"op-minus"]],"/":[[74,"op-divide"]],"1. Array Literal Con [...]
\ No newline at end of file
+Search.setIndex({"alltitles":{"!=":[[74,"op-neq"]],"!~":[[74,"op-re-not-match"]],"!~*":[[74,"op-re-not-match-i"]],"!~~":[[74,"id19"]],"!~~*":[[74,"id20"]],"#":[[74,"op-bit-xor"]],"%":[[74,"op-modulo"]],"&":[[74,"op-bit-and"]],"(relation, name) tuples in logical fields and logical columns are unique":[[15,"relation-name-tuples-in-logical-fields-and-logical-columns-are-unique"]],"*":[[74,"op-multiply"]],"+":[[74,"op-plus"]],"-":[[74,"op-minus"]],"/":[[74,"op-divide"]],"1. Array Literal Con [...]
\ No newline at end of file
diff --git a/user-guide/sql/scalar_functions.html b/user-guide/sql/scalar_functions.html
index 8a8f38b636..4ab2f5db9f 100644
--- a/user-guide/sql/scalar_functions.html
+++ b/user-guide/sql/scalar_functions.html
@@ -3819,6 +3819,7 @@ Integers, unsigned integers, and floats are interpreted as seconds since the uni
<li><p><a class="reference internal" href="#array-position">array_position</a></p></li>
<li><p><a class="reference internal" href="#array-positions">array_positions</a></p></li>
<li><p><a class="reference internal" href="#array-prepend">array_prepend</a></p></li>
+<li><p><a class="reference internal" href="#array-product">array_product</a></p></li>
<li><p><a class="reference internal" href="#array-push-back">array_push_back</a></p></li>
<li><p><a class="reference internal" href="#array-push-front">array_push_front</a></p></li>
<li><p><a class="reference internal" href="#array-remove">array_remove</a></p></li>
@@ -3877,6 +3878,7 @@ Integers, unsigned integers, and floats are interpreted as seconds since the uni
<li><p><a class="reference internal" href="#list-position">list_position</a></p></li>
<li><p><a class="reference internal" href="#list-positions">list_positions</a></p></li>
<li><p><a class="reference internal" href="#list-prepend">list_prepend</a></p></li>
+<li><p><a class="reference internal" href="#list-product">list_product</a></p></li>
<li><p><a class="reference internal" href="#list-push-back">list_push_back</a></p></li>
<li><p><a class="reference internal" href="#list-push-front">list_push_front</a></p></li>
<li><p><a class="reference internal" href="#list-remove">list_remove</a></p></li>
@@ -4755,6 +4757,36 @@ Integers, unsigned integers, and floats are interpreted as seconds since the uni
</ul>
</section>
</section>
+<section id="array-product">
+<h3><code class="docutils literal notranslate"><span class="pre">array_product</span></code><a class="headerlink" href="#array-product" title="Link to this heading">#</a></h3>
+<p>Returns the product of the elements in the input numeric array. NULL elements inside the array are skipped (matching SQL aggregate convention). Returns NULL if the input is NULL, every element is NULL, or the array is empty. The result is always returned as <code class="docutils literal notranslate"><span class="pre">Float64</span></code>.</p>
+<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="n">array_product</span><span class="p">(</span><span class="nb">array</span><span class="p">)</span>
+</pre></div>
+</div>
+<section id="id289">
+<h4>Arguments<a class="headerlink" href="#id289" title="Link to this heading">#</a></h4>
+<ul class="simple">
+<li><p><strong>array</strong>: Array expression. Can be a constant, column, or function, and any combination of array operators.</p></li>
+</ul>
+</section>
+<section id="id290">
+<h4>Example<a class="headerlink" href="#id290" title="Link to this heading">#</a></h4>
+<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="o">></span><span class="w"> </span><span class="k">select</span><span class="w"> </span><span class="n">array_product</span><span class="p">([</span><span class="mi">1</span><span class="p">.</span><span class="mi">0</span><span class="p">,</span><span class="w"> </span><span class="mi">2</span><span class="p">.</span><span class="mi">0</span><span class="p">,</span><span class="w"> </span><sp [...]
+<span class="o">+</span><span class="c1">------------------------------------+</span>
+<span class="o">|</span><span class="w"> </span><span class="n">array_product</span><span class="p">(</span><span class="n">List</span><span class="p">([</span><span class="mi">1</span><span class="p">.</span><span class="mi">0</span><span class="p">,</span><span class="mi">2</span><span class="p">.</span><span class="mi">0</span><span class="p">,</span><span class="mi">3</span><span class="p">.</span><span class="mi">0</span><span class="p">]))</span><span class="w"> </span><span class= [...]
+<span class="o">+</span><span class="c1">------------------------------------+</span>
+<span class="o">|</span><span class="w"> </span><span class="mi">6</span><span class="p">.</span><span class="mi">0</span><span class="w"> </span><span class="o">|</span>
+<span class="o">+</span><span class="c1">------------------------------------+</span>
+</pre></div>
+</div>
+</section>
+<section id="id291">
+<h4>Aliases<a class="headerlink" href="#id291" title="Link to this heading">#</a></h4>
+<ul class="simple">
+<li><p>list_product</p></li>
+</ul>
+</section>
+</section>
<section id="array-push-back">
<h3><code class="docutils literal notranslate"><span class="pre">array_push_back</span></code><a class="headerlink" href="#array-push-back" title="Link to this heading">#</a></h3>
<p><em>Alias of <a class="reference internal" href="#array-append">array_append</a>.</em></p>
@@ -4769,15 +4801,15 @@ Integers, unsigned integers, and floats are interpreted as seconds since the uni
<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="n">array_remove</span><span class="p">(</span><span class="nb">array</span><span class="p">,</span><span class="w"> </span><span class="n">element</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id289">
-<h4>Arguments<a class="headerlink" href="#id289" title="Link to this heading">#</a></h4>
+<section id="id292">
+<h4>Arguments<a class="headerlink" href="#id292" title="Link to this heading">#</a></h4>
<ul class="simple">
<li><p><strong>array</strong>: Array expression. Can be a constant, column, or function, and any combination of array operators.</p></li>
<li><p><strong>element</strong>: Element to be removed from the array.</p></li>
</ul>
</section>
-<section id="id290">
-<h4>Example<a class="headerlink" href="#id290" title="Link to this heading">#</a></h4>
+<section id="id293">
+<h4>Example<a class="headerlink" href="#id293" title="Link to this heading">#</a></h4>
<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="o">></span><span class="w"> </span><span class="k">select</span><span class="w"> </span><span class="n">array_remove</span><span class="p">([</span><span class="mi">1</span><span class="p">,</span><span class="w"> </span><span class="mi">2</span><span class="p">,</span><span class="w"> </span><span class="mi">2</span><span class="p">,</span><span class="w"> </span><span class="mi">3</span><spa [...]
<span class="o">+</span><span class="c1">----------------------------------------------+</span>
<span class="o">|</span><span class="w"> </span><span class="n">array_remove</span><span class="p">(</span><span class="n">List</span><span class="p">([</span><span class="mi">1</span><span class="p">,</span><span class="mi">2</span><span class="p">,</span><span class="mi">2</span><span class="p">,</span><span class="mi">3</span><span class="p">,</span><span class="mi">2</span><span class="p">,</span><span class="mi">1</span><span class="p">,</span><span class="mi">4</span><span class="p [...]
@@ -4794,8 +4826,8 @@ Integers, unsigned integers, and floats are interpreted as seconds since the uni
</pre></div>
</div>
</section>
-<section id="id291">
-<h4>Aliases<a class="headerlink" href="#id291" title="Link to this heading">#</a></h4>
+<section id="id294">
+<h4>Aliases<a class="headerlink" href="#id294" title="Link to this heading">#</a></h4>
<ul class="simple">
<li><p>list_remove</p></li>
</ul>
@@ -4807,15 +4839,15 @@ Integers, unsigned integers, and floats are interpreted as seconds since the uni
<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="n">array_remove_all</span><span class="p">(</span><span class="nb">array</span><span class="p">,</span><span class="w"> </span><span class="n">element</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id292">
-<h4>Arguments<a class="headerlink" href="#id292" title="Link to this heading">#</a></h4>
+<section id="id295">
+<h4>Arguments<a class="headerlink" href="#id295" title="Link to this heading">#</a></h4>
<ul class="simple">
<li><p><strong>array</strong>: Array expression. Can be a constant, column, or function, and any combination of array operators.</p></li>
<li><p><strong>element</strong>: Element to be removed from the array.</p></li>
</ul>
</section>
-<section id="id293">
-<h4>Example<a class="headerlink" href="#id293" title="Link to this heading">#</a></h4>
+<section id="id296">
+<h4>Example<a class="headerlink" href="#id296" title="Link to this heading">#</a></h4>
<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="o">></span><span class="w"> </span><span class="k">select</span><span class="w"> </span><span class="n">array_remove_all</span><span class="p">([</span><span class="mi">1</span><span class="p">,</span><span class="w"> </span><span class="mi">2</span><span class="p">,</span><span class="w"> </span><span class="mi">2</span><span class="p">,</span><span class="w"> </span><span class="mi">3</span> [...]
<span class="o">+</span><span class="c1">--------------------------------------------------+</span>
<span class="o">|</span><span class="w"> </span><span class="n">array_remove_all</span><span class="p">(</span><span class="n">List</span><span class="p">([</span><span class="mi">1</span><span class="p">,</span><span class="mi">2</span><span class="p">,</span><span class="mi">2</span><span class="p">,</span><span class="mi">3</span><span class="p">,</span><span class="mi">2</span><span class="p">,</span><span class="mi">1</span><span class="p">,</span><span class="mi">4</span><span clas [...]
@@ -4832,8 +4864,8 @@ Integers, unsigned integers, and floats are interpreted as seconds since the uni
</pre></div>
</div>
</section>
-<section id="id294">
-<h4>Aliases<a class="headerlink" href="#id294" title="Link to this heading">#</a></h4>
+<section id="id297">
+<h4>Aliases<a class="headerlink" href="#id297" title="Link to this heading">#</a></h4>
<ul class="simple">
<li><p>list_remove_all</p></li>
</ul>
@@ -4845,16 +4877,16 @@ Integers, unsigned integers, and floats are interpreted as seconds since the uni
<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="n">array_remove_n</span><span class="p">(</span><span class="nb">array</span><span class="p">,</span><span class="w"> </span><span class="n">element</span><span class="p">,</span><span class="w"> </span><span class="k">max</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id295">
-<h4>Arguments<a class="headerlink" href="#id295" title="Link to this heading">#</a></h4>
+<section id="id298">
+<h4>Arguments<a class="headerlink" href="#id298" title="Link to this heading">#</a></h4>
<ul class="simple">
<li><p><strong>array</strong>: Array expression. Can be a constant, column, or function, and any combination of array operators.</p></li>
<li><p><strong>element</strong>: Element to be removed from the array.</p></li>
<li><p><strong>max</strong>: Number of first occurrences to remove.</p></li>
</ul>
</section>
-<section id="id296">
-<h4>Example<a class="headerlink" href="#id296" title="Link to this heading">#</a></h4>
+<section id="id299">
+<h4>Example<a class="headerlink" href="#id299" title="Link to this heading">#</a></h4>
<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="o">></span><span class="w"> </span><span class="k">select</span><span class="w"> </span><span class="n">array_remove_n</span><span class="p">([</span><span class="mi">1</span><span class="p">,</span><span class="w"> </span><span class="mi">2</span><span class="p">,</span><span class="w"> </span><span class="mi">2</span><span class="p">,</span><span class="w"> </span><span class="mi">3</span><s [...]
<span class="o">+</span><span class="c1">---------------------------------------------------------+</span>
<span class="o">|</span><span class="w"> </span><span class="n">array_remove_n</span><span class="p">(</span><span class="n">List</span><span class="p">([</span><span class="mi">1</span><span class="p">,</span><span class="mi">2</span><span class="p">,</span><span class="mi">2</span><span class="p">,</span><span class="mi">3</span><span class="p">,</span><span class="mi">2</span><span class="p">,</span><span class="mi">1</span><span class="p">,</span><span class="mi">4</span><span class= [...]
@@ -4871,8 +4903,8 @@ Integers, unsigned integers, and floats are interpreted as seconds since the uni
</pre></div>
</div>
</section>
-<section id="id297">
-<h4>Aliases<a class="headerlink" href="#id297" title="Link to this heading">#</a></h4>
+<section id="id300">
+<h4>Aliases<a class="headerlink" href="#id300" title="Link to this heading">#</a></h4>
<ul class="simple">
<li><p>list_remove_n</p></li>
</ul>
@@ -4884,15 +4916,15 @@ Integers, unsigned integers, and floats are interpreted as seconds since the uni
<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="n">array_repeat</span><span class="p">(</span><span class="n">element</span><span class="p">,</span><span class="w"> </span><span class="k">count</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id298">
-<h4>Arguments<a class="headerlink" href="#id298" title="Link to this heading">#</a></h4>
+<section id="id301">
+<h4>Arguments<a class="headerlink" href="#id301" title="Link to this heading">#</a></h4>
<ul class="simple">
<li><p><strong>element</strong>: Element expression. Can be a constant, column, or function, and any combination of array operators.</p></li>
<li><p><strong>count</strong>: Value of how many times to repeat the element.</p></li>
</ul>
</section>
-<section id="id299">
-<h4>Example<a class="headerlink" href="#id299" title="Link to this heading">#</a></h4>
+<section id="id302">
+<h4>Example<a class="headerlink" href="#id302" title="Link to this heading">#</a></h4>
<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="o">></span><span class="w"> </span><span class="k">select</span><span class="w"> </span><span class="n">array_repeat</span><span class="p">(</span><span class="mi">1</span><span class="p">,</span><span class="w"> </span><span class="mi">3</span><span class="p">);</span>
<span class="o">+</span><span class="c1">---------------------------------+</span>
<span class="o">|</span><span class="w"> </span><span class="n">array_repeat</span><span class="p">(</span><span class="n">Int64</span><span class="p">(</span><span class="mi">1</span><span class="p">),</span><span class="n">Int64</span><span class="p">(</span><span class="mi">3</span><span class="p">))</span><span class="w"> </span><span class="o">|</span>
@@ -4908,8 +4940,8 @@ Integers, unsigned integers, and floats are interpreted as seconds since the uni
</pre></div>
</div>
</section>
-<section id="id300">
-<h4>Aliases<a class="headerlink" href="#id300" title="Link to this heading">#</a></h4>
+<section id="id303">
+<h4>Aliases<a class="headerlink" href="#id303" title="Link to this heading">#</a></h4>
<ul class="simple">
<li><p>list_repeat</p></li>
</ul>
@@ -4921,16 +4953,16 @@ Integers, unsigned integers, and floats are interpreted as seconds since the uni
<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="n">array_replace</span><span class="p">(</span><span class="nb">array</span><span class="p">,</span><span class="w"> </span><span class="k">from</span><span class="p">,</span><span class="w"> </span><span class="k">to</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id301">
-<h4>Arguments<a class="headerlink" href="#id301" title="Link to this heading">#</a></h4>
+<section id="id304">
+<h4>Arguments<a class="headerlink" href="#id304" title="Link to this heading">#</a></h4>
<ul class="simple">
<li><p><strong>array</strong>: Array expression. Can be a constant, column, or function, and any combination of array operators.</p></li>
<li><p><strong>from</strong>: Initial element.</p></li>
<li><p><strong>to</strong>: Final element.</p></li>
</ul>
</section>
-<section id="id302">
-<h4>Example<a class="headerlink" href="#id302" title="Link to this heading">#</a></h4>
+<section id="id305">
+<h4>Example<a class="headerlink" href="#id305" title="Link to this heading">#</a></h4>
<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="o">></span><span class="w"> </span><span class="k">select</span><span class="w"> </span><span class="n">array_replace</span><span class="p">([</span><span class="mi">1</span><span class="p">,</span><span class="w"> </span><span class="mi">2</span><span class="p">,</span><span class="w"> </span><span class="mi">2</span><span class="p">,</span><span class="w"> </span><span class="mi">3</span><sp [...]
<span class="o">+</span><span class="c1">--------------------------------------------------------+</span>
<span class="o">|</span><span class="w"> </span><span class="n">array_replace</span><span class="p">(</span><span class="n">List</span><span class="p">([</span><span class="mi">1</span><span class="p">,</span><span class="mi">2</span><span class="p">,</span><span class="mi">2</span><span class="p">,</span><span class="mi">3</span><span class="p">,</span><span class="mi">2</span><span class="p">,</span><span class="mi">1</span><span class="p">,</span><span class="mi">4</span><span class=" [...]
@@ -4940,8 +4972,8 @@ Integers, unsigned integers, and floats are interpreted as seconds since the uni
</pre></div>
</div>
</section>
-<section id="id303">
-<h4>Aliases<a class="headerlink" href="#id303" title="Link to this heading">#</a></h4>
+<section id="id306">
+<h4>Aliases<a class="headerlink" href="#id306" title="Link to this heading">#</a></h4>
<ul class="simple">
<li><p>list_replace</p></li>
</ul>
@@ -4953,16 +4985,16 @@ Integers, unsigned integers, and floats are interpreted as seconds since the uni
<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="n">array_replace_all</span><span class="p">(</span><span class="nb">array</span><span class="p">,</span><span class="w"> </span><span class="k">from</span><span class="p">,</span><span class="w"> </span><span class="k">to</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id304">
-<h4>Arguments<a class="headerlink" href="#id304" title="Link to this heading">#</a></h4>
+<section id="id307">
+<h4>Arguments<a class="headerlink" href="#id307" title="Link to this heading">#</a></h4>
<ul class="simple">
<li><p><strong>array</strong>: Array expression. Can be a constant, column, or function, and any combination of array operators.</p></li>
<li><p><strong>from</strong>: Initial element.</p></li>
<li><p><strong>to</strong>: Final element.</p></li>
</ul>
</section>
-<section id="id305">
-<h4>Example<a class="headerlink" href="#id305" title="Link to this heading">#</a></h4>
+<section id="id308">
+<h4>Example<a class="headerlink" href="#id308" title="Link to this heading">#</a></h4>
<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="o">></span><span class="w"> </span><span class="k">select</span><span class="w"> </span><span class="n">array_replace_all</span><span class="p">([</span><span class="mi">1</span><span class="p">,</span><span class="w"> </span><span class="mi">2</span><span class="p">,</span><span class="w"> </span><span class="mi">2</span><span class="p">,</span><span class="w"> </span><span class="mi">3</span [...]
<span class="o">+</span><span class="c1">------------------------------------------------------------+</span>
<span class="o">|</span><span class="w"> </span><span class="n">array_replace_all</span><span class="p">(</span><span class="n">List</span><span class="p">([</span><span class="mi">1</span><span class="p">,</span><span class="mi">2</span><span class="p">,</span><span class="mi">2</span><span class="p">,</span><span class="mi">3</span><span class="p">,</span><span class="mi">2</span><span class="p">,</span><span class="mi">1</span><span class="p">,</span><span class="mi">4</span><span cla [...]
@@ -4972,8 +5004,8 @@ Integers, unsigned integers, and floats are interpreted as seconds since the uni
</pre></div>
</div>
</section>
-<section id="id306">
-<h4>Aliases<a class="headerlink" href="#id306" title="Link to this heading">#</a></h4>
+<section id="id309">
+<h4>Aliases<a class="headerlink" href="#id309" title="Link to this heading">#</a></h4>
<ul class="simple">
<li><p>list_replace_all</p></li>
</ul>
@@ -4985,8 +5017,8 @@ Integers, unsigned integers, and floats are interpreted as seconds since the uni
<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="n">array_replace_n</span><span class="p">(</span><span class="nb">array</span><span class="p">,</span><span class="w"> </span><span class="k">from</span><span class="p">,</span><span class="w"> </span><span class="k">to</span><span class="p">,</span><span class="w"> </span><span class="k">max</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id307">
-<h4>Arguments<a class="headerlink" href="#id307" title="Link to this heading">#</a></h4>
+<section id="id310">
+<h4>Arguments<a class="headerlink" href="#id310" title="Link to this heading">#</a></h4>
<ul class="simple">
<li><p><strong>array</strong>: Array expression. Can be a constant, column, or function, and any combination of array operators.</p></li>
<li><p><strong>from</strong>: Initial element.</p></li>
@@ -4994,8 +5026,8 @@ Integers, unsigned integers, and floats are interpreted as seconds since the uni
<li><p><strong>max</strong>: Number of first occurrences to replace.</p></li>
</ul>
</section>
-<section id="id308">
-<h4>Example<a class="headerlink" href="#id308" title="Link to this heading">#</a></h4>
+<section id="id311">
+<h4>Example<a class="headerlink" href="#id311" title="Link to this heading">#</a></h4>
<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="o">></span><span class="w"> </span><span class="k">select</span><span class="w"> </span><span class="n">array_replace_n</span><span class="p">([</span><span class="mi">1</span><span class="p">,</span><span class="w"> </span><span class="mi">2</span><span class="p">,</span><span class="w"> </span><span class="mi">2</span><span class="p">,</span><span class="w"> </span><span class="mi">3</span>< [...]
<span class="o">+</span><span class="c1">-------------------------------------------------------------------+</span>
<span class="o">|</span><span class="w"> </span><span class="n">array_replace_n</span><span class="p">(</span><span class="n">List</span><span class="p">([</span><span class="mi">1</span><span class="p">,</span><span class="mi">2</span><span class="p">,</span><span class="mi">2</span><span class="p">,</span><span class="mi">3</span><span class="p">,</span><span class="mi">2</span><span class="p">,</span><span class="mi">1</span><span class="p">,</span><span class="mi">4</span><span class [...]
@@ -5005,8 +5037,8 @@ Integers, unsigned integers, and floats are interpreted as seconds since the uni
</pre></div>
</div>
</section>
-<section id="id309">
-<h4>Aliases<a class="headerlink" href="#id309" title="Link to this heading">#</a></h4>
+<section id="id312">
+<h4>Aliases<a class="headerlink" href="#id312" title="Link to this heading">#</a></h4>
<ul class="simple">
<li><p>list_replace_n</p></li>
</ul>
@@ -5018,16 +5050,16 @@ Integers, unsigned integers, and floats are interpreted as seconds since the uni
<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="n">array_resize</span><span class="p">(</span><span class="nb">array</span><span class="p">,</span><span class="w"> </span><span class="k">size</span><span class="p">,</span><span class="w"> </span><span class="n">value</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id310">
-<h4>Arguments<a class="headerlink" href="#id310" title="Link to this heading">#</a></h4>
+<section id="id313">
+<h4>Arguments<a class="headerlink" href="#id313" title="Link to this heading">#</a></h4>
<ul class="simple">
<li><p><strong>array</strong>: Array expression. Can be a constant, column, or function, and any combination of array operators.</p></li>
<li><p><strong>size</strong>: New size of given array.</p></li>
<li><p><strong>value</strong>: Defines new elements’ value or empty if value is not set.</p></li>
</ul>
</section>
-<section id="id311">
-<h4>Example<a class="headerlink" href="#id311" title="Link to this heading">#</a></h4>
+<section id="id314">
+<h4>Example<a class="headerlink" href="#id314" title="Link to this heading">#</a></h4>
<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="o">></span><span class="w"> </span><span class="k">select</span><span class="w"> </span><span class="n">array_resize</span><span class="p">([</span><span class="mi">1</span><span class="p">,</span><span class="w"> </span><span class="mi">2</span><span class="p">,</span><span class="w"> </span><span class="mi">3</span><span class="p">],</span><span class="w"> </span><span class="mi">5</span><sp [...]
<span class="o">+</span><span class="c1">-------------------------------------+</span>
<span class="o">|</span><span class="w"> </span><span class="n">array_resize</span><span class="p">(</span><span class="n">List</span><span class="p">([</span><span class="mi">1</span><span class="p">,</span><span class="mi">2</span><span class="p">,</span><span class="mi">3</span><span class="p">],</span><span class="mi">5</span><span class="p">,</span><span class="mi">0</span><span class="p">))</span><span class="w"> </span><span class="o">|</span>
@@ -5037,8 +5069,8 @@ Integers, unsigned integers, and floats are interpreted as seconds since the uni
</pre></div>
</div>
</section>
-<section id="id312">
-<h4>Aliases<a class="headerlink" href="#id312" title="Link to this heading">#</a></h4>
+<section id="id315">
+<h4>Aliases<a class="headerlink" href="#id315" title="Link to this heading">#</a></h4>
<ul class="simple">
<li><p>list_resize</p></li>
</ul>
@@ -5050,14 +5082,14 @@ Integers, unsigned integers, and floats are interpreted as seconds since the uni
<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="n">array_reverse</span><span class="p">(</span><span class="nb">array</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id313">
-<h4>Arguments<a class="headerlink" href="#id313" title="Link to this heading">#</a></h4>
+<section id="id316">
+<h4>Arguments<a class="headerlink" href="#id316" title="Link to this heading">#</a></h4>
<ul class="simple">
<li><p><strong>array</strong>: Array expression. Can be a constant, column, or function, and any combination of array operators.</p></li>
</ul>
</section>
-<section id="id314">
-<h4>Example<a class="headerlink" href="#id314" title="Link to this heading">#</a></h4>
+<section id="id317">
+<h4>Example<a class="headerlink" href="#id317" title="Link to this heading">#</a></h4>
<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="o">></span><span class="w"> </span><span class="k">select</span><span class="w"> </span><span class="n">array_reverse</span><span class="p">([</span><span class="mi">1</span><span class="p">,</span><span class="w"> </span><span class="mi">2</span><span class="p">,</span><span class="w"> </span><span class="mi">3</span><span class="p">,</span><span class="w"> </span><span class="mi">4</span><sp [...]
<span class="o">+</span><span class="c1">------------------------------------------------------------+</span>
<span class="o">|</span><span class="w"> </span><span class="n">array_reverse</span><span class="p">(</span><span class="n">List</span><span class="p">([</span><span class="mi">1</span><span class="p">,</span><span class="w"> </span><span class="mi">2</span><span class="p">,</span><span class="w"> </span><span class="mi">3</span><span class="p">,</span><span class="w"> </span><span class="mi">4</span><span class="p">]))</span><span class="w"> </span><span class=" [...]
@@ -5067,8 +5099,8 @@ Integers, unsigned integers, and floats are interpreted as seconds since the uni
</pre></div>
</div>
</section>
-<section id="id315">
-<h4>Aliases<a class="headerlink" href="#id315" title="Link to this heading">#</a></h4>
+<section id="id318">
+<h4>Aliases<a class="headerlink" href="#id318" title="Link to this heading">#</a></h4>
<ul class="simple">
<li><p>list_reverse</p></li>
</ul>
@@ -5080,15 +5112,15 @@ Integers, unsigned integers, and floats are interpreted as seconds since the uni
<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="n">array_scale</span><span class="p">(</span><span class="nb">array</span><span class="p">,</span><span class="w"> </span><span class="n">scalar</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id316">
-<h4>Arguments<a class="headerlink" href="#id316" title="Link to this heading">#</a></h4>
+<section id="id319">
+<h4>Arguments<a class="headerlink" href="#id319" title="Link to this heading">#</a></h4>
<ul class="simple">
<li><p><strong>array</strong>: Array expression. Can be a constant, column, or function, and any combination of array operators.</p></li>
<li><p><strong>scalar</strong>: Numeric scalar to multiply each element by. Can be a constant or column expression.</p></li>
</ul>
</section>
-<section id="id317">
-<h4>Example<a class="headerlink" href="#id317" title="Link to this heading">#</a></h4>
+<section id="id320">
+<h4>Example<a class="headerlink" href="#id320" title="Link to this heading">#</a></h4>
<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="o">></span><span class="w"> </span><span class="k">select</span><span class="w"> </span><span class="n">array_scale</span><span class="p">([</span><span class="mi">1</span><span class="p">.</span><span class="mi">0</span><span class="p">,</span><span class="w"> </span><span class="mi">2</span><span class="p">.</span><span class="mi">0</span><span class="p">,</span><span class="w"> </span><span [...]
<span class="o">+</span><span class="c1">----------------------------------+</span>
<span class="o">|</span><span class="w"> </span><span class="n">array_scale</span><span class="p">(</span><span class="n">List</span><span class="p">([</span><span class="mi">1</span><span class="p">.</span><span class="mi">0</span><span class="p">,</span><span class="mi">2</span><span class="p">.</span><span class="mi">0</span><span class="p">,</span><span class="mi">3</span><span class="p">.</span><span class="mi">0</span><span class="p">]),</span><span class="n">Float64</span><span cl [...]
@@ -5098,8 +5130,8 @@ Integers, unsigned integers, and floats are interpreted as seconds since the uni
</pre></div>
</div>
</section>
-<section id="id318">
-<h4>Aliases<a class="headerlink" href="#id318" title="Link to this heading">#</a></h4>
+<section id="id321">
+<h4>Aliases<a class="headerlink" href="#id321" title="Link to this heading">#</a></h4>
<ul class="simple">
<li><p>list_scale</p></li>
</ul>
@@ -5111,8 +5143,8 @@ Integers, unsigned integers, and floats are interpreted as seconds since the uni
<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="n">array_slice</span><span class="p">(</span><span class="nb">array</span><span class="p">,</span><span class="w"> </span><span class="k">begin</span><span class="p">,</span><span class="w"> </span><span class="k">end</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id319">
-<h4>Arguments<a class="headerlink" href="#id319" title="Link to this heading">#</a></h4>
+<section id="id322">
+<h4>Arguments<a class="headerlink" href="#id322" title="Link to this heading">#</a></h4>
<ul class="simple">
<li><p><strong>array</strong>: Array expression. Can be a constant, column, or function, and any combination of array operators.</p></li>
<li><p><strong>begin</strong>: Index of the first element. If negative, it counts backward from the end of the array.</p></li>
@@ -5120,8 +5152,8 @@ Integers, unsigned integers, and floats are interpreted as seconds since the uni
<li><p><strong>stride</strong>: Stride of the array slice. The default is 1.</p></li>
</ul>
</section>
-<section id="id320">
-<h4>Example<a class="headerlink" href="#id320" title="Link to this heading">#</a></h4>
+<section id="id323">
+<h4>Example<a class="headerlink" href="#id323" title="Link to this heading">#</a></h4>
<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="o">></span><span class="w"> </span><span class="k">select</span><span class="w"> </span><span class="n">array_slice</span><span class="p">([</span><span class="mi">1</span><span class="p">,</span><span class="w"> </span><span class="mi">2</span><span class="p">,</span><span class="w"> </span><span class="mi">3</span><span class="p">,</span><span class="w"> </span><span class="mi">4</span><span [...]
<span class="o">+</span><span class="c1">--------------------------------------------------------+</span>
<span class="o">|</span><span class="w"> </span><span class="n">array_slice</span><span class="p">(</span><span class="n">List</span><span class="p">([</span><span class="mi">1</span><span class="p">,</span><span class="mi">2</span><span class="p">,</span><span class="mi">3</span><span class="p">,</span><span class="mi">4</span><span class="p">,</span><span class="mi">5</span><span class="p">,</span><span class="mi">6</span><span class="p">,</span><span class="mi">7</span><span class="p" [...]
@@ -5131,8 +5163,8 @@ Integers, unsigned integers, and floats are interpreted as seconds since the uni
</pre></div>
</div>
</section>
-<section id="id321">
-<h4>Aliases<a class="headerlink" href="#id321" title="Link to this heading">#</a></h4>
+<section id="id324">
+<h4>Aliases<a class="headerlink" href="#id324" title="Link to this heading">#</a></h4>
<ul class="simple">
<li><p>list_slice</p></li>
</ul>
@@ -5144,16 +5176,16 @@ Integers, unsigned integers, and floats are interpreted as seconds since the uni
<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="n">array_sort</span><span class="p">(</span><span class="nb">array</span><span class="p">,</span><span class="w"> </span><span class="k">desc</span><span class="p">,</span><span class="w"> </span><span class="n">nulls_first</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id322">
-<h4>Arguments<a class="headerlink" href="#id322" title="Link to this heading">#</a></h4>
+<section id="id325">
+<h4>Arguments<a class="headerlink" href="#id325" title="Link to this heading">#</a></h4>
<ul class="simple">
<li><p><strong>array</strong>: Array expression. Can be a constant, column, or function, and any combination of array operators.</p></li>
<li><p><strong>desc</strong>: Whether to sort in ascending (<code class="docutils literal notranslate"><span class="pre">ASC</span></code>) or descending (<code class="docutils literal notranslate"><span class="pre">DESC</span></code>) order. The default is <code class="docutils literal notranslate"><span class="pre">ASC</span></code>.</p></li>
<li><p><strong>nulls_first</strong>: Whether to sort nulls first (<code class="docutils literal notranslate"><span class="pre">NULLS</span> <span class="pre">FIRST</span></code>) or last (<code class="docutils literal notranslate"><span class="pre">NULLS</span> <span class="pre">LAST</span></code>). The default is <code class="docutils literal notranslate"><span class="pre">NULLS</span> <span class="pre">FIRST</span></code>.</p></li>
</ul>
</section>
-<section id="id323">
-<h4>Example<a class="headerlink" href="#id323" title="Link to this heading">#</a></h4>
+<section id="id326">
+<h4>Example<a class="headerlink" href="#id326" title="Link to this heading">#</a></h4>
<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="o">></span><span class="w"> </span><span class="k">select</span><span class="w"> </span><span class="n">array_sort</span><span class="p">([</span><span class="mi">3</span><span class="p">,</span><span class="w"> </span><span class="mi">1</span><span class="p">,</span><span class="w"> </span><span class="mi">2</span><span class="p">]);</span>
<span class="o">+</span><span class="c1">-----------------------------+</span>
<span class="o">|</span><span class="w"> </span><span class="n">array_sort</span><span class="p">(</span><span class="n">List</span><span class="p">([</span><span class="mi">3</span><span class="p">,</span><span class="mi">1</span><span class="p">,</span><span class="mi">2</span><span class="p">]))</span><span class="w"> </span><span class="o">|</span>
@@ -5163,8 +5195,8 @@ Integers, unsigned integers, and floats are interpreted as seconds since the uni
</pre></div>
</div>
</section>
-<section id="id324">
-<h4>Aliases<a class="headerlink" href="#id324" title="Link to this heading">#</a></h4>
+<section id="id327">
+<h4>Aliases<a class="headerlink" href="#id327" title="Link to this heading">#</a></h4>
<ul class="simple">
<li><p>list_sort</p></li>
</ul>
@@ -5176,15 +5208,15 @@ Integers, unsigned integers, and floats are interpreted as seconds since the uni
<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="n">array_subtract</span><span class="p">(</span><span class="n">array1</span><span class="p">,</span><span class="w"> </span><span class="n">array2</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id325">
-<h4>Arguments<a class="headerlink" href="#id325" title="Link to this heading">#</a></h4>
+<section id="id328">
+<h4>Arguments<a class="headerlink" href="#id328" title="Link to this heading">#</a></h4>
<ul class="simple">
<li><p><strong>array1</strong>: Array expression. Can be a constant, column, or function, and any combination of array operators.</p></li>
<li><p><strong>array2</strong>: Array expression. Can be a constant, column, or function, and any combination of array operators.</p></li>
</ul>
</section>
-<section id="id326">
-<h4>Example<a class="headerlink" href="#id326" title="Link to this heading">#</a></h4>
+<section id="id329">
+<h4>Example<a class="headerlink" href="#id329" title="Link to this heading">#</a></h4>
<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="o">></span><span class="w"> </span><span class="k">select</span><span class="w"> </span><span class="n">array_subtract</span><span class="p">([</span><span class="mi">10</span><span class="p">.</span><span class="mi">0</span><span class="p">,</span><span class="w"> </span><span class="mi">20</span><span class="p">.</span><span class="mi">0</span><span class="p">,</span><span class="w"> </span> [...]
<span class="o">+</span><span class="c1">--------------------------------------------------------------+</span>
<span class="o">|</span><span class="w"> </span><span class="n">array_subtract</span><span class="p">(</span><span class="n">List</span><span class="p">([</span><span class="mi">10</span><span class="p">.</span><span class="mi">0</span><span class="p">,</span><span class="mi">20</span><span class="p">.</span><span class="mi">0</span><span class="p">,</span><span class="mi">30</span><span class="p">.</span><span class="mi">0</span><span class="p">]),</span><span class="n">List</span><span [...]
@@ -5194,8 +5226,8 @@ Integers, unsigned integers, and floats are interpreted as seconds since the uni
</pre></div>
</div>
</section>
-<section id="id327">
-<h4>Aliases<a class="headerlink" href="#id327" title="Link to this heading">#</a></h4>
+<section id="id330">
+<h4>Aliases<a class="headerlink" href="#id330" title="Link to this heading">#</a></h4>
<ul class="simple">
<li><p>list_subtract</p></li>
</ul>
@@ -5207,16 +5239,16 @@ Integers, unsigned integers, and floats are interpreted as seconds since the uni
<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="n">array_to_string</span><span class="p">(</span><span class="nb">array</span><span class="p">,</span><span class="w"> </span><span class="k">delimiter</span><span class="p">[,</span><span class="w"> </span><span class="n">null_string</span><span class="p">])</span>
</pre></div>
</div>
-<section id="id328">
-<h4>Arguments<a class="headerlink" href="#id328" title="Link to this heading">#</a></h4>
+<section id="id331">
+<h4>Arguments<a class="headerlink" href="#id331" title="Link to this heading">#</a></h4>
<ul class="simple">
<li><p><strong>array</strong>: Array expression. Can be a constant, column, or function, and any combination of array operators.</p></li>
<li><p><strong>delimiter</strong>: Array element separator.</p></li>
<li><p><strong>null_string</strong>: Optional. String to use for null values in the output. If not provided, nulls will be omitted.</p></li>
</ul>
</section>
-<section id="id329">
-<h4>Example<a class="headerlink" href="#id329" title="Link to this heading">#</a></h4>
+<section id="id332">
+<h4>Example<a class="headerlink" href="#id332" title="Link to this heading">#</a></h4>
<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="o">></span><span class="w"> </span><span class="k">select</span><span class="w"> </span><span class="n">array_to_string</span><span class="p">([[</span><span class="mi">1</span><span class="p">,</span><span class="w"> </span><span class="mi">2</span><span class="p">,</span><span class="w"> </span><span class="mi">3</span><span class="p">,</span><span class="w"> </span><span class="mi">4</span> [...]
<span class="o">+</span><span class="c1">----------------------------------------------------+</span>
<span class="o">|</span><span class="w"> </span><span class="n">array_to_string</span><span class="p">(</span><span class="n">List</span><span class="p">([</span><span class="mi">1</span><span class="p">,</span><span class="mi">2</span><span class="p">,</span><span class="mi">3</span><span class="p">,</span><span class="mi">4</span><span class="p">,</span><span class="mi">5</span><span class="p">,</span><span class="mi">6</span><span class="p">,</span><span class="mi">7</span><span class [...]
@@ -5226,8 +5258,8 @@ Integers, unsigned integers, and floats are interpreted as seconds since the uni
</pre></div>
</div>
</section>
-<section id="id330">
-<h4>Aliases<a class="headerlink" href="#id330" title="Link to this heading">#</a></h4>
+<section id="id333">
+<h4>Aliases<a class="headerlink" href="#id333" title="Link to this heading">#</a></h4>
<ul class="simple">
<li><p>list_to_string</p></li>
<li><p>array_join</p></li>
@@ -5241,15 +5273,15 @@ Integers, unsigned integers, and floats are interpreted as seconds since the uni
<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="n">array_transform</span><span class="p">(</span><span class="nb">array</span><span class="p">,</span><span class="w"> </span><span class="n">x</span><span class="w"> </span><span class="o">-></span><span class="w"> </span><span class="n">x</span><span class="o">*</span><span class="mi">2</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id331">
-<h4>Arguments<a class="headerlink" href="#id331" title="Link to this heading">#</a></h4>
+<section id="id334">
+<h4>Arguments<a class="headerlink" href="#id334" title="Link to this heading">#</a></h4>
<ul class="simple">
<li><p><strong>array</strong>: Array expression. Can be a constant, column, or function, and any combination of array operators.</p></li>
<li><p><strong>lambda</strong>: Lambda</p></li>
</ul>
</section>
-<section id="id332">
-<h4>Example<a class="headerlink" href="#id332" title="Link to this heading">#</a></h4>
+<section id="id335">
+<h4>Example<a class="headerlink" href="#id335" title="Link to this heading">#</a></h4>
<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="o">></span><span class="w"> </span><span class="k">select</span><span class="w"> </span><span class="n">array_transform</span><span class="p">([</span><span class="mi">1</span><span class="p">,</span><span class="w"> </span><span class="mi">2</span><span class="p">,</span><span class="w"> </span><span class="mi">3</span><span class="p">,</span><span class="w"> </span><span class="mi">4</span>< [...]
<span class="o">+</span><span class="c1">-------------------------------------------+</span>
<span class="o">|</span><span class="w"> </span><span class="n">array_transform</span><span class="p">([</span><span class="mi">1</span><span class="p">,</span><span class="w"> </span><span class="mi">2</span><span class="p">,</span><span class="w"> </span><span class="mi">3</span><span class="p">,</span><span class="w"> </span><span class="mi">4</span><span class="p">,</span><span class="w"> </span><span class="mi">5</span><span class="p">],</span><span class="w"> </span><span class="n" [...]
@@ -5259,8 +5291,8 @@ Integers, unsigned integers, and floats are interpreted as seconds since the uni
</pre></div>
</div>
</section>
-<section id="id333">
-<h4>Aliases<a class="headerlink" href="#id333" title="Link to this heading">#</a></h4>
+<section id="id336">
+<h4>Aliases<a class="headerlink" href="#id336" title="Link to this heading">#</a></h4>
<ul class="simple">
<li><p>list_transform</p></li>
</ul>
@@ -5272,15 +5304,15 @@ Integers, unsigned integers, and floats are interpreted as seconds since the uni
<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="n">array_union</span><span class="p">(</span><span class="n">array1</span><span class="p">,</span><span class="w"> </span><span class="n">array2</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id334">
-<h4>Arguments<a class="headerlink" href="#id334" title="Link to this heading">#</a></h4>
+<section id="id337">
+<h4>Arguments<a class="headerlink" href="#id337" title="Link to this heading">#</a></h4>
<ul class="simple">
<li><p><strong>array1</strong>: Array expression. Can be a constant, column, or function, and any combination of array operators.</p></li>
<li><p><strong>array2</strong>: Array expression. Can be a constant, column, or function, and any combination of array operators.</p></li>
</ul>
</section>
-<section id="id335">
-<h4>Example<a class="headerlink" href="#id335" title="Link to this heading">#</a></h4>
+<section id="id338">
+<h4>Example<a class="headerlink" href="#id338" title="Link to this heading">#</a></h4>
<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="o">></span><span class="w"> </span><span class="k">select</span><span class="w"> </span><span class="n">array_union</span><span class="p">([</span><span class="mi">1</span><span class="p">,</span><span class="w"> </span><span class="mi">2</span><span class="p">,</span><span class="w"> </span><span class="mi">3</span><span class="p">,</span><span class="w"> </span><span class="mi">4</span><span [...]
<span class="o">+</span><span class="c1">----------------------------------------------------+</span>
<span class="o">|</span><span class="w"> </span><span class="n">array_union</span><span class="p">([</span><span class="mi">1</span><span class="p">,</span><span class="w"> </span><span class="mi">2</span><span class="p">,</span><span class="w"> </span><span class="mi">3</span><span class="p">,</span><span class="w"> </span><span class="mi">4</span><span class="p">],</span><span class="w"> </span><span class="p">[</span><span class="mi">5</span><span class="p">,</span><span class="w"> </ [...]
@@ -5296,8 +5328,8 @@ Integers, unsigned integers, and floats are interpreted as seconds since the uni
</pre></div>
</div>
</section>
-<section id="id336">
-<h4>Aliases<a class="headerlink" href="#id336" title="Link to this heading">#</a></h4>
+<section id="id339">
+<h4>Aliases<a class="headerlink" href="#id339" title="Link to this heading">#</a></h4>
<ul class="simple">
<li><p>list_union</p></li>
</ul>
@@ -5313,15 +5345,15 @@ Integers, unsigned integers, and floats are interpreted as seconds since the uni
<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="n">arrays_zip</span><span class="p">(</span><span class="n">array1</span><span class="p">[,</span><span class="w"> </span><span class="p">...,</span><span class="w"> </span><span class="n">array_n</span><span class="p">])</span>
</pre></div>
</div>
-<section id="id337">
-<h4>Arguments<a class="headerlink" href="#id337" title="Link to this heading">#</a></h4>
+<section id="id340">
+<h4>Arguments<a class="headerlink" href="#id340" title="Link to this heading">#</a></h4>
<ul class="simple">
<li><p><strong>array1</strong>: First array expression.</p></li>
<li><p><strong>array_n</strong>: Optional additional array expressions.</p></li>
</ul>
</section>
-<section id="id338">
-<h4>Example<a class="headerlink" href="#id338" title="Link to this heading">#</a></h4>
+<section id="id341">
+<h4>Example<a class="headerlink" href="#id341" title="Link to this heading">#</a></h4>
<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="o">></span><span class="w"> </span><span class="k">select</span><span class="w"> </span><span class="n">arrays_zip</span><span class="p">([</span><span class="mi">1</span><span class="p">,</span><span class="w"> </span><span class="mi">2</span><span class="p">,</span><span class="w"> </span><span class="mi">3</span><span class="p">]);</span>
<span class="o">+</span><span class="c1">---------------------------------------------------+</span>
<span class="o">|</span><span class="w"> </span><span class="n">arrays_zip</span><span class="p">([</span><span class="mi">1</span><span class="p">,</span><span class="w"> </span><span class="mi">2</span><span class="p">,</span><span class="w"> </span><span class="mi">3</span><span class="p">])</span><span class="w"> </span><span class="o">|</span>
@@ -5337,8 +5369,8 @@ Integers, unsigned integers, and floats are interpreted as seconds since the uni
</pre></div>
</div>
</section>
-<section id="id339">
-<h4>Aliases<a class="headerlink" href="#id339" title="Link to this heading">#</a></h4>
+<section id="id342">
+<h4>Aliases<a class="headerlink" href="#id342" title="Link to this heading">#</a></h4>
<ul class="simple">
<li><p>list_zip</p></li>
</ul>
@@ -5350,14 +5382,14 @@ Integers, unsigned integers, and floats are interpreted as seconds since the uni
<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="k">cardinality</span><span class="p">(</span><span class="nb">array</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id340">
-<h4>Arguments<a class="headerlink" href="#id340" title="Link to this heading">#</a></h4>
+<section id="id343">
+<h4>Arguments<a class="headerlink" href="#id343" title="Link to this heading">#</a></h4>
<ul class="simple">
<li><p><strong>array</strong>: Array expression. Can be a constant, column, or function, and any combination of array operators.</p></li>
</ul>
</section>
-<section id="id341">
-<h4>Example<a class="headerlink" href="#id341" title="Link to this heading">#</a></h4>
+<section id="id344">
+<h4>Example<a class="headerlink" href="#id344" title="Link to this heading">#</a></h4>
<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="o">></span><span class="w"> </span><span class="k">select</span><span class="w"> </span><span class="k">cardinality</span><span class="p">([[</span><span class="mi">1</span><span class="p">,</span><span class="w"> </span><span class="mi">2</span><span class="p">,</span><span class="w"> </span><span class="mi">3</span><span class="p">,</span><span class="w"> </span><span class="mi">4</span><spa [...]
<span class="o">+</span><span class="c1">--------------------------------------+</span>
<span class="o">|</span><span class="w"> </span><span class="k">cardinality</span><span class="p">(</span><span class="n">List</span><span class="p">([</span><span class="mi">1</span><span class="p">,</span><span class="mi">2</span><span class="p">,</span><span class="mi">3</span><span class="p">,</span><span class="mi">4</span><span class="p">,</span><span class="mi">5</span><span class="p">,</span><span class="mi">6</span><span class="p">,</span><span class="mi">7</span><span class="p" [...]
@@ -5374,15 +5406,15 @@ Integers, unsigned integers, and floats are interpreted as seconds since the uni
<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="n">cosine_distance</span><span class="p">(</span><span class="n">array1</span><span class="p">,</span><span class="w"> </span><span class="n">array2</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id342">
-<h4>Arguments<a class="headerlink" href="#id342" title="Link to this heading">#</a></h4>
+<section id="id345">
+<h4>Arguments<a class="headerlink" href="#id345" title="Link to this heading">#</a></h4>
<ul class="simple">
<li><p><strong>array1</strong>: Array expression. Can be a constant, column, or function, and any combination of array operators.</p></li>
<li><p><strong>array2</strong>: Array expression. Can be a constant, column, or function, and any combination of array operators.</p></li>
</ul>
</section>
-<section id="id343">
-<h4>Example<a class="headerlink" href="#id343" title="Link to this heading">#</a></h4>
+<section id="id346">
+<h4>Example<a class="headerlink" href="#id346" title="Link to this heading">#</a></h4>
<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="o">></span><span class="w"> </span><span class="k">select</span><span class="w"> </span><span class="n">cosine_distance</span><span class="p">([</span><span class="mi">1</span><span class="p">.</span><span class="mi">0</span><span class="p">,</span><span class="w"> </span><span class="mi">0</span><span class="p">.</span><span class="mi">0</span><span class="p">],</span><span class="w"> </span> [...]
<span class="o">+</span><span class="c1">-----------------------------------------------+</span>
<span class="o">|</span><span class="w"> </span><span class="n">cosine_distance</span><span class="p">(</span><span class="n">List</span><span class="p">([</span><span class="mi">1</span><span class="p">.</span><span class="mi">0</span><span class="p">,</span><span class="mi">0</span><span class="p">.</span><span class="mi">0</span><span class="p">]),</span><span class="n">List</span><span class="p">([</span><span class="mi">0</span><span class="p">.</span><span class="mi">0</span><span [...]
@@ -5403,14 +5435,14 @@ Integers, unsigned integers, and floats are interpreted as seconds since the uni
<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="n">empty</span><span class="p">(</span><span class="nb">array</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id344">
-<h4>Arguments<a class="headerlink" href="#id344" title="Link to this heading">#</a></h4>
+<section id="id347">
+<h4>Arguments<a class="headerlink" href="#id347" title="Link to this heading">#</a></h4>
<ul class="simple">
<li><p><strong>array</strong>: Array expression. Can be a constant, column, or function, and any combination of array operators.</p></li>
</ul>
</section>
-<section id="id345">
-<h4>Example<a class="headerlink" href="#id345" title="Link to this heading">#</a></h4>
+<section id="id348">
+<h4>Example<a class="headerlink" href="#id348" title="Link to this heading">#</a></h4>
<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="o">></span><span class="w"> </span><span class="k">select</span><span class="w"> </span><span class="n">empty</span><span class="p">([</span><span class="mi">1</span><span class="p">]);</span>
<span class="o">+</span><span class="c1">------------------+</span>
<span class="o">|</span><span class="w"> </span><span class="n">empty</span><span class="p">(</span><span class="n">List</span><span class="p">([</span><span class="mi">1</span><span class="p">]))</span><span class="w"> </span><span class="o">|</span>
@@ -5420,8 +5452,8 @@ Integers, unsigned integers, and floats are interpreted as seconds since the uni
</pre></div>
</div>
</section>
-<section id="id346">
-<h4>Aliases<a class="headerlink" href="#id346" title="Link to this heading">#</a></h4>
+<section id="id349">
+<h4>Aliases<a class="headerlink" href="#id349" title="Link to this heading">#</a></h4>
<ul class="simple">
<li><p>array_empty</p></li>
<li><p>list_empty</p></li>
@@ -5439,14 +5471,14 @@ Integers, unsigned integers, and floats are interpreted as seconds since the uni
<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="n">flatten</span><span class="p">(</span><span class="nb">array</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id347">
-<h4>Arguments<a class="headerlink" href="#id347" title="Link to this heading">#</a></h4>
+<section id="id350">
+<h4>Arguments<a class="headerlink" href="#id350" title="Link to this heading">#</a></h4>
<ul class="simple">
<li><p><strong>array</strong>: Array expression. Can be a constant, column, or function, and any combination of array operators.</p></li>
</ul>
</section>
-<section id="id348">
-<h4>Example<a class="headerlink" href="#id348" title="Link to this heading">#</a></h4>
+<section id="id351">
+<h4>Example<a class="headerlink" href="#id351" title="Link to this heading">#</a></h4>
<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="o">></span><span class="w"> </span><span class="k">select</span><span class="w"> </span><span class="n">flatten</span><span class="p">([[</span><span class="mi">1</span><span class="p">,</span><span class="w"> </span><span class="mi">2</span><span class="p">],</span><span class="w"> </span><span class="p">[</span><span class="mi">3</span><span class="p">,</span><span class="w"> </span><span cl [...]
<span class="o">+</span><span class="c1">------------------------------+</span>
<span class="o">|</span><span class="w"> </span><span class="n">flatten</span><span class="p">(</span><span class="n">List</span><span class="p">([</span><span class="mi">1</span><span class="p">,</span><span class="mi">2</span><span class="p">],</span><span class="w"> </span><span class="p">[</span><span class="mi">3</span><span class="p">,</span><span class="mi">4</span><span class="p">]))</span><span class="w"> </span><span class="o">|</span>
@@ -5464,16 +5496,16 @@ Integers, unsigned integers, and floats are interpreted as seconds since the uni
<span class="n">generate_series</span><span class="p">(</span><span class="k">start</span><span class="p">,</span><span class="w"> </span><span class="n">stop</span><span class="p">[,</span><span class="w"> </span><span class="n">step</span><span class="p">])</span>
</pre></div>
</div>
-<section id="id349">
-<h4>Arguments<a class="headerlink" href="#id349" title="Link to this heading">#</a></h4>
+<section id="id352">
+<h4>Arguments<a class="headerlink" href="#id352" title="Link to this heading">#</a></h4>
<ul class="simple">
<li><p><strong>start</strong>: Start of the series. Ints, timestamps, dates or string types that can be coerced to Date32 are supported.</p></li>
<li><p><strong>end</strong>: End of the series (included). Type must be the same as start.</p></li>
<li><p><strong>step</strong>: Increase by step (can not be 0). Steps less than a day are supported only for timestamp ranges.</p></li>
</ul>
</section>
-<section id="id350">
-<h4>Example<a class="headerlink" href="#id350" title="Link to this heading">#</a></h4>
+<section id="id353">
+<h4>Example<a class="headerlink" href="#id353" title="Link to this heading">#</a></h4>
<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="o">></span><span class="w"> </span><span class="k">select</span><span class="w"> </span><span class="n">generate_series</span><span class="p">(</span><span class="mi">1</span><span class="p">,</span><span class="mi">3</span><span class="p">);</span>
<span class="o">+</span><span class="c1">------------------------------------+</span>
<span class="o">|</span><span class="w"> </span><span class="n">generate_series</span><span class="p">(</span><span class="n">Int64</span><span class="p">(</span><span class="mi">1</span><span class="p">),</span><span class="n">Int64</span><span class="p">(</span><span class="mi">3</span><span class="p">))</span><span class="w"> </span><span class="o">|</span>
@@ -5490,15 +5522,15 @@ Integers, unsigned integers, and floats are interpreted as seconds since the uni
<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="n">inner_product</span><span class="p">(</span><span class="n">array1</span><span class="p">,</span><span class="w"> </span><span class="n">array2</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id351">
-<h4>Arguments<a class="headerlink" href="#id351" title="Link to this heading">#</a></h4>
+<section id="id354">
+<h4>Arguments<a class="headerlink" href="#id354" title="Link to this heading">#</a></h4>
<ul class="simple">
<li><p><strong>array1</strong>: Array expression. Can be a constant, column, or function, and any combination of array operators.</p></li>
<li><p><strong>array2</strong>: Array expression. Can be a constant, column, or function, and any combination of array operators.</p></li>
</ul>
</section>
-<section id="id352">
-<h4>Example<a class="headerlink" href="#id352" title="Link to this heading">#</a></h4>
+<section id="id355">
+<h4>Example<a class="headerlink" href="#id355" title="Link to this heading">#</a></h4>
<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="o">></span><span class="w"> </span><span class="k">select</span><span class="w"> </span><span class="n">inner_product</span><span class="p">([</span><span class="mi">1</span><span class="p">.</span><span class="mi">0</span><span class="p">,</span><span class="w"> </span><span class="mi">2</span><span class="p">.</span><span class="mi">0</span><span class="p">,</span><span class="w"> </span><sp [...]
<span class="o">+</span><span class="c1">-------------------------------------------------------+</span>
<span class="o">|</span><span class="w"> </span><span class="n">inner_product</span><span class="p">(</span><span class="n">List</span><span class="p">([</span><span class="mi">1</span><span class="p">.</span><span class="mi">0</span><span class="p">,</span><span class="mi">2</span><span class="p">.</span><span class="mi">0</span><span class="p">,</span><span class="mi">3</span><span class="p">.</span><span class="mi">0</span><span class="p">]),</span><span class="n">List</span><span cla [...]
@@ -5508,8 +5540,8 @@ Integers, unsigned integers, and floats are interpreted as seconds since the uni
</pre></div>
</div>
</section>
-<section id="id353">
-<h4>Aliases<a class="headerlink" href="#id353" title="Link to this heading">#</a></h4>
+<section id="id356">
+<h4>Aliases<a class="headerlink" href="#id356" title="Link to this heading">#</a></h4>
<ul class="simple">
<li><p>dot_product</p></li>
</ul>
@@ -5639,6 +5671,10 @@ Integers, unsigned integers, and floats are interpreted as seconds since the uni
<h3><code class="docutils literal notranslate"><span class="pre">list_prepend</span></code><a class="headerlink" href="#list-prepend" title="Link to this heading">#</a></h3>
<p><em>Alias of <a class="reference internal" href="#array-prepend">array_prepend</a>.</em></p>
</section>
+<section id="list-product">
+<h3><code class="docutils literal notranslate"><span class="pre">list_product</span></code><a class="headerlink" href="#list-product" title="Link to this heading">#</a></h3>
+<p><em>Alias of <a class="reference internal" href="#array-product">array_product</a>.</em></p>
+</section>
<section id="list-push-back">
<h3><code class="docutils literal notranslate"><span class="pre">list_push_back</span></code><a class="headerlink" href="#list-push-back" title="Link to this heading">#</a></h3>
<p><em>Alias of <a class="reference internal" href="#array-append">array_append</a>.</em></p>
@@ -5721,14 +5757,14 @@ Integers, unsigned integers, and floats are interpreted as seconds since the uni
<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="n">make_array</span><span class="p">(</span><span class="n">expression1</span><span class="p">[,</span><span class="w"> </span><span class="p">...,</span><span class="w"> </span><span class="n">expression_n</span><span class="p">])</span>
</pre></div>
</div>
-<section id="id354">
-<h4>Arguments<a class="headerlink" href="#id354" title="Link to this heading">#</a></h4>
+<section id="id357">
+<h4>Arguments<a class="headerlink" href="#id357" title="Link to this heading">#</a></h4>
<ul class="simple">
<li><p><strong>expression_n</strong>: Expression to include in the output array. Can be a constant, column, or function, and any combination of arithmetic or string operators.</p></li>
</ul>
</section>
-<section id="id355">
-<h4>Example<a class="headerlink" href="#id355" title="Link to this heading">#</a></h4>
+<section id="id358">
+<h4>Example<a class="headerlink" href="#id358" title="Link to this heading">#</a></h4>
<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="o">></span><span class="w"> </span><span class="k">select</span><span class="w"> </span><span class="n">make_array</span><span class="p">(</span><span class="mi">1</span><span class="p">,</span><span class="w"> </span><span class="mi">2</span><span class="p">,</span><span class="w"> </span><span class="mi">3</span><span class="p">,</span><span class="w"> </span><span class="mi">4</span><span c [...]
<span class="o">+</span><span class="c1">----------------------------------------------------------+</span>
<span class="o">|</span><span class="w"> </span><span class="n">make_array</span><span class="p">(</span><span class="n">Int64</span><span class="p">(</span><span class="mi">1</span><span class="p">),</span><span class="n">Int64</span><span class="p">(</span><span class="mi">2</span><span class="p">),</span><span class="n">Int64</span><span class="p">(</span><span class="mi">3</span><span class="p">),</span><span class="n">Int64</span><span class="p">(</span><span class="mi">4</span><spa [...]
@@ -5738,8 +5774,8 @@ Integers, unsigned integers, and floats are interpreted as seconds since the uni
</pre></div>
</div>
</section>
-<section id="id356">
-<h4>Aliases<a class="headerlink" href="#id356" title="Link to this heading">#</a></h4>
+<section id="id359">
+<h4>Aliases<a class="headerlink" href="#id359" title="Link to this heading">#</a></h4>
<ul class="simple">
<li><p>make_list</p></li>
</ul>
@@ -5756,16 +5792,16 @@ Integers, unsigned integers, and floats are interpreted as seconds since the uni
<span class="n">range</span><span class="p">(</span><span class="k">start</span><span class="p">,</span><span class="w"> </span><span class="n">stop</span><span class="p">[,</span><span class="w"> </span><span class="n">step</span><span class="p">])</span>
</pre></div>
</div>
-<section id="id357">
-<h4>Arguments<a class="headerlink" href="#id357" title="Link to this heading">#</a></h4>
+<section id="id360">
+<h4>Arguments<a class="headerlink" href="#id360" title="Link to this heading">#</a></h4>
<ul class="simple">
<li><p><strong>start</strong>: Start of the range. Ints, timestamps, dates or string types that can be coerced to Date32 are supported.</p></li>
<li><p><strong>end</strong>: End of the range (not included). Type must be the same as start.</p></li>
<li><p><strong>step</strong>: Increase by step (cannot be 0). Steps less than a day are supported only for timestamp ranges.</p></li>
</ul>
</section>
-<section id="id358">
-<h4>Example<a class="headerlink" href="#id358" title="Link to this heading">#</a></h4>
+<section id="id361">
+<h4>Example<a class="headerlink" href="#id361" title="Link to this heading">#</a></h4>
<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="o">></span><span class="w"> </span><span class="k">select</span><span class="w"> </span><span class="n">range</span><span class="p">(</span><span class="mi">2</span><span class="p">,</span><span class="w"> </span><span class="mi">10</span><span class="p">,</span><span class="w"> </span><span class="mi">3</span><span class="p">);</span>
<span class="o">+</span><span class="c1">-----------------------------------+</span>
<span class="o">|</span><span class="w"> </span><span class="n">range</span><span class="p">(</span><span class="n">Int64</span><span class="p">(</span><span class="mi">2</span><span class="p">),</span><span class="n">Int64</span><span class="p">(</span><span class="mi">10</span><span class="p">),</span><span class="n">Int64</span><span class="p">(</span><span class="mi">3</span><span class="p">))</span><span class="o">|</span>
@@ -5789,16 +5825,16 @@ Integers, unsigned integers, and floats are interpreted as seconds since the uni
<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="n">string_to_array</span><span class="p">(</span><span class="n">str</span><span class="p">,</span><span class="w"> </span><span class="k">delimiter</span><span class="p">[,</span><span class="w"> </span><span class="n">null_str</span><span class="p">])</span>
</pre></div>
</div>
-<section id="id359">
-<h4>Arguments<a class="headerlink" href="#id359" title="Link to this heading">#</a></h4>
+<section id="id362">
+<h4>Arguments<a class="headerlink" href="#id362" title="Link to this heading">#</a></h4>
<ul class="simple">
<li><p><strong>str</strong>: String expression to split.</p></li>
<li><p><strong>delimiter</strong>: Delimiter string to split on.</p></li>
<li><p><strong>null_str</strong>: Substring values to be replaced with <code class="docutils literal notranslate"><span class="pre">NULL</span></code>.</p></li>
</ul>
</section>
-<section id="id360">
-<h4>Example<a class="headerlink" href="#id360" title="Link to this heading">#</a></h4>
+<section id="id363">
+<h4>Example<a class="headerlink" href="#id363" title="Link to this heading">#</a></h4>
<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="o">></span><span class="w"> </span><span class="k">select</span><span class="w"> </span><span class="n">string_to_array</span><span class="p">(</span><span class="s1">'abc##def'</span><span class="p">,</span><span class="w"> </span><span class="s1">'##'</span><span class="p">);</span>
<span class="o">+</span><span class="c1">-----------------------------------+</span>
<span class="o">|</span><span class="w"> </span><span class="n">string_to_array</span><span class="p">(</span><span class="n">Utf8</span><span class="p">(</span><span class="s1">'abc##def'</span><span class="p">))</span><span class="w"> </span><span class="o">|</span>
@@ -5814,8 +5850,8 @@ Integers, unsigned integers, and floats are interpreted as seconds since the uni
</pre></div>
</div>
</section>
-<section id="id361">
-<h4>Aliases<a class="headerlink" href="#id361" title="Link to this heading">#</a></h4>
+<section id="id364">
+<h4>Aliases<a class="headerlink" href="#id364" title="Link to this heading">#</a></h4>
<ul class="simple">
<li><p>string_to_list</p></li>
</ul>
@@ -5841,15 +5877,15 @@ see <a class="reference internal" href="struct_coercion.html#comparison-and-orde
<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="n">named_struct</span><span class="p">(</span><span class="n">expression1_name</span><span class="p">,</span><span class="w"> </span><span class="n">expression1_input</span><span class="p">[,</span><span class="w"> </span><span class="p">...,</span><span class="w"> </span><span class="n">expression_n_name</span><span class="p">,</span><span class="w"> </span><span class="n">expression_n_input</sp [...]
</pre></div>
</div>
-<section id="id362">
-<h4>Arguments<a class="headerlink" href="#id362" title="Link to this heading">#</a></h4>
+<section id="id365">
+<h4>Arguments<a class="headerlink" href="#id365" title="Link to this heading">#</a></h4>
<ul class="simple">
<li><p><strong>expression_n_name</strong>: Name of the column field. Must be a constant string.</p></li>
<li><p><strong>expression_n_input</strong>: Expression to include in the output struct. Can be a constant, column, or function, and any combination of arithmetic or string operators.</p></li>
</ul>
</section>
-<section id="id363">
-<h4>Example<a class="headerlink" href="#id363" title="Link to this heading">#</a></h4>
+<section id="id366">
+<h4>Example<a class="headerlink" href="#id366" title="Link to this heading">#</a></h4>
<p>For example, this query converts two columns <code class="docutils literal notranslate"><span class="pre">a</span></code> and <code class="docutils literal notranslate"><span class="pre">b</span></code> to a single column with
a struct type of fields <code class="docutils literal notranslate"><span class="pre">field_a</span></code> and <code class="docutils literal notranslate"><span class="pre">field_b</span></code>:</p>
<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="o">></span><span class="w"> </span><span class="k">select</span><span class="w"> </span><span class="o">*</span><span class="w"> </span><span class="k">from</span><span class="w"> </span><span class="n">t</span><span class="p">;</span>
@@ -5884,14 +5920,14 @@ see <a class="reference internal" href="struct_coercion.html#comparison-and-orde
<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="n">struct</span><span class="p">(</span><span class="n">expression1</span><span class="p">[,</span><span class="w"> </span><span class="p">...,</span><span class="w"> </span><span class="n">expression_n</span><span class="p">])</span>
</pre></div>
</div>
-<section id="id364">
-<h4>Arguments<a class="headerlink" href="#id364" title="Link to this heading">#</a></h4>
+<section id="id367">
+<h4>Arguments<a class="headerlink" href="#id367" title="Link to this heading">#</a></h4>
<ul class="simple">
<li><p><strong>expression1, expression_n</strong>: Expression to include in the output struct. Can be a constant, column, or function, any combination of arithmetic or string operators.</p></li>
</ul>
</section>
-<section id="id365">
-<h4>Example<a class="headerlink" href="#id365" title="Link to this heading">#</a></h4>
+<section id="id368">
+<h4>Example<a class="headerlink" href="#id368" title="Link to this heading">#</a></h4>
<p>For example, this query converts two columns <code class="docutils literal notranslate"><span class="pre">a</span></code> and <code class="docutils literal notranslate"><span class="pre">b</span></code> to a single column with
a struct type of fields <code class="docutils literal notranslate"><span class="pre">field_a</span></code> and <code class="docutils literal notranslate"><span class="pre">c1</span></code>:</p>
<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="o">></span><span class="w"> </span><span class="k">select</span><span class="w"> </span><span class="o">*</span><span class="w"> </span><span class="k">from</span><span class="w"> </span><span class="n">t</span><span class="p">;</span>
@@ -5922,8 +5958,8 @@ a struct type of fields <code class="docutils literal notranslate"><span class="
</pre></div>
</div>
</section>
-<section id="id366">
-<h4>Aliases<a class="headerlink" href="#id366" title="Link to this heading">#</a></h4>
+<section id="id369">
+<h4>Aliases<a class="headerlink" href="#id369" title="Link to this heading">#</a></h4>
<ul class="simple">
<li><p>row</p></li>
</ul>
@@ -5953,8 +5989,8 @@ a struct type of fields <code class="docutils literal notranslate"><span class="
<span class="n">make_map</span><span class="p">([</span><span class="s1">'key1'</span><span class="p">,</span><span class="w"> </span><span class="s1">'key2'</span><span class="p">],</span><span class="w"> </span><span class="p">[</span><span class="s1">'value1'</span><span class="p">,</span><span class="w"> </span><span class="s1">'value2'</span><span class="p">])</span>
</pre></div>
</div>
-<section id="id367">
-<h4>Arguments<a class="headerlink" href="#id367" title="Link to this heading">#</a></h4>
+<section id="id370">
+<h4>Arguments<a class="headerlink" href="#id370" title="Link to this heading">#</a></h4>
<ul class="simple">
<li><p><strong>key</strong>: For <code class="docutils literal notranslate"><span class="pre">map</span></code>: Expression to be used for key. Can be a constant, column, function, or any combination of arithmetic or string operators.
For <code class="docutils literal notranslate"><span class="pre">make_map</span></code>: The list of keys to be used in the map. Each key must be unique and non-null.</p></li>
@@ -5962,8 +5998,8 @@ For <code class="docutils literal notranslate"><span class="pre">make_map</span>
For <code class="docutils literal notranslate"><span class="pre">make_map</span></code>: The list of values to be mapped to the corresponding keys.</p></li>
</ul>
</section>
-<section id="id368">
-<h4>Example<a class="headerlink" href="#id368" title="Link to this heading">#</a></h4>
+<section id="id371">
+<h4>Example<a class="headerlink" href="#id371" title="Link to this heading">#</a></h4>
<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="c1">-- Using map function</span>
<span class="k">SELECT</span><span class="w"> </span><span class="k">MAP</span><span class="p">(</span><span class="s1">'type'</span><span class="p">,</span><span class="w"> </span><span class="s1">'test'</span><span class="p">);</span>
<span class="c1">----</span>
@@ -5999,14 +6035,14 @@ For <code class="docutils literal notranslate"><span class="pre">make_map</span>
<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="n">map_entries</span><span class="p">(</span><span class="k">map</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id369">
-<h4>Arguments<a class="headerlink" href="#id369" title="Link to this heading">#</a></h4>
+<section id="id372">
+<h4>Arguments<a class="headerlink" href="#id372" title="Link to this heading">#</a></h4>
<ul class="simple">
<li><p><strong>map</strong>: Map expression. Can be a constant, column, or function, and any combination of map operators.</p></li>
</ul>
</section>
-<section id="id370">
-<h4>Example<a class="headerlink" href="#id370" title="Link to this heading">#</a></h4>
+<section id="id373">
+<h4>Example<a class="headerlink" href="#id373" title="Link to this heading">#</a></h4>
<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="k">SELECT</span><span class="w"> </span><span class="n">map_entries</span><span class="p">(</span><span class="k">MAP</span><span class="w"> </span><span class="err">{</span><span class="s1">'a'</span><span class="p">:</span><span class="w"> </span><span class="mi">1</span><span class="p">,</span><span class="w"> </span><span class="s1">'b'</span><span class="p">:</span><span clas [...]
<span class="c1">----</span>
<span class="p">[</span><span class="err">{</span><span class="s1">'key'</span><span class="p">:</span><span class="w"> </span><span class="n">a</span><span class="p">,</span><span class="w"> </span><span class="s1">'value'</span><span class="p">:</span><span class="w"> </span><span class="mi">1</span><span class="err">}</span><span class="p">,</span><span class="w"> </span><span class="err">{</span><span class="s1">'key'</span><span class="p">:</span><span class= [...]
@@ -6024,15 +6060,15 @@ For <code class="docutils literal notranslate"><span class="pre">make_map</span>
<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="n">map_extract</span><span class="p">(</span><span class="k">map</span><span class="p">,</span><span class="w"> </span><span class="k">key</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id371">
-<h4>Arguments<a class="headerlink" href="#id371" title="Link to this heading">#</a></h4>
+<section id="id374">
+<h4>Arguments<a class="headerlink" href="#id374" title="Link to this heading">#</a></h4>
<ul class="simple">
<li><p><strong>map</strong>: Map expression. Can be a constant, column, or function, and any combination of map operators.</p></li>
<li><p><strong>key</strong>: Key to extract from the map. Can be a constant, column, or function, any combination of arithmetic or string operators, or a named expression of the previously listed.</p></li>
</ul>
</section>
-<section id="id372">
-<h4>Example<a class="headerlink" href="#id372" title="Link to this heading">#</a></h4>
+<section id="id375">
+<h4>Example<a class="headerlink" href="#id375" title="Link to this heading">#</a></h4>
<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="k">SELECT</span><span class="w"> </span><span class="n">map_extract</span><span class="p">(</span><span class="k">MAP</span><span class="w"> </span><span class="err">{</span><span class="s1">'a'</span><span class="p">:</span><span class="w"> </span><span class="mi">1</span><span class="p">,</span><span class="w"> </span><span class="s1">'b'</span><span class="p">:</span><span clas [...]
<span class="c1">----</span>
<span class="p">[</span><span class="mi">1</span><span class="p">]</span>
@@ -6052,8 +6088,8 @@ For <code class="docutils literal notranslate"><span class="pre">make_map</span>
</pre></div>
</div>
</section>
-<section id="id373">
-<h4>Aliases<a class="headerlink" href="#id373" title="Link to this heading">#</a></h4>
+<section id="id376">
+<h4>Aliases<a class="headerlink" href="#id376" title="Link to this heading">#</a></h4>
<ul class="simple">
<li><p>element_at</p></li>
</ul>
@@ -6065,14 +6101,14 @@ For <code class="docutils literal notranslate"><span class="pre">make_map</span>
<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="n">map_keys</span><span class="p">(</span><span class="k">map</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id374">
-<h4>Arguments<a class="headerlink" href="#id374" title="Link to this heading">#</a></h4>
+<section id="id377">
+<h4>Arguments<a class="headerlink" href="#id377" title="Link to this heading">#</a></h4>
<ul class="simple">
<li><p><strong>map</strong>: Map expression. Can be a constant, column, or function, and any combination of map operators.</p></li>
</ul>
</section>
-<section id="id375">
-<h4>Example<a class="headerlink" href="#id375" title="Link to this heading">#</a></h4>
+<section id="id378">
+<h4>Example<a class="headerlink" href="#id378" title="Link to this heading">#</a></h4>
<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="k">SELECT</span><span class="w"> </span><span class="n">map_keys</span><span class="p">(</span><span class="k">MAP</span><span class="w"> </span><span class="err">{</span><span class="s1">'a'</span><span class="p">:</span><span class="w"> </span><span class="mi">1</span><span class="p">,</span><span class="w"> </span><span class="s1">'b'</span><span class="p">:</span><span class=" [...]
<span class="c1">----</span>
<span class="p">[</span><span class="n">a</span><span class="p">,</span><span class="w"> </span><span class="n">b</span><span class="p">,</span><span class="w"> </span><span class="k">c</span><span class="p">]</span>
@@ -6090,14 +6126,14 @@ For <code class="docutils literal notranslate"><span class="pre">make_map</span>
<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="n">map_values</span><span class="p">(</span><span class="k">map</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id376">
-<h4>Arguments<a class="headerlink" href="#id376" title="Link to this heading">#</a></h4>
+<section id="id379">
+<h4>Arguments<a class="headerlink" href="#id379" title="Link to this heading">#</a></h4>
<ul class="simple">
<li><p><strong>map</strong>: Map expression. Can be a constant, column, or function, and any combination of map operators.</p></li>
</ul>
</section>
-<section id="id377">
-<h4>Example<a class="headerlink" href="#id377" title="Link to this heading">#</a></h4>
+<section id="id380">
+<h4>Example<a class="headerlink" href="#id380" title="Link to this heading">#</a></h4>
<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="k">SELECT</span><span class="w"> </span><span class="n">map_values</span><span class="p">(</span><span class="k">MAP</span><span class="w"> </span><span class="err">{</span><span class="s1">'a'</span><span class="p">:</span><span class="w"> </span><span class="mi">1</span><span class="p">,</span><span class="w"> </span><span class="s1">'b'</span><span class="p">:</span><span class [...]
<span class="c1">----</span>
<span class="p">[</span><span class="mi">1</span><span class="p">,</span><span class="w"> </span><span class="p">,</span><span class="w"> </span><span class="mi">3</span><span class="p">]</span>
@@ -6126,8 +6162,8 @@ For <code class="docutils literal notranslate"><span class="pre">make_map</span>
<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="n">digest</span><span class="p">(</span><span class="n">expression</span><span class="p">,</span><span class="w"> </span><span class="n">algorithm</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id378">
-<h4>Arguments<a class="headerlink" href="#id378" title="Link to this heading">#</a></h4>
+<section id="id381">
+<h4>Arguments<a class="headerlink" href="#id381" title="Link to this heading">#</a></h4>
<ul class="simple">
<li><p><strong>expression</strong>: String expression to operate on. Can be a constant, column, or function, and any combination of operators.</p></li>
<li><p><strong>algorithm</strong>: String expression specifying algorithm to use. Must be one of:</p>
@@ -6144,8 +6180,8 @@ For <code class="docutils literal notranslate"><span class="pre">make_map</span>
</li>
</ul>
</section>
-<section id="id379">
-<h4>Example<a class="headerlink" href="#id379" title="Link to this heading">#</a></h4>
+<section id="id382">
+<h4>Example<a class="headerlink" href="#id382" title="Link to this heading">#</a></h4>
<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="o">></span><span class="w"> </span><span class="k">select</span><span class="w"> </span><span class="n">digest</span><span class="p">(</span><span class="s1">'foo'</span><span class="p">,</span><span class="w"> </span><span class="s1">'sha256'</span><span class="p">);</span>
<span class="o">+</span><span class="c1">------------------------------------------------------------------+</span>
<span class="o">|</span><span class="w"> </span><span class="n">digest</span><span class="p">(</span><span class="n">Utf8</span><span class="p">(</span><span class="ss">"foo"</span><span class="p">),</span><span class="n">Utf8</span><span class="p">(</span><span class="ss">"sha256"</span><span class="p">))</span><span class="w"> </span><span class="o">|</span>
@@ -6162,14 +6198,14 @@ For <code class="docutils literal notranslate"><span class="pre">make_map</span>
<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="n">md5</span><span class="p">(</span><span class="n">expression</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id380">
-<h4>Arguments<a class="headerlink" href="#id380" title="Link to this heading">#</a></h4>
+<section id="id383">
+<h4>Arguments<a class="headerlink" href="#id383" title="Link to this heading">#</a></h4>
<ul class="simple">
<li><p><strong>expression</strong>: String expression to operate on. Can be a constant, column, or function, and any combination of operators.</p></li>
</ul>
</section>
-<section id="id381">
-<h4>Example<a class="headerlink" href="#id381" title="Link to this heading">#</a></h4>
+<section id="id384">
+<h4>Example<a class="headerlink" href="#id384" title="Link to this heading">#</a></h4>
<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="o">></span><span class="w"> </span><span class="k">select</span><span class="w"> </span><span class="n">md5</span><span class="p">(</span><span class="s1">'foo'</span><span class="p">);</span>
<span class="o">+</span><span class="c1">----------------------------------+</span>
<span class="o">|</span><span class="w"> </span><span class="n">md5</span><span class="p">(</span><span class="n">Utf8</span><span class="p">(</span><span class="ss">"foo"</span><span class="p">))</span><span class="w"> </span><span class="o">|</span>
@@ -6186,14 +6222,14 @@ For <code class="docutils literal notranslate"><span class="pre">make_map</span>
<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="n">sha224</span><span class="p">(</span><span class="n">expression</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id382">
-<h4>Arguments<a class="headerlink" href="#id382" title="Link to this heading">#</a></h4>
+<section id="id385">
+<h4>Arguments<a class="headerlink" href="#id385" title="Link to this heading">#</a></h4>
<ul class="simple">
<li><p><strong>expression</strong>: String expression to operate on. Can be a constant, column, or function, and any combination of operators.</p></li>
</ul>
</section>
-<section id="id383">
-<h4>Example<a class="headerlink" href="#id383" title="Link to this heading">#</a></h4>
+<section id="id386">
+<h4>Example<a class="headerlink" href="#id386" title="Link to this heading">#</a></h4>
<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="o">></span><span class="w"> </span><span class="k">select</span><span class="w"> </span><span class="n">sha224</span><span class="p">(</span><span class="s1">'foo'</span><span class="p">);</span>
<span class="o">+</span><span class="c1">----------------------------------------------------------+</span>
<span class="o">|</span><span class="w"> </span><span class="n">sha224</span><span class="p">(</span><span class="n">Utf8</span><span class="p">(</span><span class="ss">"foo"</span><span class="p">))</span><span class="w"> </span><span class="o">|</span>
@@ -6210,14 +6246,14 @@ For <code class="docutils literal notranslate"><span class="pre">make_map</span>
<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="n">sha256</span><span class="p">(</span><span class="n">expression</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id384">
-<h4>Arguments<a class="headerlink" href="#id384" title="Link to this heading">#</a></h4>
+<section id="id387">
+<h4>Arguments<a class="headerlink" href="#id387" title="Link to this heading">#</a></h4>
<ul class="simple">
<li><p><strong>expression</strong>: String expression to operate on. Can be a constant, column, or function, and any combination of operators.</p></li>
</ul>
</section>
-<section id="id385">
-<h4>Example<a class="headerlink" href="#id385" title="Link to this heading">#</a></h4>
+<section id="id388">
+<h4>Example<a class="headerlink" href="#id388" title="Link to this heading">#</a></h4>
<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="o">></span><span class="w"> </span><span class="k">select</span><span class="w"> </span><span class="n">sha256</span><span class="p">(</span><span class="s1">'foo'</span><span class="p">);</span>
<span class="o">+</span><span class="c1">------------------------------------------------------------------+</span>
<span class="o">|</span><span class="w"> </span><span class="n">sha256</span><span class="p">(</span><span class="n">Utf8</span><span class="p">(</span><span class="ss">"foo"</span><span class="p">))</span><span class="w"> </span><span class="o">|</span>
@@ -6234,14 +6270,14 @@ For <code class="docutils literal notranslate"><span class="pre">make_map</span>
<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="n">sha384</span><span class="p">(</span><span class="n">expression</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id386">
-<h4>Arguments<a class="headerlink" href="#id386" title="Link to this heading">#</a></h4>
+<section id="id389">
+<h4>Arguments<a class="headerlink" href="#id389" title="Link to this heading">#</a></h4>
<ul class="simple">
<li><p><strong>expression</strong>: String expression to operate on. Can be a constant, column, or function, and any combination of operators.</p></li>
</ul>
</section>
-<section id="id387">
-<h4>Example<a class="headerlink" href="#id387" title="Link to this heading">#</a></h4>
+<section id="id390">
+<h4>Example<a class="headerlink" href="#id390" title="Link to this heading">#</a></h4>
<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="o">></span><span class="w"> </span><span class="k">select</span><span class="w"> </span><span class="n">sha384</span><span class="p">(</span><span class="s1">'foo'</span><span class="p">);</span>
<span class="o">+</span><span class="c1">--------------------------------------------------------------------------------------------------+</span>
<span class="o">|</span><span class="w"> </span><span class="n">sha384</span><span class="p">(</span><span class="n">Utf8</span><span class="p">(</span><span class="ss">"foo"</span><span class="p">))</span><span class="w"> </span><span class="o">|</span>
@@ -6258,14 +6294,14 @@ For <code class="docutils literal notranslate"><span class="pre">make_map</span>
<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="n">sha512</span><span class="p">(</span><span class="n">expression</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id388">
-<h4>Arguments<a class="headerlink" href="#id388" title="Link to this heading">#</a></h4>
+<section id="id391">
+<h4>Arguments<a class="headerlink" href="#id391" title="Link to this heading">#</a></h4>
<ul class="simple">
<li><p><strong>expression</strong>: String expression to operate on. Can be a constant, column, or function, and any combination of operators.</p></li>
</ul>
</section>
-<section id="id389">
-<h4>Example<a class="headerlink" href="#id389" title="Link to this heading">#</a></h4>
+<section id="id392">
+<h4>Example<a class="headerlink" href="#id392" title="Link to this heading">#</a></h4>
<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="o">></span><span class="w"> </span><span class="k">select</span><span class="w"> </span><span class="n">sha512</span><span class="p">(</span><span class="s1">'foo'</span><span class="p">);</span>
<span class="o">+</span><span class="c1">----------------------------------------------------------------------------------------------------------------------------------+</span>
<span class="o">|</span><span class="w"> </span><span class="n">sha512</span><span class="p">(</span><span class="n">Utf8</span><span class="p">(</span><span class="ss">"foo"</span><span class="p">))</span><span class="w"> </span><span class="o">|</span>
@@ -6290,15 +6326,15 @@ For <code class="docutils literal notranslate"><span class="pre">make_map</span>
<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="n">union_extract</span><span class="p">(</span><span class="k">union</span><span class="p">,</span><span class="w"> </span><span class="n">field_name</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id390">
-<h4>Arguments<a class="headerlink" href="#id390" title="Link to this heading">#</a></h4>
+<section id="id393">
+<h4>Arguments<a class="headerlink" href="#id393" title="Link to this heading">#</a></h4>
<ul class="simple">
<li><p><strong>union</strong>: Union expression to operate on. Can be a constant, column, or function, and any combination of operators.</p></li>
<li><p><strong>field_name</strong>: String expression to operate on. Must be a constant.</p></li>
</ul>
</section>
-<section id="id391">
-<h4>Example<a class="headerlink" href="#id391" title="Link to this heading">#</a></h4>
+<section id="id394">
+<h4>Example<a class="headerlink" href="#id394" title="Link to this heading">#</a></h4>
<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="err">❯</span><span class="w"> </span><span class="k">select</span><span class="w"> </span><span class="n">union_column</span><span class="p">,</span><span class="w"> </span><span class="n">union_extract</span><span class="p">(</span><span class="n">union_column</span><span class="p">,</span><span class="w"> </span><span class="s1">'a'</span><span class="p">),</span><span class="w"> </span [...]
<span class="o">+</span><span class="c1">--------------+----------------------------------+----------------------------------+</span>
<span class="o">|</span><span class="w"> </span><span class="n">union_column</span><span class="w"> </span><span class="o">|</span><span class="w"> </span><span class="n">union_extract</span><span class="p">(</span><span class="n">union_column</span><span class="p">,</span><span class="w"> </span><span class="s1">'a'</span><span class="p">)</span><span class="w"> </span><span class="o">|</span><span class="w"> </span><span class="n">union_extract</span><span class="p">(</span><sp [...]
@@ -6319,14 +6355,14 @@ For <code class="docutils literal notranslate"><span class="pre">make_map</span>
<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="n">union_tag</span><span class="p">(</span><span class="n">union_expression</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id392">
-<h4>Arguments<a class="headerlink" href="#id392" title="Link to this heading">#</a></h4>
+<section id="id395">
+<h4>Arguments<a class="headerlink" href="#id395" title="Link to this heading">#</a></h4>
<ul class="simple">
<li><p><strong>union</strong>: Union expression to operate on. Can be a constant, column, or function, and any combination of operators.</p></li>
</ul>
</section>
-<section id="id393">
-<h4>Example<a class="headerlink" href="#id393" title="Link to this heading">#</a></h4>
+<section id="id396">
+<h4>Example<a class="headerlink" href="#id396" title="Link to this heading">#</a></h4>
<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="err">❯</span><span class="w"> </span><span class="k">select</span><span class="w"> </span><span class="n">union_column</span><span class="p">,</span><span class="w"> </span><span class="n">union_tag</span><span class="p">(</span><span class="n">union_column</span><span class="p">)</span><span class="w"> </span><span class="k">from</span><span class="w"> </span><span class="n">table_with_union</sp [...]
<span class="o">+</span><span class="c1">--------------+-------------------------+</span>
<span class="o">|</span><span class="w"> </span><span class="n">union_column</span><span class="w"> </span><span class="o">|</span><span class="w"> </span><span class="n">union_tag</span><span class="p">(</span><span class="n">union_column</span><span class="p">)</span><span class="w"> </span><span class="o">|</span>
@@ -6362,15 +6398,15 @@ For <code class="docutils literal notranslate"><span class="pre">make_map</span>
<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="n">arrow_cast</span><span class="p">(</span><span class="n">expression</span><span class="p">,</span><span class="w"> </span><span class="n">datatype</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id394">
-<h4>Arguments<a class="headerlink" href="#id394" title="Link to this heading">#</a></h4>
+<section id="id397">
+<h4>Arguments<a class="headerlink" href="#id397" title="Link to this heading">#</a></h4>
<ul class="simple">
<li><p><strong>expression</strong>: Expression to cast. The expression can be a constant, column, or function, and any combination of operators.</p></li>
<li><p><strong>datatype</strong>: <a class="reference external" href="https://docs.rs/arrow/latest/arrow/datatypes/enum.DataType.html">Arrow data type</a> name to cast to, as a string. The format is the same as that returned by [<code class="docutils literal notranslate"><span class="pre">arrow_typeof</span></code>]</p></li>
</ul>
</section>
-<section id="id395">
-<h4>Example<a class="headerlink" href="#id395" title="Link to this heading">#</a></h4>
+<section id="id398">
+<h4>Example<a class="headerlink" href="#id398" title="Link to this heading">#</a></h4>
<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="o">></span><span class="w"> </span><span class="k">select</span>
<span class="w"> </span><span class="n">arrow_cast</span><span class="p">(</span><span class="o">-</span><span class="mi">5</span><span class="p">,</span><span class="w"> </span><span class="s1">'Int8'</span><span class="p">)</span><span class="w"> </span><span class="k">as</span><span class="w"> </span><span class="n">a</span><span class="p">,</span>
<span class="w"> </span><span class="n">arrow_cast</span><span class="p">(</span><span class="s1">'foo'</span><span class="p">,</span><span class="w"> </span><span class="s1">'Dictionary(Int32, Utf8)'</span><span class="p">)</span><span class="w"> </span><span class="k">as</span><span class="w"> </span><span class="n">b</span><span class="p">,</span>
@@ -6401,14 +6437,14 @@ For <code class="docutils literal notranslate"><span class="pre">make_map</span>
<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="n">arrow_field</span><span class="p">(</span><span class="n">expression</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id396">
-<h4>Arguments<a class="headerlink" href="#id396" title="Link to this heading">#</a></h4>
+<section id="id399">
+<h4>Arguments<a class="headerlink" href="#id399" title="Link to this heading">#</a></h4>
<ul class="simple">
<li><p><strong>expression</strong>: Expression to evaluate. The expression can be a constant, column, or function, and any combination of operators.</p></li>
</ul>
</section>
-<section id="id397">
-<h4>Example<a class="headerlink" href="#id397" title="Link to this heading">#</a></h4>
+<section id="id400">
+<h4>Example<a class="headerlink" href="#id400" title="Link to this heading">#</a></h4>
<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="o">></span><span class="w"> </span><span class="k">select</span><span class="w"> </span><span class="n">arrow_field</span><span class="p">(</span><span class="mi">1</span><span class="p">);</span>
<span class="o">+</span><span class="c1">-------------------------------------------------------------+</span>
<span class="o">|</span><span class="w"> </span><span class="n">arrow_field</span><span class="p">(</span><span class="n">Int64</span><span class="p">(</span><span class="mi">1</span><span class="p">))</span><span class="w"> </span><span class="o">|</span>
@@ -6432,15 +6468,15 @@ For <code class="docutils literal notranslate"><span class="pre">make_map</span>
<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="n">arrow_metadata</span><span class="p">(</span><span class="n">expression</span><span class="p">[,</span><span class="w"> </span><span class="k">key</span><span class="p">])</span>
</pre></div>
</div>
-<section id="id398">
-<h4>Arguments<a class="headerlink" href="#id398" title="Link to this heading">#</a></h4>
+<section id="id401">
+<h4>Arguments<a class="headerlink" href="#id401" title="Link to this heading">#</a></h4>
<ul class="simple">
<li><p><strong>expression</strong>: The expression to retrieve metadata from. Can be a column or other expression.</p></li>
<li><p><strong>key</strong>: Optional. The specific metadata key to retrieve.</p></li>
</ul>
</section>
-<section id="id399">
-<h4>Example<a class="headerlink" href="#id399" title="Link to this heading">#</a></h4>
+<section id="id402">
+<h4>Example<a class="headerlink" href="#id402" title="Link to this heading">#</a></h4>
<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="o">></span><span class="w"> </span><span class="k">select</span><span class="w"> </span><span class="n">arrow_metadata</span><span class="p">(</span><span class="n">col</span><span class="p">)</span><span class="w"> </span><span class="k">from</span><span class="w"> </span><span class="k">table</span><span class="p">;</span>
<span class="o">+</span><span class="c1">----------------------------+</span>
<span class="o">|</span><span class="w"> </span><span class="n">arrow_metadata</span><span class="p">(</span><span class="k">table</span><span class="p">.</span><span class="n">col</span><span class="p">)</span><span class="w"> </span><span class="o">|</span>
@@ -6463,15 +6499,15 @@ For <code class="docutils literal notranslate"><span class="pre">make_map</span>
<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="n">arrow_try_cast</span><span class="p">(</span><span class="n">expression</span><span class="p">,</span><span class="w"> </span><span class="n">datatype</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id400">
-<h4>Arguments<a class="headerlink" href="#id400" title="Link to this heading">#</a></h4>
+<section id="id403">
+<h4>Arguments<a class="headerlink" href="#id403" title="Link to this heading">#</a></h4>
<ul class="simple">
<li><p><strong>expression</strong>: Expression to cast. The expression can be a constant, column, or function, and any combination of operators.</p></li>
<li><p><strong>datatype</strong>: <a class="reference external" href="https://docs.rs/arrow/latest/arrow/datatypes/enum.DataType.html">Arrow data type</a> name to cast to, as a string. The format is the same as that returned by [<code class="docutils literal notranslate"><span class="pre">arrow_typeof</span></code>]</p></li>
</ul>
</section>
-<section id="id401">
-<h4>Example<a class="headerlink" href="#id401" title="Link to this heading">#</a></h4>
+<section id="id404">
+<h4>Example<a class="headerlink" href="#id404" title="Link to this heading">#</a></h4>
<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="o">></span><span class="w"> </span><span class="k">select</span><span class="w"> </span><span class="n">arrow_try_cast</span><span class="p">(</span><span class="s1">'123'</span><span class="p">,</span><span class="w"> </span><span class="s1">'Int64'</span><span class="p">)</span><span class="w"> </span><span class="k">as</span><span class="w"> </span><span class="n">a</span><s [...]
<span class="w"> </span><span class="n">arrow_try_cast</span><span class="p">(</span><span class="s1">'not_a_number'</span><span class="p">,</span><span class="w"> </span><span class="s1">'Int64'</span><span class="p">)</span><span class="w"> </span><span class="k">as</span><span class="w"> </span><span class="n">b</span><span class="p">;</span>
@@ -6490,14 +6526,14 @@ For <code class="docutils literal notranslate"><span class="pre">make_map</span>
<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="n">arrow_typeof</span><span class="p">(</span><span class="n">expression</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id402">
-<h4>Arguments<a class="headerlink" href="#id402" title="Link to this heading">#</a></h4>
+<section id="id405">
+<h4>Arguments<a class="headerlink" href="#id405" title="Link to this heading">#</a></h4>
<ul class="simple">
<li><p><strong>expression</strong>: Expression to evaluate. The expression can be a constant, column, or function, and any combination of operators.</p></li>
</ul>
</section>
-<section id="id403">
-<h4>Example<a class="headerlink" href="#id403" title="Link to this heading">#</a></h4>
+<section id="id406">
+<h4>Example<a class="headerlink" href="#id406" title="Link to this heading">#</a></h4>
<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="o">></span><span class="w"> </span><span class="k">select</span><span class="w"> </span><span class="n">arrow_typeof</span><span class="p">(</span><span class="s1">'foo'</span><span class="p">),</span><span class="w"> </span><span class="n">arrow_typeof</span><span class="p">(</span><span class="mi">1</span><span class="p">);</span>
<span class="o">+</span><span class="c1">---------------------------+------------------------+</span>
<span class="o">|</span><span class="w"> </span><span class="n">arrow_typeof</span><span class="p">(</span><span class="n">Utf8</span><span class="p">(</span><span class="ss">"foo"</span><span class="p">))</span><span class="w"> </span><span class="o">|</span><span class="w"> </span><span class="n">arrow_typeof</span><span class="p">(</span><span class="n">Int64</span><span class="p">(</span><span class="mi">1</span><span class="p">))</span><span class="w"> </span><span class=" [...]
@@ -6514,15 +6550,15 @@ For <code class="docutils literal notranslate"><span class="pre">make_map</span>
<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="n">cast_to_type</span><span class="p">(</span><span class="n">expression</span><span class="p">,</span><span class="w"> </span><span class="n">reference</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id404">
-<h4>Arguments<a class="headerlink" href="#id404" title="Link to this heading">#</a></h4>
+<section id="id407">
+<h4>Arguments<a class="headerlink" href="#id407" title="Link to this heading">#</a></h4>
<ul class="simple">
<li><p><strong>expression</strong>: The expression to cast. It can be a constant, column, or function, and any combination of operators.</p></li>
<li><p><strong>reference</strong>: Reference expression whose data type determines the target cast type. The value is ignored.</p></li>
</ul>
</section>
-<section id="id405">
-<h4>Example<a class="headerlink" href="#id405" title="Link to this heading">#</a></h4>
+<section id="id408">
+<h4>Example<a class="headerlink" href="#id408" title="Link to this heading">#</a></h4>
<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="o">></span><span class="w"> </span><span class="k">select</span><span class="w"> </span><span class="n">cast_to_type</span><span class="p">(</span><span class="s1">'42'</span><span class="p">,</span><span class="w"> </span><span class="k">NULL</span><span class="p">::</span><span class="nb">INTEGER</span><span class="p">)</span><span class="w"> </span><span class="k">as</span><span cla [...]
<span class="o">+</span><span class="c1">----+</span>
<span class="o">|</span><span class="w"> </span><span class="n">a</span><span class="w"> </span><span class="o">|</span>
@@ -6552,15 +6588,15 @@ Nested access like <code class="docutils literal notranslate"><span class="pre">
<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="n">get_field</span><span class="p">(</span><span class="n">expression</span><span class="p">,</span><span class="w"> </span><span class="n">field_name</span><span class="p">[,</span><span class="w"> </span><span class="n">field_name2</span><span class="p">,</span><span class="w"> </span><span class="p">...])</span>
</pre></div>
</div>
-<section id="id406">
-<h4>Arguments<a class="headerlink" href="#id406" title="Link to this heading">#</a></h4>
+<section id="id409">
+<h4>Arguments<a class="headerlink" href="#id409" title="Link to this heading">#</a></h4>
<ul class="simple">
<li><p><strong>expression</strong>: The map or struct to retrieve a field from.</p></li>
<li><p><strong>field_name</strong>: The field name(s) to access, in order for nested access. Must evaluate to strings.</p></li>
</ul>
</section>
-<section id="id407">
-<h4>Example<a class="headerlink" href="#id407" title="Link to this heading">#</a></h4>
+<section id="id410">
+<h4>Example<a class="headerlink" href="#id410" title="Link to this heading">#</a></h4>
<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="o">></span><span class="w"> </span><span class="c1">-- Access a field from a struct column</span>
<span class="o">></span><span class="w"> </span><span class="k">create</span><span class="w"> </span><span class="k">table</span><span class="w"> </span><span class="n">test</span><span class="p">(</span><span class="w"> </span><span class="n">struct_col</span><span class="p">)</span><span class="w"> </span><span class="k">as</span><span class="w"> </span><span class="k">values</span>
<span class="w"> </span><span class="p">(</span><span class="err">{</span><span class="n">name</span><span class="p">:</span><span class="w"> </span><span class="s1">'Alice'</span><span class="p">,</span><span class="w"> </span><span class="n">age</span><span class="p">:</span><span class="w"> </span><span class="mi">30</span><span class="err">}</span><span class="p">),</span>
@@ -6599,15 +6635,15 @@ Nested access like <code class="docutils literal notranslate"><span class="pre">
<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="n">try_cast_to_type</span><span class="p">(</span><span class="n">expression</span><span class="p">,</span><span class="w"> </span><span class="n">reference</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id408">
-<h4>Arguments<a class="headerlink" href="#id408" title="Link to this heading">#</a></h4>
+<section id="id411">
+<h4>Arguments<a class="headerlink" href="#id411" title="Link to this heading">#</a></h4>
<ul class="simple">
<li><p><strong>expression</strong>: The expression to cast. It can be a constant, column, or function, and any combination of operators.</p></li>
<li><p><strong>reference</strong>: Reference expression whose data type determines the target cast type. The value is ignored.</p></li>
</ul>
</section>
-<section id="id409">
-<h4>Example<a class="headerlink" href="#id409" title="Link to this heading">#</a></h4>
+<section id="id412">
+<h4>Example<a class="headerlink" href="#id412" title="Link to this heading">#</a></h4>
<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="o">></span><span class="w"> </span><span class="k">select</span><span class="w"> </span><span class="n">try_cast_to_type</span><span class="p">(</span><span class="s1">'123'</span><span class="p">,</span><span class="w"> </span><span class="k">NULL</span><span class="p">::</span><span class="nb">INTEGER</span><span class="p">)</span><span class="w"> </span><span class="k">as</span><spa [...]
<span class="w"> </span><span class="n">try_cast_to_type</span><span class="p">(</span><span class="s1">'not_a_number'</span><span class="p">,</span><span class="w"> </span><span class="k">NULL</span><span class="p">::</span><span class="nb">INTEGER</span><span class="p">)</span><span class="w"> </span><span class="k">as</span><span class="w"> </span><span class="n">b</span><span class="p">;</span>
@@ -6626,8 +6662,8 @@ Nested access like <code class="docutils literal notranslate"><span class="pre">
<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="k">version</span><span class="p">()</span>
</pre></div>
</div>
-<section id="id410">
-<h4>Example<a class="headerlink" href="#id410" title="Link to this heading">#</a></h4>
+<section id="id413">
+<h4>Example<a class="headerlink" href="#id413" title="Link to this heading">#</a></h4>
<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="o">></span><span class="w"> </span><span class="k">select</span><span class="w"> </span><span class="k">version</span><span class="p">();</span>
<span class="o">+</span><span class="c1">--------------------------------------------+</span>
<span class="o">|</span><span class="w"> </span><span class="k">version</span><span class="p">()</span><span class="w"> </span><span class="o">|</span>
@@ -6644,16 +6680,16 @@ Nested access like <code class="docutils literal notranslate"><span class="pre">
<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="n">with_metadata</span><span class="p">(</span><span class="n">expression</span><span class="p">,</span><span class="w"> </span><span class="n">key1</span><span class="p">,</span><span class="w"> </span><span class="n">value1</span><span class="p">[,</span><span class="w"> </span><span class="n">key2</span><span class="p">,</span><span class="w"> </span><span class="n">value2</span><span class="p [...]
</pre></div>
</div>
-<section id="id411">
-<h4>Arguments<a class="headerlink" href="#id411" title="Link to this heading">#</a></h4>
+<section id="id414">
+<h4>Arguments<a class="headerlink" href="#id414" title="Link to this heading">#</a></h4>
<ul class="simple">
<li><p><strong>expression</strong>: The expression whose output Arrow field should be annotated. Values flow through unchanged.</p></li>
<li><p><strong>key</strong>: Metadata key. Must be a non-empty constant string literal.</p></li>
<li><p><strong>value</strong>: Metadata value. Must be a constant string literal (may be empty).</p></li>
</ul>
</section>
-<section id="id412">
-<h4>Example<a class="headerlink" href="#id412" title="Link to this heading">#</a></h4>
+<section id="id415">
+<h4>Example<a class="headerlink" href="#id415" title="Link to this heading">#</a></h4>
<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="o">></span><span class="w"> </span><span class="k">select</span><span class="w"> </span><span class="n">arrow_metadata</span><span class="p">(</span><span class="n">with_metadata</span><span class="p">(</span><span class="n">column1</span><span class="p">,</span><span class="w"> </span><span class="s1">'unit'</span><span class="p">,</span><span class="w"> </span><span class="s1">'m [...]
<span class="o">+</span><span class="c1">---------------------------------------------------------------+</span>
<span class="o">|</span><span class="w"> </span><span class="n">arrow_metadata</span><span class="p">(</span><span class="n">with_metadata</span><span class="p">(</span><span class="n">column1</span><span class="p">,</span><span class="n">Utf8</span><span class="p">(</span><span class="ss">"unit"</span><span class="p">),</span><span class="n">Utf8</span><span class="p">(</span><span class="ss">"ms"</span><span class="p">)),</span><span class="n">Utf8</span><span class [...]
@@ -7436,142 +7472,148 @@ Nested access like <code class="docutils literal notranslate"><span class="pre">
<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id288">Aliases</a></li>
</ul>
</li>
-<li class="toc-h3 nav-item toc-entry"><a class="reference internal nav-link" href="#array-push-back"><code class="docutils literal notranslate"><span class="pre">array_push_back</span></code></a></li>
-<li class="toc-h3 nav-item toc-entry"><a class="reference internal nav-link" href="#array-push-front"><code class="docutils literal notranslate"><span class="pre">array_push_front</span></code></a></li>
-<li class="toc-h3 nav-item toc-entry"><a class="reference internal nav-link" href="#array-remove"><code class="docutils literal notranslate"><span class="pre">array_remove</span></code></a><ul class="nav section-nav flex-column">
+<li class="toc-h3 nav-item toc-entry"><a class="reference internal nav-link" href="#array-product"><code class="docutils literal notranslate"><span class="pre">array_product</span></code></a><ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id289">Arguments</a></li>
<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id290">Example</a></li>
<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id291">Aliases</a></li>
</ul>
</li>
-<li class="toc-h3 nav-item toc-entry"><a class="reference internal nav-link" href="#array-remove-all"><code class="docutils literal notranslate"><span class="pre">array_remove_all</span></code></a><ul class="nav section-nav flex-column">
+<li class="toc-h3 nav-item toc-entry"><a class="reference internal nav-link" href="#array-push-back"><code class="docutils literal notranslate"><span class="pre">array_push_back</span></code></a></li>
+<li class="toc-h3 nav-item toc-entry"><a class="reference internal nav-link" href="#array-push-front"><code class="docutils literal notranslate"><span class="pre">array_push_front</span></code></a></li>
+<li class="toc-h3 nav-item toc-entry"><a class="reference internal nav-link" href="#array-remove"><code class="docutils literal notranslate"><span class="pre">array_remove</span></code></a><ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id292">Arguments</a></li>
<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id293">Example</a></li>
<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id294">Aliases</a></li>
</ul>
</li>
-<li class="toc-h3 nav-item toc-entry"><a class="reference internal nav-link" href="#array-remove-n"><code class="docutils literal notranslate"><span class="pre">array_remove_n</span></code></a><ul class="nav section-nav flex-column">
+<li class="toc-h3 nav-item toc-entry"><a class="reference internal nav-link" href="#array-remove-all"><code class="docutils literal notranslate"><span class="pre">array_remove_all</span></code></a><ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id295">Arguments</a></li>
<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id296">Example</a></li>
<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id297">Aliases</a></li>
</ul>
</li>
-<li class="toc-h3 nav-item toc-entry"><a class="reference internal nav-link" href="#array-repeat"><code class="docutils literal notranslate"><span class="pre">array_repeat</span></code></a><ul class="nav section-nav flex-column">
+<li class="toc-h3 nav-item toc-entry"><a class="reference internal nav-link" href="#array-remove-n"><code class="docutils literal notranslate"><span class="pre">array_remove_n</span></code></a><ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id298">Arguments</a></li>
<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id299">Example</a></li>
<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id300">Aliases</a></li>
</ul>
</li>
-<li class="toc-h3 nav-item toc-entry"><a class="reference internal nav-link" href="#array-replace"><code class="docutils literal notranslate"><span class="pre">array_replace</span></code></a><ul class="nav section-nav flex-column">
+<li class="toc-h3 nav-item toc-entry"><a class="reference internal nav-link" href="#array-repeat"><code class="docutils literal notranslate"><span class="pre">array_repeat</span></code></a><ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id301">Arguments</a></li>
<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id302">Example</a></li>
<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id303">Aliases</a></li>
</ul>
</li>
-<li class="toc-h3 nav-item toc-entry"><a class="reference internal nav-link" href="#array-replace-all"><code class="docutils literal notranslate"><span class="pre">array_replace_all</span></code></a><ul class="nav section-nav flex-column">
+<li class="toc-h3 nav-item toc-entry"><a class="reference internal nav-link" href="#array-replace"><code class="docutils literal notranslate"><span class="pre">array_replace</span></code></a><ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id304">Arguments</a></li>
<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id305">Example</a></li>
<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id306">Aliases</a></li>
</ul>
</li>
-<li class="toc-h3 nav-item toc-entry"><a class="reference internal nav-link" href="#array-replace-n"><code class="docutils literal notranslate"><span class="pre">array_replace_n</span></code></a><ul class="nav section-nav flex-column">
+<li class="toc-h3 nav-item toc-entry"><a class="reference internal nav-link" href="#array-replace-all"><code class="docutils literal notranslate"><span class="pre">array_replace_all</span></code></a><ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id307">Arguments</a></li>
<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id308">Example</a></li>
<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id309">Aliases</a></li>
</ul>
</li>
-<li class="toc-h3 nav-item toc-entry"><a class="reference internal nav-link" href="#array-resize"><code class="docutils literal notranslate"><span class="pre">array_resize</span></code></a><ul class="nav section-nav flex-column">
+<li class="toc-h3 nav-item toc-entry"><a class="reference internal nav-link" href="#array-replace-n"><code class="docutils literal notranslate"><span class="pre">array_replace_n</span></code></a><ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id310">Arguments</a></li>
<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id311">Example</a></li>
<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id312">Aliases</a></li>
</ul>
</li>
-<li class="toc-h3 nav-item toc-entry"><a class="reference internal nav-link" href="#array-reverse"><code class="docutils literal notranslate"><span class="pre">array_reverse</span></code></a><ul class="nav section-nav flex-column">
+<li class="toc-h3 nav-item toc-entry"><a class="reference internal nav-link" href="#array-resize"><code class="docutils literal notranslate"><span class="pre">array_resize</span></code></a><ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id313">Arguments</a></li>
<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id314">Example</a></li>
<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id315">Aliases</a></li>
</ul>
</li>
-<li class="toc-h3 nav-item toc-entry"><a class="reference internal nav-link" href="#array-scale"><code class="docutils literal notranslate"><span class="pre">array_scale</span></code></a><ul class="nav section-nav flex-column">
+<li class="toc-h3 nav-item toc-entry"><a class="reference internal nav-link" href="#array-reverse"><code class="docutils literal notranslate"><span class="pre">array_reverse</span></code></a><ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id316">Arguments</a></li>
<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id317">Example</a></li>
<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id318">Aliases</a></li>
</ul>
</li>
-<li class="toc-h3 nav-item toc-entry"><a class="reference internal nav-link" href="#array-slice"><code class="docutils literal notranslate"><span class="pre">array_slice</span></code></a><ul class="nav section-nav flex-column">
+<li class="toc-h3 nav-item toc-entry"><a class="reference internal nav-link" href="#array-scale"><code class="docutils literal notranslate"><span class="pre">array_scale</span></code></a><ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id319">Arguments</a></li>
<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id320">Example</a></li>
<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id321">Aliases</a></li>
</ul>
</li>
-<li class="toc-h3 nav-item toc-entry"><a class="reference internal nav-link" href="#array-sort"><code class="docutils literal notranslate"><span class="pre">array_sort</span></code></a><ul class="nav section-nav flex-column">
+<li class="toc-h3 nav-item toc-entry"><a class="reference internal nav-link" href="#array-slice"><code class="docutils literal notranslate"><span class="pre">array_slice</span></code></a><ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id322">Arguments</a></li>
<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id323">Example</a></li>
<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id324">Aliases</a></li>
</ul>
</li>
-<li class="toc-h3 nav-item toc-entry"><a class="reference internal nav-link" href="#array-subtract"><code class="docutils literal notranslate"><span class="pre">array_subtract</span></code></a><ul class="nav section-nav flex-column">
+<li class="toc-h3 nav-item toc-entry"><a class="reference internal nav-link" href="#array-sort"><code class="docutils literal notranslate"><span class="pre">array_sort</span></code></a><ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id325">Arguments</a></li>
<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id326">Example</a></li>
<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id327">Aliases</a></li>
</ul>
</li>
-<li class="toc-h3 nav-item toc-entry"><a class="reference internal nav-link" href="#array-to-string"><code class="docutils literal notranslate"><span class="pre">array_to_string</span></code></a><ul class="nav section-nav flex-column">
+<li class="toc-h3 nav-item toc-entry"><a class="reference internal nav-link" href="#array-subtract"><code class="docutils literal notranslate"><span class="pre">array_subtract</span></code></a><ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id328">Arguments</a></li>
<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id329">Example</a></li>
<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id330">Aliases</a></li>
</ul>
</li>
-<li class="toc-h3 nav-item toc-entry"><a class="reference internal nav-link" href="#array-transform"><code class="docutils literal notranslate"><span class="pre">array_transform</span></code></a><ul class="nav section-nav flex-column">
+<li class="toc-h3 nav-item toc-entry"><a class="reference internal nav-link" href="#array-to-string"><code class="docutils literal notranslate"><span class="pre">array_to_string</span></code></a><ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id331">Arguments</a></li>
<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id332">Example</a></li>
<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id333">Aliases</a></li>
</ul>
</li>
-<li class="toc-h3 nav-item toc-entry"><a class="reference internal nav-link" href="#array-union"><code class="docutils literal notranslate"><span class="pre">array_union</span></code></a><ul class="nav section-nav flex-column">
+<li class="toc-h3 nav-item toc-entry"><a class="reference internal nav-link" href="#array-transform"><code class="docutils literal notranslate"><span class="pre">array_transform</span></code></a><ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id334">Arguments</a></li>
<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id335">Example</a></li>
<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id336">Aliases</a></li>
</ul>
</li>
-<li class="toc-h3 nav-item toc-entry"><a class="reference internal nav-link" href="#arrays-overlap"><code class="docutils literal notranslate"><span class="pre">arrays_overlap</span></code></a></li>
-<li class="toc-h3 nav-item toc-entry"><a class="reference internal nav-link" href="#arrays-zip"><code class="docutils literal notranslate"><span class="pre">arrays_zip</span></code></a><ul class="nav section-nav flex-column">
+<li class="toc-h3 nav-item toc-entry"><a class="reference internal nav-link" href="#array-union"><code class="docutils literal notranslate"><span class="pre">array_union</span></code></a><ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id337">Arguments</a></li>
<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id338">Example</a></li>
<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id339">Aliases</a></li>
</ul>
</li>
-<li class="toc-h3 nav-item toc-entry"><a class="reference internal nav-link" href="#cardinality"><code class="docutils literal notranslate"><span class="pre">cardinality</span></code></a><ul class="nav section-nav flex-column">
+<li class="toc-h3 nav-item toc-entry"><a class="reference internal nav-link" href="#arrays-overlap"><code class="docutils literal notranslate"><span class="pre">arrays_overlap</span></code></a></li>
+<li class="toc-h3 nav-item toc-entry"><a class="reference internal nav-link" href="#arrays-zip"><code class="docutils literal notranslate"><span class="pre">arrays_zip</span></code></a><ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id340">Arguments</a></li>
<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id341">Example</a></li>
+<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id342">Aliases</a></li>
+</ul>
+</li>
+<li class="toc-h3 nav-item toc-entry"><a class="reference internal nav-link" href="#cardinality"><code class="docutils literal notranslate"><span class="pre">cardinality</span></code></a><ul class="nav section-nav flex-column">
+<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id343">Arguments</a></li>
+<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id344">Example</a></li>
</ul>
</li>
<li class="toc-h3 nav-item toc-entry"><a class="reference internal nav-link" href="#cosine-distance"><code class="docutils literal notranslate"><span class="pre">cosine_distance</span></code></a><ul class="nav section-nav flex-column">
-<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id342">Arguments</a></li>
-<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id343">Example</a></li>
+<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id345">Arguments</a></li>
+<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id346">Example</a></li>
</ul>
</li>
<li class="toc-h3 nav-item toc-entry"><a class="reference internal nav-link" href="#dot-product"><code class="docutils literal notranslate"><span class="pre">dot_product</span></code></a></li>
<li class="toc-h3 nav-item toc-entry"><a class="reference internal nav-link" href="#empty"><code class="docutils literal notranslate"><span class="pre">empty</span></code></a><ul class="nav section-nav flex-column">
-<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id344">Arguments</a></li>
-<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id345">Example</a></li>
-<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id346">Aliases</a></li>
+<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id347">Arguments</a></li>
+<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id348">Example</a></li>
+<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id349">Aliases</a></li>
</ul>
</li>
<li class="toc-h3 nav-item toc-entry"><a class="reference internal nav-link" href="#flatten"><code class="docutils literal notranslate"><span class="pre">flatten</span></code></a><ul class="nav section-nav flex-column">
-<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id347">Arguments</a></li>
-<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id348">Example</a></li>
+<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id350">Arguments</a></li>
+<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id351">Example</a></li>
</ul>
</li>
<li class="toc-h3 nav-item toc-entry"><a class="reference internal nav-link" href="#generate-series"><code class="docutils literal notranslate"><span class="pre">generate_series</span></code></a><ul class="nav section-nav flex-column">
-<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id349">Arguments</a></li>
-<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id350">Example</a></li>
+<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id352">Arguments</a></li>
+<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id353">Example</a></li>
</ul>
</li>
<li class="toc-h3 nav-item toc-entry"><a class="reference internal nav-link" href="#inner-product"><code class="docutils literal notranslate"><span class="pre">inner_product</span></code></a><ul class="nav section-nav flex-column">
-<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id351">Arguments</a></li>
-<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id352">Example</a></li>
-<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id353">Aliases</a></li>
+<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id354">Arguments</a></li>
+<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id355">Example</a></li>
+<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id356">Aliases</a></li>
</ul>
</li>
<li class="toc-h3 nav-item toc-entry"><a class="reference internal nav-link" href="#list-add"><code class="docutils literal notranslate"><span class="pre">list_add</span></code></a></li>
@@ -7605,6 +7647,7 @@ Nested access like <code class="docutils literal notranslate"><span class="pre">
<li class="toc-h3 nav-item toc-entry"><a class="reference internal nav-link" href="#list-position"><code class="docutils literal notranslate"><span class="pre">list_position</span></code></a></li>
<li class="toc-h3 nav-item toc-entry"><a class="reference internal nav-link" href="#list-positions"><code class="docutils literal notranslate"><span class="pre">list_positions</span></code></a></li>
<li class="toc-h3 nav-item toc-entry"><a class="reference internal nav-link" href="#list-prepend"><code class="docutils literal notranslate"><span class="pre">list_prepend</span></code></a></li>
+<li class="toc-h3 nav-item toc-entry"><a class="reference internal nav-link" href="#list-product"><code class="docutils literal notranslate"><span class="pre">list_product</span></code></a></li>
<li class="toc-h3 nav-item toc-entry"><a class="reference internal nav-link" href="#list-push-back"><code class="docutils literal notranslate"><span class="pre">list_push_back</span></code></a></li>
<li class="toc-h3 nav-item toc-entry"><a class="reference internal nav-link" href="#list-push-front"><code class="docutils literal notranslate"><span class="pre">list_push_front</span></code></a></li>
<li class="toc-h3 nav-item toc-entry"><a class="reference internal nav-link" href="#list-remove"><code class="docutils literal notranslate"><span class="pre">list_remove</span></code></a></li>
@@ -7625,21 +7668,21 @@ Nested access like <code class="docutils literal notranslate"><span class="pre">
<li class="toc-h3 nav-item toc-entry"><a class="reference internal nav-link" href="#list-union"><code class="docutils literal notranslate"><span class="pre">list_union</span></code></a></li>
<li class="toc-h3 nav-item toc-entry"><a class="reference internal nav-link" href="#list-zip"><code class="docutils literal notranslate"><span class="pre">list_zip</span></code></a></li>
<li class="toc-h3 nav-item toc-entry"><a class="reference internal nav-link" href="#make-array"><code class="docutils literal notranslate"><span class="pre">make_array</span></code></a><ul class="nav section-nav flex-column">
-<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id354">Arguments</a></li>
-<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id355">Example</a></li>
-<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id356">Aliases</a></li>
+<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id357">Arguments</a></li>
+<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id358">Example</a></li>
+<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id359">Aliases</a></li>
</ul>
</li>
<li class="toc-h3 nav-item toc-entry"><a class="reference internal nav-link" href="#make-list"><code class="docutils literal notranslate"><span class="pre">make_list</span></code></a></li>
<li class="toc-h3 nav-item toc-entry"><a class="reference internal nav-link" href="#range"><code class="docutils literal notranslate"><span class="pre">range</span></code></a><ul class="nav section-nav flex-column">
-<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id357">Arguments</a></li>
-<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id358">Example</a></li>
+<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id360">Arguments</a></li>
+<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id361">Example</a></li>
</ul>
</li>
<li class="toc-h3 nav-item toc-entry"><a class="reference internal nav-link" href="#string-to-array"><code class="docutils literal notranslate"><span class="pre">string_to_array</span></code></a><ul class="nav section-nav flex-column">
-<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id359">Arguments</a></li>
-<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id360">Example</a></li>
-<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id361">Aliases</a></li>
+<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id362">Arguments</a></li>
+<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id363">Example</a></li>
+<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id364">Aliases</a></li>
</ul>
</li>
<li class="toc-h3 nav-item toc-entry"><a class="reference internal nav-link" href="#string-to-list"><code class="docutils literal notranslate"><span class="pre">string_to_list</span></code></a></li>
@@ -7647,15 +7690,15 @@ Nested access like <code class="docutils literal notranslate"><span class="pre">
</li>
<li class="toc-h2 nav-item toc-entry"><a class="reference internal nav-link" href="#struct-functions">Struct Functions</a><ul class="nav section-nav flex-column">
<li class="toc-h3 nav-item toc-entry"><a class="reference internal nav-link" href="#named-struct"><code class="docutils literal notranslate"><span class="pre">named_struct</span></code></a><ul class="nav section-nav flex-column">
-<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id362">Arguments</a></li>
-<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id363">Example</a></li>
+<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id365">Arguments</a></li>
+<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id366">Example</a></li>
</ul>
</li>
<li class="toc-h3 nav-item toc-entry"><a class="reference internal nav-link" href="#row"><code class="docutils literal notranslate"><span class="pre">row</span></code></a></li>
<li class="toc-h3 nav-item toc-entry"><a class="reference internal nav-link" href="#struct"><code class="docutils literal notranslate"><span class="pre">struct</span></code></a><ul class="nav section-nav flex-column">
-<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id364">Arguments</a></li>
-<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id365">Example</a></li>
-<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id366">Aliases</a></li>
+<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id367">Arguments</a></li>
+<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id368">Example</a></li>
+<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id369">Aliases</a></li>
</ul>
</li>
</ul>
@@ -7663,127 +7706,127 @@ Nested access like <code class="docutils literal notranslate"><span class="pre">
<li class="toc-h2 nav-item toc-entry"><a class="reference internal nav-link" href="#map-functions">Map Functions</a><ul class="nav section-nav flex-column">
<li class="toc-h3 nav-item toc-entry"><a class="reference internal nav-link" href="#element-at"><code class="docutils literal notranslate"><span class="pre">element_at</span></code></a></li>
<li class="toc-h3 nav-item toc-entry"><a class="reference internal nav-link" href="#map"><code class="docutils literal notranslate"><span class="pre">map</span></code></a><ul class="nav section-nav flex-column">
-<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id367">Arguments</a></li>
-<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id368">Example</a></li>
+<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id370">Arguments</a></li>
+<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id371">Example</a></li>
</ul>
</li>
<li class="toc-h3 nav-item toc-entry"><a class="reference internal nav-link" href="#map-entries"><code class="docutils literal notranslate"><span class="pre">map_entries</span></code></a><ul class="nav section-nav flex-column">
-<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id369">Arguments</a></li>
-<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id370">Example</a></li>
+<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id372">Arguments</a></li>
+<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id373">Example</a></li>
</ul>
</li>
<li class="toc-h3 nav-item toc-entry"><a class="reference internal nav-link" href="#map-extract"><code class="docutils literal notranslate"><span class="pre">map_extract</span></code></a><ul class="nav section-nav flex-column">
-<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id371">Arguments</a></li>
-<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id372">Example</a></li>
-<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id373">Aliases</a></li>
+<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id374">Arguments</a></li>
+<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id375">Example</a></li>
+<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id376">Aliases</a></li>
</ul>
</li>
<li class="toc-h3 nav-item toc-entry"><a class="reference internal nav-link" href="#map-keys"><code class="docutils literal notranslate"><span class="pre">map_keys</span></code></a><ul class="nav section-nav flex-column">
-<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id374">Arguments</a></li>
-<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id375">Example</a></li>
+<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id377">Arguments</a></li>
+<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id378">Example</a></li>
</ul>
</li>
<li class="toc-h3 nav-item toc-entry"><a class="reference internal nav-link" href="#map-values"><code class="docutils literal notranslate"><span class="pre">map_values</span></code></a><ul class="nav section-nav flex-column">
-<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id376">Arguments</a></li>
-<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id377">Example</a></li>
+<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id379">Arguments</a></li>
+<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id380">Example</a></li>
</ul>
</li>
</ul>
</li>
<li class="toc-h2 nav-item toc-entry"><a class="reference internal nav-link" href="#hashing-functions">Hashing Functions</a><ul class="nav section-nav flex-column">
<li class="toc-h3 nav-item toc-entry"><a class="reference internal nav-link" href="#digest"><code class="docutils literal notranslate"><span class="pre">digest</span></code></a><ul class="nav section-nav flex-column">
-<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id378">Arguments</a></li>
-<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id379">Example</a></li>
+<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id381">Arguments</a></li>
+<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id382">Example</a></li>
</ul>
</li>
<li class="toc-h3 nav-item toc-entry"><a class="reference internal nav-link" href="#md5"><code class="docutils literal notranslate"><span class="pre">md5</span></code></a><ul class="nav section-nav flex-column">
-<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id380">Arguments</a></li>
-<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id381">Example</a></li>
+<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id383">Arguments</a></li>
+<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id384">Example</a></li>
</ul>
</li>
<li class="toc-h3 nav-item toc-entry"><a class="reference internal nav-link" href="#sha224"><code class="docutils literal notranslate"><span class="pre">sha224</span></code></a><ul class="nav section-nav flex-column">
-<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id382">Arguments</a></li>
-<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id383">Example</a></li>
+<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id385">Arguments</a></li>
+<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id386">Example</a></li>
</ul>
</li>
<li class="toc-h3 nav-item toc-entry"><a class="reference internal nav-link" href="#sha256"><code class="docutils literal notranslate"><span class="pre">sha256</span></code></a><ul class="nav section-nav flex-column">
-<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id384">Arguments</a></li>
-<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id385">Example</a></li>
+<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id387">Arguments</a></li>
+<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id388">Example</a></li>
</ul>
</li>
<li class="toc-h3 nav-item toc-entry"><a class="reference internal nav-link" href="#sha384"><code class="docutils literal notranslate"><span class="pre">sha384</span></code></a><ul class="nav section-nav flex-column">
-<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id386">Arguments</a></li>
-<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id387">Example</a></li>
+<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id389">Arguments</a></li>
+<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id390">Example</a></li>
</ul>
</li>
<li class="toc-h3 nav-item toc-entry"><a class="reference internal nav-link" href="#sha512"><code class="docutils literal notranslate"><span class="pre">sha512</span></code></a><ul class="nav section-nav flex-column">
-<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id388">Arguments</a></li>
-<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id389">Example</a></li>
+<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id391">Arguments</a></li>
+<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id392">Example</a></li>
</ul>
</li>
</ul>
</li>
<li class="toc-h2 nav-item toc-entry"><a class="reference internal nav-link" href="#union-functions">Union Functions</a><ul class="nav section-nav flex-column">
<li class="toc-h3 nav-item toc-entry"><a class="reference internal nav-link" href="#union-extract"><code class="docutils literal notranslate"><span class="pre">union_extract</span></code></a><ul class="nav section-nav flex-column">
-<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id390">Arguments</a></li>
-<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id391">Example</a></li>
+<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id393">Arguments</a></li>
+<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id394">Example</a></li>
</ul>
</li>
<li class="toc-h3 nav-item toc-entry"><a class="reference internal nav-link" href="#union-tag"><code class="docutils literal notranslate"><span class="pre">union_tag</span></code></a><ul class="nav section-nav flex-column">
-<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id392">Arguments</a></li>
-<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id393">Example</a></li>
+<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id395">Arguments</a></li>
+<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id396">Example</a></li>
</ul>
</li>
</ul>
</li>
<li class="toc-h2 nav-item toc-entry"><a class="reference internal nav-link" href="#other-functions">Other Functions</a><ul class="nav section-nav flex-column">
<li class="toc-h3 nav-item toc-entry"><a class="reference internal nav-link" href="#arrow-cast"><code class="docutils literal notranslate"><span class="pre">arrow_cast</span></code></a><ul class="nav section-nav flex-column">
-<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id394">Arguments</a></li>
-<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id395">Example</a></li>
+<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id397">Arguments</a></li>
+<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id398">Example</a></li>
</ul>
</li>
<li class="toc-h3 nav-item toc-entry"><a class="reference internal nav-link" href="#arrow-field"><code class="docutils literal notranslate"><span class="pre">arrow_field</span></code></a><ul class="nav section-nav flex-column">
-<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id396">Arguments</a></li>
-<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id397">Example</a></li>
+<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id399">Arguments</a></li>
+<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id400">Example</a></li>
</ul>
</li>
<li class="toc-h3 nav-item toc-entry"><a class="reference internal nav-link" href="#arrow-metadata"><code class="docutils literal notranslate"><span class="pre">arrow_metadata</span></code></a><ul class="nav section-nav flex-column">
-<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id398">Arguments</a></li>
-<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id399">Example</a></li>
+<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id401">Arguments</a></li>
+<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id402">Example</a></li>
</ul>
</li>
<li class="toc-h3 nav-item toc-entry"><a class="reference internal nav-link" href="#arrow-try-cast"><code class="docutils literal notranslate"><span class="pre">arrow_try_cast</span></code></a><ul class="nav section-nav flex-column">
-<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id400">Arguments</a></li>
-<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id401">Example</a></li>
+<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id403">Arguments</a></li>
+<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id404">Example</a></li>
</ul>
</li>
<li class="toc-h3 nav-item toc-entry"><a class="reference internal nav-link" href="#arrow-typeof"><code class="docutils literal notranslate"><span class="pre">arrow_typeof</span></code></a><ul class="nav section-nav flex-column">
-<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id402">Arguments</a></li>
-<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id403">Example</a></li>
+<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id405">Arguments</a></li>
+<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id406">Example</a></li>
</ul>
</li>
<li class="toc-h3 nav-item toc-entry"><a class="reference internal nav-link" href="#cast-to-type"><code class="docutils literal notranslate"><span class="pre">cast_to_type</span></code></a><ul class="nav section-nav flex-column">
-<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id404">Arguments</a></li>
-<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id405">Example</a></li>
+<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id407">Arguments</a></li>
+<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id408">Example</a></li>
</ul>
</li>
<li class="toc-h3 nav-item toc-entry"><a class="reference internal nav-link" href="#get-field"><code class="docutils literal notranslate"><span class="pre">get_field</span></code></a><ul class="nav section-nav flex-column">
-<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id406">Arguments</a></li>
-<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id407">Example</a></li>
+<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id409">Arguments</a></li>
+<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id410">Example</a></li>
</ul>
</li>
<li class="toc-h3 nav-item toc-entry"><a class="reference internal nav-link" href="#try-cast-to-type"><code class="docutils literal notranslate"><span class="pre">try_cast_to_type</span></code></a><ul class="nav section-nav flex-column">
-<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id408">Arguments</a></li>
-<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id409">Example</a></li>
+<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id411">Arguments</a></li>
+<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id412">Example</a></li>
</ul>
</li>
<li class="toc-h3 nav-item toc-entry"><a class="reference internal nav-link" href="#version"><code class="docutils literal notranslate"><span class="pre">version</span></code></a><ul class="nav section-nav flex-column">
-<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id410">Example</a></li>
+<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id413">Example</a></li>
</ul>
</li>
<li class="toc-h3 nav-item toc-entry"><a class="reference internal nav-link" href="#with-metadata"><code class="docutils literal notranslate"><span class="pre">with_metadata</span></code></a><ul class="nav section-nav flex-column">
-<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id411">Arguments</a></li>
-<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id412">Example</a></li>
+<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id414">Arguments</a></li>
+<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id415">Example</a></li>
</ul>
</li>
</ul>
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@datafusion.apache.org
For additional commands, e-mail: commits-help@datafusion.apache.org