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/05/20 16:29:11 UTC
(datafusion) branch asf-site updated: Publish built docs triggered by 70caf372a54a088b4bcfd3b4479490f3388971d8
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 2f50765938 Publish built docs triggered by 70caf372a54a088b4bcfd3b4479490f3388971d8
2f50765938 is described below
commit 2f50765938191c7506cd1ab9e334eb2b498dea5a
Author: github-actions[bot] <gi...@users.noreply.github.com>
AuthorDate: Wed May 20 16:29:06 2026 +0000
Publish built docs triggered by 70caf372a54a088b4bcfd3b4479490f3388971d8
---
_sources/contributor-guide/api-health.md.txt | 46 +-
_sources/user-guide/sql/scalar_functions.md.txt | 34 +
contributor-guide/api-health.html | 49 +-
searchindex.js | 2 +-
user-guide/sql/scalar_functions.html | 898 +++++++++++++-----------
5 files changed, 571 insertions(+), 458 deletions(-)
diff --git a/_sources/contributor-guide/api-health.md.txt b/_sources/contributor-guide/api-health.md.txt
index f950c7cc0b..a20bc284cf 100644
--- a/_sources/contributor-guide/api-health.md.txt
+++ b/_sources/contributor-guide/api-health.md.txt
@@ -25,13 +25,13 @@ changes to avoid issues for downstream users.
## Breaking API Changes
-### What is the public API and what is a breaking API change?
+### What is the public Rust API and what is a breaking API change?
-In general, an item is part of the public API if it appears on the [docs.rs page].
+An item is part of the public Rust API if it appears on the [docs.rs page].
-Breaking public API changes are those that _require_ users to change their code
-for it to compile and execute, and are listed as "Major Changes" in the [SemVer
-Compatibility Section of the Cargo Book]. Common examples of breaking changes include:
+Breaking changes _require_ users to modify their code for it to compile and
+run, and are listed as "Major Changes" in the [SemVer Compatibility Section of
+the Cargo Book]. Common examples include:
- Adding new required parameters to a function (`foo(a: i32, b: i32)` -> `foo(a: i32, b: i32, c: i32)`)
- Removing a `pub` function
@@ -43,6 +43,16 @@ Examples of non-breaking changes include:
- Marking a function as deprecated (`#[deprecated]`)
- Adding a new function to a `trait` with a default implementation
+### What is the public SQL API and what is a breaking SQL change?
+
+DataFusion is also used as a SQL engine, so changes to SQL semantics (the
+results returned for a given query) are a form of breaking change. Even with
+no Rust API change, altering the behavior of an existing SQL construct can
+silently break downstream applications, dashboards, and tests.
+
+We apply the same caution to SQL semantics changes as to Rust API changes:
+the benefit must be weighed against the cost of breaking downstream users.
+
### When to make breaking API changes?
When possible, we prefer to avoid making breaking API changes. One common way to
@@ -54,22 +64,30 @@ change with the cost (impact on downstream users). It is often frustrating for
downstream users to change their applications, and it is even more so if they
do not gain improved capabilities.
-Examples of good reasons for making a breaking API change include:
+Examples of good reasons for a breaking API or SQL change:
-- The change allows new use cases that were not possible before
-- The change significantly enables improved performance
+- It enables new use cases that were not possible before
+- It significantly improves performance
+- The previous behavior is clearly wrong (e.g. produces incorrect results)
-Examples of potentially weak reasons for making breaking API changes include:
+Examples of potentially weak reasons:
-- The change is an internal refactor to make DataFusion more consistent
-- The change is to remove an API that is not widely used but has not been marked as deprecated
+- An internal refactor to make DataFusion more consistent
+- Removing an API that is not widely used but has not been marked as deprecated
+- Slightly improving compatibility with another database (for example,
+ PostgreSQL or DuckDB)
### What to do when making breaking API changes?
-When making breaking public API changes, please:
+When making breaking Rust API changes, please:
+
+1. Add the `api-change` label so the change is highlighted in the release notes.
+2. Document non-trivial changes in the version-specific [Upgrade Guide].
-1. Add the `api-change` label to the PR so we can highlight the changes in the release notes.
-2. Consider adding documentation to the version-specific [Upgrade Guide] if the required changes are non-trivial.
+For breaking SQL changes, also describe the previous and new behavior in the PR
+description, ideally including example queries and results where appropriate.
+This makes review easier and helps downstream users discover the affected
+semantics.
[docs.rs page]: https://docs.rs/datafusion/latest/datafusion/index.html
[semver compatibility section of the cargo book]: https://doc.rust-lang.org/cargo/reference/semver.html#change-categories
diff --git a/_sources/user-guide/sql/scalar_functions.md.txt b/_sources/user-guide/sql/scalar_functions.md.txt
index 70216e3e9b..6bf61391eb 100644
--- a/_sources/user-guide/sql/scalar_functions.md.txt
+++ b/_sources/user-guide/sql/scalar_functions.md.txt
@@ -3258,6 +3258,7 @@ _Alias of [current_date](#current_date)._
- [array_empty](#array_empty)
- [array_except](#array_except)
- [array_extract](#array_extract)
+- [array_filter](#array_filter)
- [array_has](#array_has)
- [array_has_all](#array_has_all)
- [array_has_any](#array_has_any)
@@ -3313,6 +3314,7 @@ _Alias of [current_date](#current_date)._
- [list_empty](#list_empty)
- [list_except](#list_except)
- [list_extract](#list_extract)
+- [list_filter](#list_filter)
- [list_has](#list_has)
- [list_has_all](#list_has_all)
- [list_has_any](#list_has_any)
@@ -3660,6 +3662,34 @@ array_except(array1, array2)
_Alias of [array_element](#array_element)._
+### `array_filter`
+
+filters the values of an array using a boolean lambda
+
+```sql
+array_filter(array, x -> x > 2)
+```
+
+#### Arguments
+
+- **array**: Array expression. Can be a constant, column, or function, and any combination of array operators.
+- **lambda**: Lambda that returns a boolean. Elements for which the lambda returns true are kept.
+
+#### Example
+
+```sql
+> select array_filter([1, 2, 3, 4, 5], x -> x > 2);
++--------------------------------------------+
+| array_filter([1, 2, 3, 4, 5], x -> x > 2) |
++--------------------------------------------+
+| [3, 4, 5] |
++--------------------------------------------+
+```
+
+#### Aliases
+
+- list_filter
+
### `array_has`
Returns true if the array contains the element.
@@ -4771,6 +4801,10 @@ _Alias of [array_except](#array_except)._
_Alias of [array_element](#array_element)._
+### `list_filter`
+
+_Alias of [array_filter](#array_filter)._
+
### `list_has`
_Alias of [array_has](#array_has)._
diff --git a/contributor-guide/api-health.html b/contributor-guide/api-health.html
index c01a35e5ab..76446c8d6a 100644
--- a/contributor-guide/api-health.html
+++ b/contributor-guide/api-health.html
@@ -433,12 +433,12 @@ large public API. We try to keep the API well maintained and minimize breaking
changes to avoid issues for downstream users.</p>
<section id="breaking-api-changes">
<h2>Breaking API Changes<a class="headerlink" href="#breaking-api-changes" title="Link to this heading">#</a></h2>
-<section id="what-is-the-public-api-and-what-is-a-breaking-api-change">
-<h3>What is the public API and what is a breaking API change?<a class="headerlink" href="#what-is-the-public-api-and-what-is-a-breaking-api-change" title="Link to this heading">#</a></h3>
-<p>In general, an item is part of the public API if it appears on the <a class="reference external" href="https://docs.rs/datafusion/latest/datafusion/index.html">docs.rs page</a>.</p>
-<p>Breaking public API changes are those that <em>require</em> users to change their code
-for it to compile and execute, and are listed as “Major Changes” in the <a class="reference external" href="https://doc.rust-lang.org/cargo/reference/semver.html#change-categories">SemVer
-Compatibility Section of the Cargo Book</a>. Common examples of breaking changes include:</p>
+<section id="what-is-the-public-rust-api-and-what-is-a-breaking-api-change">
+<h3>What is the public Rust API and what is a breaking API change?<a class="headerlink" href="#what-is-the-public-rust-api-and-what-is-a-breaking-api-change" title="Link to this heading">#</a></h3>
+<p>An item is part of the public Rust API if it appears on the <a class="reference external" href="https://docs.rs/datafusion/latest/datafusion/index.html">docs.rs page</a>.</p>
+<p>Breaking changes <em>require</em> users to modify their code for it to compile and
+run, and are listed as “Major Changes” in the <a class="reference external" href="https://doc.rust-lang.org/cargo/reference/semver.html#change-categories">SemVer Compatibility Section of
+the Cargo Book</a>. Common examples include:</p>
<ul class="simple">
<li><p>Adding new required parameters to a function (<code class="docutils literal notranslate"><span class="pre">foo(a:</span> <span class="pre">i32,</span> <span class="pre">b:</span> <span class="pre">i32)</span></code> -> <code class="docutils literal notranslate"><span class="pre">foo(a:</span> <span class="pre">i32,</span> <span class="pre">b:</span> <span class="pre">i32,</span> <span class="pre">c:</span> <span class="pre">i32)</span></code>)</p></li>
<li><p>Removing a <code class="docutils literal notranslate"><span class="pre">pub</span></code> function</p></li>
@@ -451,6 +451,15 @@ Compatibility Section of the Cargo Book</a>. Common examples of breaking changes
<li><p>Adding a new function to a <code class="docutils literal notranslate"><span class="pre">trait</span></code> with a default implementation</p></li>
</ul>
</section>
+<section id="what-is-the-public-sql-api-and-what-is-a-breaking-sql-change">
+<h3>What is the public SQL API and what is a breaking SQL change?<a class="headerlink" href="#what-is-the-public-sql-api-and-what-is-a-breaking-sql-change" title="Link to this heading">#</a></h3>
+<p>DataFusion is also used as a SQL engine, so changes to SQL semantics (the
+results returned for a given query) are a form of breaking change. Even with
+no Rust API change, altering the behavior of an existing SQL construct can
+silently break downstream applications, dashboards, and tests.</p>
+<p>We apply the same caution to SQL semantics changes as to Rust API changes:
+the benefit must be weighed against the cost of breaking downstream users.</p>
+</section>
<section id="when-to-make-breaking-api-changes">
<h3>When to make breaking API changes?<a class="headerlink" href="#when-to-make-breaking-api-changes" title="Link to this heading">#</a></h3>
<p>When possible, we prefer to avoid making breaking API changes. One common way to
@@ -460,24 +469,31 @@ Guidelines</a> section below.</p>
change with the cost (impact on downstream users). It is often frustrating for
downstream users to change their applications, and it is even more so if they
do not gain improved capabilities.</p>
-<p>Examples of good reasons for making a breaking API change include:</p>
+<p>Examples of good reasons for a breaking API or SQL change:</p>
<ul class="simple">
-<li><p>The change allows new use cases that were not possible before</p></li>
-<li><p>The change significantly enables improved performance</p></li>
+<li><p>It enables new use cases that were not possible before</p></li>
+<li><p>It significantly improves performance</p></li>
+<li><p>The previous behavior is clearly wrong (e.g. produces incorrect results)</p></li>
</ul>
-<p>Examples of potentially weak reasons for making breaking API changes include:</p>
+<p>Examples of potentially weak reasons:</p>
<ul class="simple">
-<li><p>The change is an internal refactor to make DataFusion more consistent</p></li>
-<li><p>The change is to remove an API that is not widely used but has not been marked as deprecated</p></li>
+<li><p>An internal refactor to make DataFusion more consistent</p></li>
+<li><p>Removing an API that is not widely used but has not been marked as deprecated</p></li>
+<li><p>Slightly improving compatibility with another database (for example,
+PostgreSQL or DuckDB)</p></li>
</ul>
</section>
<section id="what-to-do-when-making-breaking-api-changes">
<h3>What to do when making breaking API changes?<a class="headerlink" href="#what-to-do-when-making-breaking-api-changes" title="Link to this heading">#</a></h3>
-<p>When making breaking public API changes, please:</p>
+<p>When making breaking Rust API changes, please:</p>
<ol class="arabic simple">
-<li><p>Add the <code class="docutils literal notranslate"><span class="pre">api-change</span></code> label to the PR so we can highlight the changes in the release notes.</p></li>
-<li><p>Consider adding documentation to the version-specific <a class="reference internal" href="../library-user-guide/upgrading/index.html"><span class="std std-doc">Upgrade Guide</span></a> if the required changes are non-trivial.</p></li>
+<li><p>Add the <code class="docutils literal notranslate"><span class="pre">api-change</span></code> label so the change is highlighted in the release notes.</p></li>
+<li><p>Document non-trivial changes in the version-specific <a class="reference internal" href="../library-user-guide/upgrading/index.html"><span class="std std-doc">Upgrade Guide</span></a>.</p></li>
</ol>
+<p>For breaking SQL changes, also describe the previous and new behavior in the PR
+description, ideally including example queries and results where appropriate.
+This makes review easier and helps downstream users discover the affected
+semantics.</p>
</section>
</section>
<section id="upgrade-guides">
@@ -554,7 +570,8 @@ version will be <code class="docutils literal notranslate"><span class="pre">44.
<nav id="pst-page-toc-nav" class="page-toc" aria-labelledby="pst-page-navigation-heading-2">
<ul class="pst-show_toc_level nav section-nav flex-column">
<li class="toc-h2 nav-item toc-entry"><a class="reference internal nav-link" href="#breaking-api-changes">Breaking API Changes</a><ul class="nav section-nav flex-column">
-<li class="toc-h3 nav-item toc-entry"><a class="reference internal nav-link" href="#what-is-the-public-api-and-what-is-a-breaking-api-change">What is the public API and what is a breaking API change?</a></li>
+<li class="toc-h3 nav-item toc-entry"><a class="reference internal nav-link" href="#what-is-the-public-rust-api-and-what-is-a-breaking-api-change">What is the public Rust API and what is a breaking API change?</a></li>
+<li class="toc-h3 nav-item toc-entry"><a class="reference internal nav-link" href="#what-is-the-public-sql-api-and-what-is-a-breaking-sql-change">What is the public SQL API and what is a breaking SQL change?</a></li>
<li class="toc-h3 nav-item toc-entry"><a class="reference internal nav-link" href="#when-to-make-breaking-api-changes">When to make breaking API changes?</a></li>
<li class="toc-h3 nav-item toc-entry"><a class="reference internal nav-link" href="#what-to-do-when-making-breaking-api-changes">What to do when making breaking API changes?</a></li>
</ul>
diff --git a/searchindex.js b/searchindex.js
index c6892dd959..78696a0b42 100644
--- a/searchindex.js
+++ b/searchindex.js
@@ -1 +1 @@
-Search.setIndex({"alltitles":{"!=":[[73,"op-neq"]],"!~":[[73,"op-re-not-match"]],"!~*":[[73,"op-re-not-match-i"]],"!~~":[[73,"id19"]],"!~~*":[[73,"id20"]],"#":[[73,"op-bit-xor"]],"%":[[73,"op-modulo"]],"&":[[73,"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"]],"*":[[73,"op-multiply"]],"+":[[73,"op-plus"]],"-":[[73,"op-minus"]],"/":[[73,"op-divide"]],"1. Array Literal Con [...]
\ No newline at end of file
+Search.setIndex({"alltitles":{"!=":[[73,"op-neq"]],"!~":[[73,"op-re-not-match"]],"!~*":[[73,"op-re-not-match-i"]],"!~~":[[73,"id19"]],"!~~*":[[73,"id20"]],"#":[[73,"op-bit-xor"]],"%":[[73,"op-modulo"]],"&":[[73,"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"]],"*":[[73,"op-multiply"]],"+":[[73,"op-plus"]],"-":[[73,"op-minus"]],"/":[[73,"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 24fc2222cf..ff5e1aac60 100644
--- a/user-guide/sql/scalar_functions.html
+++ b/user-guide/sql/scalar_functions.html
@@ -3786,6 +3786,7 @@ Integers, unsigned integers, and floats are interpreted as seconds since the uni
<li><p><a class="reference internal" href="#array-empty">array_empty</a></p></li>
<li><p><a class="reference internal" href="#array-except">array_except</a></p></li>
<li><p><a class="reference internal" href="#array-extract">array_extract</a></p></li>
+<li><p><a class="reference internal" href="#array-filter">array_filter</a></p></li>
<li><p><a class="reference internal" href="#array-has">array_has</a></p></li>
<li><p><a class="reference internal" href="#array-has-all">array_has_all</a></p></li>
<li><p><a class="reference internal" href="#array-has-any">array_has_any</a></p></li>
@@ -3841,6 +3842,7 @@ Integers, unsigned integers, and floats are interpreted as seconds since the uni
<li><p><a class="reference internal" href="#list-empty">list_empty</a></p></li>
<li><p><a class="reference internal" href="#list-except">list_except</a></p></li>
<li><p><a class="reference internal" href="#list-extract">list_extract</a></p></li>
+<li><p><a class="reference internal" href="#list-filter">list_filter</a></p></li>
<li><p><a class="reference internal" href="#list-has">list_has</a></p></li>
<li><p><a class="reference internal" href="#list-has-all">list_has_all</a></p></li>
<li><p><a class="reference internal" href="#list-has-any">list_has_any</a></p></li>
@@ -4218,21 +4220,52 @@ Integers, unsigned integers, and floats are interpreted as seconds since the uni
<h3><code class="docutils literal notranslate"><span class="pre">array_extract</span></code><a class="headerlink" href="#array-extract" title="Link to this heading">#</a></h3>
<p><em>Alias of <a class="reference internal" href="#array-element">array_element</a>.</em></p>
</section>
+<section id="array-filter">
+<h3><code class="docutils literal notranslate"><span class="pre">array_filter</span></code><a class="headerlink" href="#array-filter" title="Link to this heading">#</a></h3>
+<p>filters the values of an array using a boolean lambda</p>
+<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="n">array_filter</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="w"> </span><span class="o">></span><span class="w"> </span><span class="mi">2</span><span class="p">)</span>
+</pre></div>
+</div>
+<section id="id242">
+<h4>Arguments<a class="headerlink" href="#id242" 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 that returns a boolean. Elements for which the lambda returns true are kept.</p></li>
+</ul>
+</section>
+<section id="id243">
+<h4>Example<a class="headerlink" href="#id243" 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_filter</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="n">array_filter</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">x< [...]
+<span class="o">+</span><span class="c1">--------------------------------------------+</span>
+<span class="o">|</span><span class="w"> </span><span class="p">[</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="o">|</span>
+<span class="o">+</span><span class="c1">--------------------------------------------+</span>
+</pre></div>
+</div>
+</section>
+<section id="id244">
+<h4>Aliases<a class="headerlink" href="#id244" title="Link to this heading">#</a></h4>
+<ul class="simple">
+<li><p>list_filter</p></li>
+</ul>
+</section>
+</section>
<section id="array-has">
<h3><code class="docutils literal notranslate"><span class="pre">array_has</span></code><a class="headerlink" href="#array-has" title="Link to this heading">#</a></h3>
<p>Returns true if the array contains the element.</p>
<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="n">array_has</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="id242">
-<h4>Arguments<a class="headerlink" href="#id242" title="Link to this heading">#</a></h4>
+<section id="id245">
+<h4>Arguments<a class="headerlink" href="#id245" 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>: Scalar or Array expression. Can be a constant, column, or function, and any combination of array operators.</p></li>
</ul>
</section>
-<section id="id243">
-<h4>Example<a class="headerlink" href="#id243" title="Link to this heading">#</a></h4>
+<section id="id246">
+<h4>Example<a class="headerlink" href="#id246" 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_has</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">2</span><span [...]
<span class="o">+</span><span class="c1">-----------------------------+</span>
<span class="o">|</span><span class="w"> </span><span class="n">array_has</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="w"> </span><span class="mi">2</span><span class="p">)</span><span class="w"> </span><span class="o">|</span>
@@ -4242,8 +4275,8 @@ Integers, unsigned integers, and floats are interpreted as seconds since the uni
</pre></div>
</div>
</section>
-<section id="id244">
-<h4>Aliases<a class="headerlink" href="#id244" title="Link to this heading">#</a></h4>
+<section id="id247">
+<h4>Aliases<a class="headerlink" href="#id247" title="Link to this heading">#</a></h4>
<ul class="simple">
<li><p>list_has</p></li>
<li><p>array_contains</p></li>
@@ -4257,15 +4290,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_has_all</span><span class="p">(</span><span class="nb">array</span><span class="p">,</span><span class="w"> </span><span class="n">sub</span><span class="o">-</span><span class="nb">array</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id245">
-<h4>Arguments<a class="headerlink" href="#id245" title="Link to this heading">#</a></h4>
+<section id="id248">
+<h4>Arguments<a class="headerlink" href="#id248" 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>sub-array</strong>: Array expression. Can be a constant, column, or function, and any combination of array operators.</p></li>
</ul>
</section>
-<section id="id246">
-<h4>Example<a class="headerlink" href="#id246" title="Link to this heading">#</a></h4>
+<section id="id249">
+<h4>Example<a class="headerlink" href="#id249" 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_has_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">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_has_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">3</span><span class="p">,</span><span class="mi">4</span><span class="p">]),</span><span class="w"> </span><span class="n">List</span><span class="p">([</span><span class="mi">2</span><span class="p">,</span><span cla [...]
@@ -4275,8 +4308,8 @@ Integers, unsigned integers, and floats are interpreted as seconds since the uni
</pre></div>
</div>
</section>
-<section id="id247">
-<h4>Aliases<a class="headerlink" href="#id247" title="Link to this heading">#</a></h4>
+<section id="id250">
+<h4>Aliases<a class="headerlink" href="#id250" title="Link to this heading">#</a></h4>
<ul class="simple">
<li><p>list_has_all</p></li>
</ul>
@@ -4288,15 +4321,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_has_any</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="id248">
-<h4>Arguments<a class="headerlink" href="#id248" title="Link to this heading">#</a></h4>
+<section id="id251">
+<h4>Arguments<a class="headerlink" href="#id251" 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="id249">
-<h4>Example<a class="headerlink" href="#id249" title="Link to this heading">#</a></h4>
+<section id="id252">
+<h4>Example<a class="headerlink" href="#id252" 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_has_any</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="p">[</span><sp [...]
<span class="o">+</span><span class="c1">------------------------------------------+</span>
<span class="o">|</span><span class="w"> </span><span class="n">array_has_any</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="w"> </span><span class="n">List</span><span class="p">([</span><span class="mi">3</span><span class="p">,</span><span class="mi">4</span><span class="p">]))</span><span c [...]
@@ -4306,8 +4339,8 @@ Integers, unsigned integers, and floats are interpreted as seconds since the uni
</pre></div>
</div>
</section>
-<section id="id250">
-<h4>Aliases<a class="headerlink" href="#id250" title="Link to this heading">#</a></h4>
+<section id="id253">
+<h4>Aliases<a class="headerlink" href="#id253" title="Link to this heading">#</a></h4>
<ul class="simple">
<li><p>list_has_any</p></li>
<li><p>arrays_overlap</p></li>
@@ -4324,15 +4357,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_intersect</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="id251">
-<h4>Arguments<a class="headerlink" href="#id251" title="Link to this heading">#</a></h4>
+<section id="id254">
+<h4>Arguments<a class="headerlink" href="#id254" 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="id252">
-<h4>Example<a class="headerlink" href="#id252" title="Link to this heading">#</a></h4>
+<section id="id255">
+<h4>Example<a class="headerlink" href="#id255" 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_intersect</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_intersect</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" [...]
@@ -4348,8 +4381,8 @@ Integers, unsigned integers, and floats are interpreted as seconds since the uni
</pre></div>
</div>
</section>
-<section id="id253">
-<h4>Aliases<a class="headerlink" href="#id253" title="Link to this heading">#</a></h4>
+<section id="id256">
+<h4>Aliases<a class="headerlink" href="#id256" title="Link to this heading">#</a></h4>
<ul class="simple">
<li><p>list_intersect</p></li>
</ul>
@@ -4365,15 +4398,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_length</span><span class="p">(</span><span class="nb">array</span><span class="p">,</span><span class="w"> </span><span class="n">dimension</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id254">
-<h4>Arguments<a class="headerlink" href="#id254" title="Link to this heading">#</a></h4>
+<section id="id257">
+<h4>Arguments<a class="headerlink" href="#id257" 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>dimension</strong>: Array dimension.</p></li>
</ul>
</section>
-<section id="id255">
-<h4>Example<a class="headerlink" href="#id255" title="Link to this heading">#</a></h4>
+<section id="id258">
+<h4>Example<a class="headerlink" href="#id258" 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_length</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="n">array_length</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="w"> </span><span class="mi">1</span><span class="p">)</span><span class=" [...]
@@ -4383,8 +4416,8 @@ Integers, unsigned integers, and floats are interpreted as seconds since the uni
</pre></div>
</div>
</section>
-<section id="id256">
-<h4>Aliases<a class="headerlink" href="#id256" title="Link to this heading">#</a></h4>
+<section id="id259">
+<h4>Aliases<a class="headerlink" href="#id259" title="Link to this heading">#</a></h4>
<ul class="simple">
<li><p>list_length</p></li>
</ul>
@@ -4396,14 +4429,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_max</span><span class="p">(</span><span class="nb">array</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id257">
-<h4>Arguments<a class="headerlink" href="#id257" title="Link to this heading">#</a></h4>
+<section id="id260">
+<h4>Arguments<a class="headerlink" href="#id260" 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="id258">
-<h4>Example<a class="headerlink" href="#id258" title="Link to this heading">#</a></h4>
+<section id="id261">
+<h4>Example<a class="headerlink" href="#id261" 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_max</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">4</span><span class="p">,</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_max</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">4</span><span class="p">,</span><span class="mi">2</span><span class="p">]))</span><span class="w"> </span><span class="o">|</span>
@@ -4413,8 +4446,8 @@ Integers, unsigned integers, and floats are interpreted as seconds since the uni
</pre></div>
</div>
</section>
-<section id="id259">
-<h4>Aliases<a class="headerlink" href="#id259" title="Link to this heading">#</a></h4>
+<section id="id262">
+<h4>Aliases<a class="headerlink" href="#id262" title="Link to this heading">#</a></h4>
<ul class="simple">
<li><p>list_max</p></li>
</ul>
@@ -4426,14 +4459,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_min</span><span class="p">(</span><span class="nb">array</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id260">
-<h4>Arguments<a class="headerlink" href="#id260" title="Link to this heading">#</a></h4>
+<section id="id263">
+<h4>Arguments<a class="headerlink" href="#id263" 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="id261">
-<h4>Example<a class="headerlink" href="#id261" title="Link to this heading">#</a></h4>
+<section id="id264">
+<h4>Example<a class="headerlink" href="#id264" 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_min</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">4</span><span class="p">,</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_min</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">4</span><span class="p">,</span><span class="mi">2</span><span class="p">]))</span><span class="w"> </span><span class="o">|</span>
@@ -4450,15 +4483,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_ndims</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="id262">
-<h4>Arguments<a class="headerlink" href="#id262" title="Link to this heading">#</a></h4>
+<section id="id265">
+<h4>Arguments<a class="headerlink" href="#id265" 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>: Array element.</p></li>
</ul>
</section>
-<section id="id263">
-<h4>Example<a class="headerlink" href="#id263" title="Link to this heading">#</a></h4>
+<section id="id266">
+<h4>Example<a class="headerlink" href="#id266" 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_ndims</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="p">[</span><spa [...]
<span class="o">+</span><span class="c1">----------------------------------+</span>
<span class="o">|</span><span class="w"> </span><span class="n">array_ndims</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="w"> </span><span class="o [...]
@@ -4468,8 +4501,8 @@ Integers, unsigned integers, and floats are interpreted as seconds since the uni
</pre></div>
</div>
</section>
-<section id="id264">
-<h4>Aliases<a class="headerlink" href="#id264" title="Link to this heading">#</a></h4>
+<section id="id267">
+<h4>Aliases<a class="headerlink" href="#id267" title="Link to this heading">#</a></h4>
<ul class="simple">
<li><p>list_ndims</p></li>
</ul>
@@ -4481,14 +4514,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_normalize</span><span class="p">(</span><span class="nb">array</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id265">
-<h4>Arguments<a class="headerlink" href="#id265" title="Link to this heading">#</a></h4>
+<section id="id268">
+<h4>Arguments<a class="headerlink" href="#id268" 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="id266">
-<h4>Example<a class="headerlink" href="#id266" title="Link to this heading">#</a></h4>
+<section id="id269">
+<h4>Example<a class="headerlink" href="#id269" 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_normalize</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="mi">4</span><span class="p">.</span><span class="mi">0</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_normalize</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">0</span><span class="p">,</span><span class="mi">4</span><span class="p">.</span><span class="mi">0</span><span class="p">]))</span><span class="w"> </span><span class="o">|</span>
@@ -4498,8 +4531,8 @@ Integers, unsigned integers, and floats are interpreted as seconds since the uni
</pre></div>
</div>
</section>
-<section id="id267">
-<h4>Aliases<a class="headerlink" href="#id267" title="Link to this heading">#</a></h4>
+<section id="id270">
+<h4>Aliases<a class="headerlink" href="#id270" title="Link to this heading">#</a></h4>
<ul class="simple">
<li><p>list_normalize</p></li>
</ul>
@@ -4511,14 +4544,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_pop_back</span><span class="p">(</span><span class="nb">array</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id268">
-<h4>Arguments<a class="headerlink" href="#id268" title="Link to this heading">#</a></h4>
+<section id="id271">
+<h4>Arguments<a class="headerlink" href="#id271" 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="id269">
-<h4>Example<a class="headerlink" href="#id269" title="Link to this heading">#</a></h4>
+<section id="id272">
+<h4>Example<a class="headerlink" href="#id272" 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_pop_back</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">array_pop_back</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="w"> </span><span class="o">|</span>
@@ -4528,8 +4561,8 @@ Integers, unsigned integers, and floats are interpreted as seconds since the uni
</pre></div>
</div>
</section>
-<section id="id270">
-<h4>Aliases<a class="headerlink" href="#id270" title="Link to this heading">#</a></h4>
+<section id="id273">
+<h4>Aliases<a class="headerlink" href="#id273" title="Link to this heading">#</a></h4>
<ul class="simple">
<li><p>list_pop_back</p></li>
</ul>
@@ -4541,14 +4574,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_pop_front</span><span class="p">(</span><span class="nb">array</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id271">
-<h4>Arguments<a class="headerlink" href="#id271" title="Link to this heading">#</a></h4>
+<section id="id274">
+<h4>Arguments<a class="headerlink" href="#id274" 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="id272">
-<h4>Example<a class="headerlink" href="#id272" title="Link to this heading">#</a></h4>
+<section id="id275">
+<h4>Example<a class="headerlink" href="#id275" 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_pop_front</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">array_pop_front</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="w"> </span><span class="o">|</span>
@@ -4558,8 +4591,8 @@ Integers, unsigned integers, and floats are interpreted as seconds since the uni
</pre></div>
</div>
</section>
-<section id="id273">
-<h4>Aliases<a class="headerlink" href="#id273" title="Link to this heading">#</a></h4>
+<section id="id276">
+<h4>Aliases<a class="headerlink" href="#id276" title="Link to this heading">#</a></h4>
<ul class="simple">
<li><p>list_pop_front</p></li>
</ul>
@@ -4572,16 +4605,16 @@ Integers, unsigned integers, and floats are interpreted as seconds since the uni
<span class="n">array_position</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">index</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id274">
-<h4>Arguments<a class="headerlink" href="#id274" title="Link to this heading">#</a></h4>
+<section id="id277">
+<h4>Arguments<a class="headerlink" href="#id277" 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 search for in the array.</p></li>
<li><p><strong>index</strong>: Index at which to start searching (1-indexed).</p></li>
</ul>
</section>
-<section id="id275">
-<h4>Example<a class="headerlink" href="#id275" title="Link to this heading">#</a></h4>
+<section id="id278">
+<h4>Example<a class="headerlink" href="#id278" 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_position</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_position</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">1</span><span class="p">,</span><span class="mi">4</span><span class="p">]),</span><span class="n">Int64</span><span c [...]
@@ -4597,8 +4630,8 @@ Integers, unsigned integers, and floats are interpreted as seconds since the uni
</pre></div>
</div>
</section>
-<section id="id276">
-<h4>Aliases<a class="headerlink" href="#id276" title="Link to this heading">#</a></h4>
+<section id="id279">
+<h4>Aliases<a class="headerlink" href="#id279" title="Link to this heading">#</a></h4>
<ul class="simple">
<li><p>list_position</p></li>
<li><p>array_indexof</p></li>
@@ -4612,15 +4645,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_positions</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="id277">
-<h4>Arguments<a class="headerlink" href="#id277" title="Link to this heading">#</a></h4>
+<section id="id280">
+<h4>Arguments<a class="headerlink" href="#id280" 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 search for in the array.</p></li>
</ul>
</section>
-<section id="id278">
-<h4>Example<a class="headerlink" href="#id278" title="Link to this heading">#</a></h4>
+<section id="id281">
+<h4>Example<a class="headerlink" href="#id281" 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_positions</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_positions</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">1</span><span class="p">,</span><span class="mi">4</span><span class="p">]),</span><span class="n">Int64</span><span [...]
@@ -4630,8 +4663,8 @@ Integers, unsigned integers, and floats are interpreted as seconds since the uni
</pre></div>
</div>
</section>
-<section id="id279">
-<h4>Aliases<a class="headerlink" href="#id279" title="Link to this heading">#</a></h4>
+<section id="id282">
+<h4>Aliases<a class="headerlink" href="#id282" title="Link to this heading">#</a></h4>
<ul class="simple">
<li><p>list_positions</p></li>
</ul>
@@ -4643,15 +4676,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_prepend</span><span class="p">(</span><span class="n">element</span><span class="p">,</span><span class="w"> </span><span class="nb">array</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id280">
-<h4>Arguments<a class="headerlink" href="#id280" title="Link to this heading">#</a></h4>
+<section id="id283">
+<h4>Arguments<a class="headerlink" href="#id283" 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 prepend to the array.</p></li>
</ul>
</section>
-<section id="id281">
-<h4>Example<a class="headerlink" href="#id281" title="Link to this heading">#</a></h4>
+<section id="id284">
+<h4>Example<a class="headerlink" href="#id284" 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_prepend</span><span class="p">(</span><span class="mi">1</span><span class="p">,</span><span class="w"> </span><span class="p">[</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 [...]
<span class="o">+</span><span class="c1">---------------------------------------+</span>
<span class="o">|</span><span class="w"> </span><span class="n">array_prepend</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">List</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="w"> </span><span class="o">|</span>
@@ -4661,8 +4694,8 @@ Integers, unsigned integers, and floats are interpreted as seconds since the uni
</pre></div>
</div>
</section>
-<section id="id282">
-<h4>Aliases<a class="headerlink" href="#id282" title="Link to this heading">#</a></h4>
+<section id="id285">
+<h4>Aliases<a class="headerlink" href="#id285" title="Link to this heading">#</a></h4>
<ul class="simple">
<li><p>list_prepend</p></li>
<li><p>array_push_front</p></li>
@@ -4684,15 +4717,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="id283">
-<h4>Arguments<a class="headerlink" href="#id283" title="Link to this heading">#</a></h4>
+<section id="id286">
+<h4>Arguments<a class="headerlink" href="#id286" 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="id284">
-<h4>Example<a class="headerlink" href="#id284" title="Link to this heading">#</a></h4>
+<section id="id287">
+<h4>Example<a class="headerlink" href="#id287" 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 [...]
@@ -4709,8 +4742,8 @@ Integers, unsigned integers, and floats are interpreted as seconds since the uni
</pre></div>
</div>
</section>
-<section id="id285">
-<h4>Aliases<a class="headerlink" href="#id285" title="Link to this heading">#</a></h4>
+<section id="id288">
+<h4>Aliases<a class="headerlink" href="#id288" title="Link to this heading">#</a></h4>
<ul class="simple">
<li><p>list_remove</p></li>
</ul>
@@ -4722,15 +4755,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="id286">
-<h4>Arguments<a class="headerlink" href="#id286" title="Link to this heading">#</a></h4>
+<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>
<li><p><strong>element</strong>: Element to be removed from the array.</p></li>
</ul>
</section>
-<section id="id287">
-<h4>Example<a class="headerlink" href="#id287" title="Link to this heading">#</a></h4>
+<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_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 [...]
@@ -4747,8 +4780,8 @@ Integers, unsigned integers, and floats are interpreted as seconds since the uni
</pre></div>
</div>
</section>
-<section id="id288">
-<h4>Aliases<a class="headerlink" href="#id288" title="Link to this heading">#</a></h4>
+<section id="id291">
+<h4>Aliases<a class="headerlink" href="#id291" title="Link to this heading">#</a></h4>
<ul class="simple">
<li><p>list_remove_all</p></li>
</ul>
@@ -4760,16 +4793,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="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>
<li><p><strong>max</strong>: Number of first occurrences to remove.</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_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= [...]
@@ -4786,8 +4819,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_n</p></li>
</ul>
@@ -4799,15 +4832,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="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>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="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_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>
@@ -4823,8 +4856,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_repeat</p></li>
</ul>
@@ -4836,16 +4869,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="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>from</strong>: Initial element.</p></li>
<li><p><strong>to</strong>: Final element.</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_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=" [...]
@@ -4855,8 +4888,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_replace</p></li>
</ul>
@@ -4868,16 +4901,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="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>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="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_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 [...]
@@ -4887,8 +4920,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_replace_all</p></li>
</ul>
@@ -4900,8 +4933,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="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>
@@ -4909,8 +4942,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="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_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 [...]
@@ -4920,8 +4953,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_n</p></li>
</ul>
@@ -4933,16 +4966,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="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>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="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_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>
@@ -4952,8 +4985,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_resize</p></li>
</ul>
@@ -4965,14 +4998,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="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>
</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_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=" [...]
@@ -4982,8 +5015,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_reverse</p></li>
</ul>
@@ -4995,8 +5028,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="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>begin</strong>: Index of the first element. If negative, it counts backward from the end of the array.</p></li>
@@ -5004,8 +5037,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="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_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" [...]
@@ -5015,8 +5048,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_slice</p></li>
</ul>
@@ -5028,16 +5061,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="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>
<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="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_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>
@@ -5047,8 +5080,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_sort</p></li>
</ul>
@@ -5060,16 +5093,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="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>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="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_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 [...]
@@ -5079,8 +5112,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_to_string</p></li>
<li><p>array_join</p></li>
@@ -5094,15 +5127,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="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>lambda</strong>: Lambda</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_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" [...]
@@ -5112,8 +5145,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_transform</p></li>
</ul>
@@ -5125,15 +5158,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="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>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="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_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"> </ [...]
@@ -5149,8 +5182,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_union</p></li>
</ul>
@@ -5166,15 +5199,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="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>: First array expression.</p></li>
<li><p><strong>array_n</strong>: Optional additional array expressions.</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">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>
@@ -5190,8 +5223,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_zip</p></li>
</ul>
@@ -5203,14 +5236,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="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>
</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="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" [...]
@@ -5227,15 +5260,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="id330">
-<h4>Arguments<a class="headerlink" href="#id330" title="Link to this heading">#</a></h4>
+<section id="id333">
+<h4>Arguments<a class="headerlink" href="#id333" 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="id331">
-<h4>Example<a class="headerlink" href="#id331" title="Link to this heading">#</a></h4>
+<section id="id334">
+<h4>Example<a class="headerlink" href="#id334" 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 [...]
@@ -5256,14 +5289,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="id332">
-<h4>Arguments<a class="headerlink" href="#id332" title="Link to this heading">#</a></h4>
+<section id="id335">
+<h4>Arguments<a class="headerlink" href="#id335" 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="id333">
-<h4>Example<a class="headerlink" href="#id333" title="Link to this heading">#</a></h4>
+<section id="id336">
+<h4>Example<a class="headerlink" href="#id336" 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>
@@ -5273,8 +5306,8 @@ Integers, unsigned integers, and floats are interpreted as seconds since the uni
</pre></div>
</div>
</section>
-<section id="id334">
-<h4>Aliases<a class="headerlink" href="#id334" title="Link to this heading">#</a></h4>
+<section id="id337">
+<h4>Aliases<a class="headerlink" href="#id337" title="Link to this heading">#</a></h4>
<ul class="simple">
<li><p>array_empty</p></li>
<li><p>list_empty</p></li>
@@ -5292,14 +5325,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="id335">
-<h4>Arguments<a class="headerlink" href="#id335" title="Link to this heading">#</a></h4>
+<section id="id338">
+<h4>Arguments<a class="headerlink" href="#id338" 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="id336">
-<h4>Example<a class="headerlink" href="#id336" title="Link to this heading">#</a></h4>
+<section id="id339">
+<h4>Example<a class="headerlink" href="#id339" 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>
@@ -5317,16 +5350,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="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>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="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">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>
@@ -5343,15 +5376,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="id339">
-<h4>Arguments<a class="headerlink" href="#id339" title="Link to this heading">#</a></h4>
+<section id="id342">
+<h4>Arguments<a class="headerlink" href="#id342" 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="id340">
-<h4>Example<a class="headerlink" href="#id340" title="Link to this heading">#</a></h4>
+<section id="id343">
+<h4>Example<a class="headerlink" href="#id343" 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 [...]
@@ -5361,8 +5394,8 @@ Integers, unsigned integers, and floats are interpreted as seconds since the uni
</pre></div>
</div>
</section>
-<section id="id341">
-<h4>Aliases<a class="headerlink" href="#id341" title="Link to this heading">#</a></h4>
+<section id="id344">
+<h4>Aliases<a class="headerlink" href="#id344" title="Link to this heading">#</a></h4>
<ul class="simple">
<li><p>dot_product</p></li>
</ul>
@@ -5424,6 +5457,10 @@ Integers, unsigned integers, and floats are interpreted as seconds since the uni
<h3><code class="docutils literal notranslate"><span class="pre">list_extract</span></code><a class="headerlink" href="#list-extract" title="Link to this heading">#</a></h3>
<p><em>Alias of <a class="reference internal" href="#array-element">array_element</a>.</em></p>
</section>
+<section id="list-filter">
+<h3><code class="docutils literal notranslate"><span class="pre">list_filter</span></code><a class="headerlink" href="#list-filter" title="Link to this heading">#</a></h3>
+<p><em>Alias of <a class="reference internal" href="#array-filter">array_filter</a>.</em></p>
+</section>
<section id="list-has">
<h3><code class="docutils literal notranslate"><span class="pre">list_has</span></code><a class="headerlink" href="#list-has" title="Link to this heading">#</a></h3>
<p><em>Alias of <a class="reference internal" href="#array-has">array_has</a>.</em></p>
@@ -5558,14 +5595,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="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>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="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">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 [...]
@@ -5575,8 +5612,8 @@ Integers, unsigned integers, and floats are interpreted as seconds since the uni
</pre></div>
</div>
</section>
-<section id="id344">
-<h4>Aliases<a class="headerlink" href="#id344" title="Link to this heading">#</a></h4>
+<section id="id347">
+<h4>Aliases<a class="headerlink" href="#id347" title="Link to this heading">#</a></h4>
<ul class="simple">
<li><p>make_list</p></li>
</ul>
@@ -5593,16 +5630,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="id345">
-<h4>Arguments<a class="headerlink" href="#id345" title="Link to this heading">#</a></h4>
+<section id="id348">
+<h4>Arguments<a class="headerlink" href="#id348" 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="id346">
-<h4>Example<a class="headerlink" href="#id346" title="Link to this heading">#</a></h4>
+<section id="id349">
+<h4>Example<a class="headerlink" href="#id349" 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>
@@ -5626,16 +5663,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="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>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="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">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>
@@ -5651,8 +5688,8 @@ Integers, unsigned integers, and floats are interpreted as seconds since the uni
</pre></div>
</div>
</section>
-<section id="id349">
-<h4>Aliases<a class="headerlink" href="#id349" title="Link to this heading">#</a></h4>
+<section id="id352">
+<h4>Aliases<a class="headerlink" href="#id352" title="Link to this heading">#</a></h4>
<ul class="simple">
<li><p>string_to_list</p></li>
</ul>
@@ -5678,15 +5715,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="id350">
-<h4>Arguments<a class="headerlink" href="#id350" title="Link to this heading">#</a></h4>
+<section id="id353">
+<h4>Arguments<a class="headerlink" href="#id353" 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="id351">
-<h4>Example<a class="headerlink" href="#id351" title="Link to this heading">#</a></h4>
+<section id="id354">
+<h4>Example<a class="headerlink" href="#id354" 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>
@@ -5721,14 +5758,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="id352">
-<h4>Arguments<a class="headerlink" href="#id352" title="Link to this heading">#</a></h4>
+<section id="id355">
+<h4>Arguments<a class="headerlink" href="#id355" 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="id353">
-<h4>Example<a class="headerlink" href="#id353" title="Link to this heading">#</a></h4>
+<section id="id356">
+<h4>Example<a class="headerlink" href="#id356" 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>
@@ -5759,8 +5796,8 @@ a struct type of fields <code class="docutils literal notranslate"><span class="
</pre></div>
</div>
</section>
-<section id="id354">
-<h4>Aliases<a class="headerlink" href="#id354" title="Link to this heading">#</a></h4>
+<section id="id357">
+<h4>Aliases<a class="headerlink" href="#id357" title="Link to this heading">#</a></h4>
<ul class="simple">
<li><p>row</p></li>
</ul>
@@ -5790,8 +5827,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="id355">
-<h4>Arguments<a class="headerlink" href="#id355" title="Link to this heading">#</a></h4>
+<section id="id358">
+<h4>Arguments<a class="headerlink" href="#id358" 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>
@@ -5799,8 +5836,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="id356">
-<h4>Example<a class="headerlink" href="#id356" title="Link to this heading">#</a></h4>
+<section id="id359">
+<h4>Example<a class="headerlink" href="#id359" 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>
@@ -5836,14 +5873,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="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>map</strong>: Map expression. Can be a constant, column, or function, and any combination of map operators.</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="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= [...]
@@ -5861,15 +5898,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="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>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="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="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>
@@ -5889,8 +5926,8 @@ For <code class="docutils literal notranslate"><span class="pre">make_map</span>
</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>element_at</p></li>
</ul>
@@ -5902,14 +5939,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="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>map</strong>: Map expression. Can be a constant, column, or function, and any combination of map 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>
<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>
@@ -5927,14 +5964,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="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>map</strong>: Map expression. Can be a constant, column, or function, and any combination of map 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>
<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>
@@ -5963,8 +6000,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="id366">
-<h4>Arguments<a class="headerlink" href="#id366" title="Link to this heading">#</a></h4>
+<section id="id369">
+<h4>Arguments<a class="headerlink" href="#id369" 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>
@@ -5981,8 +6018,8 @@ For <code class="docutils literal notranslate"><span class="pre">make_map</span>
</li>
</ul>
</section>
-<section id="id367">
-<h4>Example<a class="headerlink" href="#id367" title="Link to this heading">#</a></h4>
+<section id="id370">
+<h4>Example<a class="headerlink" href="#id370" 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>
@@ -5999,14 +6036,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="id368">
-<h4>Arguments<a class="headerlink" href="#id368" title="Link to this heading">#</a></h4>
+<section id="id371">
+<h4>Arguments<a class="headerlink" href="#id371" 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="id369">
-<h4>Example<a class="headerlink" href="#id369" title="Link to this heading">#</a></h4>
+<section id="id372">
+<h4>Example<a class="headerlink" href="#id372" 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>
@@ -6023,14 +6060,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="id370">
-<h4>Arguments<a class="headerlink" href="#id370" title="Link to this heading">#</a></h4>
+<section id="id373">
+<h4>Arguments<a class="headerlink" href="#id373" 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="id371">
-<h4>Example<a class="headerlink" href="#id371" title="Link to this heading">#</a></h4>
+<section id="id374">
+<h4>Example<a class="headerlink" href="#id374" 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>
@@ -6047,14 +6084,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="id372">
-<h4>Arguments<a class="headerlink" href="#id372" title="Link to this heading">#</a></h4>
+<section id="id375">
+<h4>Arguments<a class="headerlink" href="#id375" 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="id373">
-<h4>Example<a class="headerlink" href="#id373" title="Link to this heading">#</a></h4>
+<section id="id376">
+<h4>Example<a class="headerlink" href="#id376" 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>
@@ -6071,14 +6108,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="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>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="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="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>
@@ -6095,14 +6132,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="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>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="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="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>
@@ -6127,15 +6164,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="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>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="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="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 [...]
@@ -6156,14 +6193,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="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>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="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="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>
@@ -6199,15 +6236,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="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>: 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="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">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>
@@ -6238,14 +6275,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="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>: Expression to evaluate. The expression 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">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>
@@ -6269,15 +6306,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="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>: 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="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">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>
@@ -6300,15 +6337,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="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>: 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="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">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>
@@ -6327,14 +6364,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="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>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="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="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=" [...]
@@ -6351,15 +6388,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="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>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="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="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>
@@ -6389,15 +6426,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="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>: 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="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="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>
@@ -6436,15 +6473,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="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>: 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="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">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>
@@ -6463,8 +6500,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="id398">
-<h4>Example<a class="headerlink" href="#id398" title="Link to this heading">#</a></h4>
+<section id="id401">
+<h4>Example<a class="headerlink" href="#id401" 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>
@@ -6481,16 +6518,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="id399">
-<h4>Arguments<a class="headerlink" href="#id399" title="Link to this heading">#</a></h4>
+<section id="id402">
+<h4>Arguments<a class="headerlink" href="#id402" 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="id400">
-<h4>Example<a class="headerlink" href="#id400" title="Link to this heading">#</a></h4>
+<section id="id403">
+<h4>Example<a class="headerlink" href="#id403" 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 [...]
@@ -7176,215 +7213,221 @@ Nested access like <code class="docutils literal notranslate"><span class="pre">
</ul>
</li>
<li class="toc-h3 nav-item toc-entry"><a class="reference internal nav-link" href="#array-extract"><code class="docutils literal notranslate"><span class="pre">array_extract</span></code></a></li>
-<li class="toc-h3 nav-item toc-entry"><a class="reference internal nav-link" href="#array-has"><code class="docutils literal notranslate"><span class="pre">array_has</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-filter"><code class="docutils literal notranslate"><span class="pre">array_filter</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="#id242">Arguments</a></li>
<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id243">Example</a></li>
<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id244">Aliases</a></li>
</ul>
</li>
-<li class="toc-h3 nav-item toc-entry"><a class="reference internal nav-link" href="#array-has-all"><code class="docutils literal notranslate"><span class="pre">array_has_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-has"><code class="docutils literal notranslate"><span class="pre">array_has</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="#id245">Arguments</a></li>
<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id246">Example</a></li>
<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id247">Aliases</a></li>
</ul>
</li>
-<li class="toc-h3 nav-item toc-entry"><a class="reference internal nav-link" href="#array-has-any"><code class="docutils literal notranslate"><span class="pre">array_has_any</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-has-all"><code class="docutils literal notranslate"><span class="pre">array_has_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="#id248">Arguments</a></li>
<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id249">Example</a></li>
<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id250">Aliases</a></li>
</ul>
</li>
-<li class="toc-h3 nav-item toc-entry"><a class="reference internal nav-link" href="#array-indexof"><code class="docutils literal notranslate"><span class="pre">array_indexof</span></code></a></li>
-<li class="toc-h3 nav-item toc-entry"><a class="reference internal nav-link" href="#array-intersect"><code class="docutils literal notranslate"><span class="pre">array_intersect</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-has-any"><code class="docutils literal notranslate"><span class="pre">array_has_any</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="#id251">Arguments</a></li>
<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id252">Example</a></li>
<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id253">Aliases</a></li>
</ul>
</li>
-<li class="toc-h3 nav-item toc-entry"><a class="reference internal nav-link" href="#array-join"><code class="docutils literal notranslate"><span class="pre">array_join</span></code></a></li>
-<li class="toc-h3 nav-item toc-entry"><a class="reference internal nav-link" href="#array-length"><code class="docutils literal notranslate"><span class="pre">array_length</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-indexof"><code class="docutils literal notranslate"><span class="pre">array_indexof</span></code></a></li>
+<li class="toc-h3 nav-item toc-entry"><a class="reference internal nav-link" href="#array-intersect"><code class="docutils literal notranslate"><span class="pre">array_intersect</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="#id254">Arguments</a></li>
<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id255">Example</a></li>
<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id256">Aliases</a></li>
</ul>
</li>
-<li class="toc-h3 nav-item toc-entry"><a class="reference internal nav-link" href="#array-max"><code class="docutils literal notranslate"><span class="pre">array_max</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-join"><code class="docutils literal notranslate"><span class="pre">array_join</span></code></a></li>
+<li class="toc-h3 nav-item toc-entry"><a class="reference internal nav-link" href="#array-length"><code class="docutils literal notranslate"><span class="pre">array_length</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="#id257">Arguments</a></li>
<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id258">Example</a></li>
<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id259">Aliases</a></li>
</ul>
</li>
-<li class="toc-h3 nav-item toc-entry"><a class="reference internal nav-link" href="#array-min"><code class="docutils literal notranslate"><span class="pre">array_min</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-max"><code class="docutils literal notranslate"><span class="pre">array_max</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="#id260">Arguments</a></li>
<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id261">Example</a></li>
+<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id262">Aliases</a></li>
</ul>
</li>
-<li class="toc-h3 nav-item toc-entry"><a class="reference internal nav-link" href="#array-ndims"><code class="docutils literal notranslate"><span class="pre">array_ndims</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="#id262">Arguments</a></li>
-<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id263">Example</a></li>
-<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id264">Aliases</a></li>
+<li class="toc-h3 nav-item toc-entry"><a class="reference internal nav-link" href="#array-min"><code class="docutils literal notranslate"><span class="pre">array_min</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="#id263">Arguments</a></li>
+<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id264">Example</a></li>
</ul>
</li>
-<li class="toc-h3 nav-item toc-entry"><a class="reference internal nav-link" href="#array-normalize"><code class="docutils literal notranslate"><span class="pre">array_normalize</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-ndims"><code class="docutils literal notranslate"><span class="pre">array_ndims</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="#id265">Arguments</a></li>
<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id266">Example</a></li>
<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id267">Aliases</a></li>
</ul>
</li>
-<li class="toc-h3 nav-item toc-entry"><a class="reference internal nav-link" href="#array-pop-back"><code class="docutils literal notranslate"><span class="pre">array_pop_back</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-normalize"><code class="docutils literal notranslate"><span class="pre">array_normalize</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="#id268">Arguments</a></li>
<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id269">Example</a></li>
<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id270">Aliases</a></li>
</ul>
</li>
-<li class="toc-h3 nav-item toc-entry"><a class="reference internal nav-link" href="#array-pop-front"><code class="docutils literal notranslate"><span class="pre">array_pop_front</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-pop-back"><code class="docutils literal notranslate"><span class="pre">array_pop_back</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="#id271">Arguments</a></li>
<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id272">Example</a></li>
<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id273">Aliases</a></li>
</ul>
</li>
-<li class="toc-h3 nav-item toc-entry"><a class="reference internal nav-link" href="#array-position"><code class="docutils literal notranslate"><span class="pre">array_position</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-pop-front"><code class="docutils literal notranslate"><span class="pre">array_pop_front</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="#id274">Arguments</a></li>
<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id275">Example</a></li>
<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id276">Aliases</a></li>
</ul>
</li>
-<li class="toc-h3 nav-item toc-entry"><a class="reference internal nav-link" href="#array-positions"><code class="docutils literal notranslate"><span class="pre">array_positions</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-position"><code class="docutils literal notranslate"><span class="pre">array_position</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="#id277">Arguments</a></li>
<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id278">Example</a></li>
<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id279">Aliases</a></li>
</ul>
</li>
-<li class="toc-h3 nav-item toc-entry"><a class="reference internal nav-link" href="#array-prepend"><code class="docutils literal notranslate"><span class="pre">array_prepend</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-positions"><code class="docutils literal notranslate"><span class="pre">array_positions</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="#id280">Arguments</a></li>
<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id281">Example</a></li>
<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id282">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-prepend"><code class="docutils literal notranslate"><span class="pre">array_prepend</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="#id283">Arguments</a></li>
<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id284">Example</a></li>
<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id285">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="#id286">Arguments</a></li>
<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id287">Example</a></li>
<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-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="#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-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="#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-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="#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-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="#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-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="#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-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="#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-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="#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-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-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="#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-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="#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-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-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="#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-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="#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-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="#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="#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="#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="#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="#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="#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="#id331">Arguments</a></li>
+<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id332">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="#id330">Arguments</a></li>
-<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id331">Example</a></li>
+<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id333">Arguments</a></li>
+<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id334">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="#id332">Arguments</a></li>
-<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id333">Example</a></li>
-<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id334">Aliases</a></li>
+<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id335">Arguments</a></li>
+<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id336">Example</a></li>
+<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id337">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="#id335">Arguments</a></li>
-<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id336">Example</a></li>
+<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id338">Arguments</a></li>
+<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id339">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="#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="#id340">Arguments</a></li>
+<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id341">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="#id339">Arguments</a></li>
-<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id340">Example</a></li>
-<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id341">Aliases</a></li>
+<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="#id344">Aliases</a></li>
</ul>
</li>
<li class="toc-h3 nav-item toc-entry"><a class="reference internal nav-link" href="#list-any-match"><code class="docutils literal notranslate"><span class="pre">list_any_match</span></code></a></li>
@@ -7401,6 +7444,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-empty"><code class="docutils literal notranslate"><span class="pre">list_empty</span></code></a></li>
<li class="toc-h3 nav-item toc-entry"><a class="reference internal nav-link" href="#list-except"><code class="docutils literal notranslate"><span class="pre">list_except</span></code></a></li>
<li class="toc-h3 nav-item toc-entry"><a class="reference internal nav-link" href="#list-extract"><code class="docutils literal notranslate"><span class="pre">list_extract</span></code></a></li>
+<li class="toc-h3 nav-item toc-entry"><a class="reference internal nav-link" href="#list-filter"><code class="docutils literal notranslate"><span class="pre">list_filter</span></code></a></li>
<li class="toc-h3 nav-item toc-entry"><a class="reference internal nav-link" href="#list-has"><code class="docutils literal notranslate"><span class="pre">list_has</span></code></a></li>
<li class="toc-h3 nav-item toc-entry"><a class="reference internal nav-link" href="#list-has-all"><code class="docutils literal notranslate"><span class="pre">list_has_all</span></code></a></li>
<li class="toc-h3 nav-item toc-entry"><a class="reference internal nav-link" href="#list-has-any"><code class="docutils literal notranslate"><span class="pre">list_has_any</span></code></a></li>
@@ -7434,21 +7478,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="#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="#id344">Aliases</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>
+<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id347">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="#id345">Arguments</a></li>
-<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id346">Example</a></li>
+<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id348">Arguments</a></li>
+<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id349">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="#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>
+<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>
+<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id352">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>
@@ -7456,15 +7500,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="#id350">Arguments</a></li>
-<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id351">Example</a></li>
+<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id353">Arguments</a></li>
+<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id354">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="#id352">Arguments</a></li>
-<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id353">Example</a></li>
-<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id354">Aliases</a></li>
+<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id355">Arguments</a></li>
+<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id356">Example</a></li>
+<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id357">Aliases</a></li>
</ul>
</li>
</ul>
@@ -7472,127 +7516,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="#id355">Arguments</a></li>
-<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id356">Example</a></li>
+<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id358">Arguments</a></li>
+<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id359">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="#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="#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="#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="#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="#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="#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="#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="#id367">Arguments</a></li>
+<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id368">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="#id366">Arguments</a></li>
-<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id367">Example</a></li>
+<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>
</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="#id368">Arguments</a></li>
-<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id369">Example</a></li>
+<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>
</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="#id370">Arguments</a></li>
-<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id371">Example</a></li>
+<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id373">Arguments</a></li>
+<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id374">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="#id372">Arguments</a></li>
-<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id373">Example</a></li>
+<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id375">Arguments</a></li>
+<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id376">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="#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="#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="#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="#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="#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="#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="#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>
</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="#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="#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="#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="#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="#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="#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="#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>
<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="#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="#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="#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>
<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="#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="#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="#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="#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="#id398">Example</a></li>
+<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id401">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="#id399">Arguments</a></li>
-<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id400">Example</a></li>
+<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>
</ul>
</li>
</ul>
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@datafusion.apache.org
For additional commands, e-mail: commits-help@datafusion.apache.org