You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@datafusion.apache.org by gi...@apache.org on 2026/06/27 21:33:11 UTC
(datafusion) branch asf-site updated: Publish built docs triggered by cf1c43a95ae7e0a64d287c2f6d632a5d9e57cb80
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 09c449ff28 Publish built docs triggered by cf1c43a95ae7e0a64d287c2f6d632a5d9e57cb80
09c449ff28 is described below
commit 09c449ff28332b185fa2c5cd4ef671f89d4e5424
Author: github-actions[bot] <gi...@users.noreply.github.com>
AuthorDate: Sat Jun 27 21:33:06 2026 +0000
Publish built docs triggered by cf1c43a95ae7e0a64d287c2f6d632a5d9e57cb80
---
_sources/user-guide/sql/scalar_functions.md.txt | 33 +
searchindex.js | 2 +-
user-guide/sql/scalar_functions.html | 1087 ++++++++++++-----------
3 files changed, 599 insertions(+), 523 deletions(-)
diff --git a/_sources/user-guide/sql/scalar_functions.md.txt b/_sources/user-guide/sql/scalar_functions.md.txt
index 34a5b46f93..497d899762 100644
--- a/_sources/user-guide/sql/scalar_functions.md.txt
+++ b/_sources/user-guide/sql/scalar_functions.md.txt
@@ -3248,6 +3248,7 @@ _Alias of [current_date](#current_date)._
- [array_any_match](#array_any_match)
- [array_any_value](#array_any_value)
- [array_append](#array_append)
+- [array_avg](#array_avg)
- [array_cat](#array_cat)
- [array_compact](#array_compact)
- [array_concat](#array_concat)
@@ -3309,6 +3310,7 @@ _Alias of [current_date](#current_date)._
- [list_any_match](#list_any_match)
- [list_any_value](#list_any_value)
- [list_append](#list_append)
+- [list_avg](#list_avg)
- [list_cat](#list_cat)
- [list_compact](#list_compact)
- [list_concat](#list_concat)
@@ -3481,6 +3483,33 @@ array_append(array, element)
- array_push_back
- list_push_back
+### `array_avg`
+
+Returns the arithmetic mean (sum divided by count) of the elements of the input array. NULL elements are skipped (per SQL aggregate convention) and excluded from the count. Returns NULL if the input row is NULL, every element is NULL, or the array is empty.
+
+```sql
+array_avg(array)
+```
+
+#### Arguments
+
+- **array**: Array expression. Can be a constant, column, or function, and any combination of array operators.
+
+#### Example
+
+```sql
+> select array_avg([1.0, 2.0, 3.0]);
++----------------------------+
+| array_avg(List([1.0,2.0,3.0])) |
++----------------------------+
+| 2.0 |
++----------------------------+
+```
+
+#### Aliases
+
+- list_avg
+
### `array_cat`
_Alias of [array_concat](#array_concat)._
@@ -4909,6 +4938,10 @@ _Alias of [array_any_value](#array_any_value)._
_Alias of [array_append](#array_append)._
+### `list_avg`
+
+_Alias of [array_avg](#array_avg)._
+
### `list_cat`
_Alias of [array_concat](#array_concat)._
diff --git a/searchindex.js b/searchindex.js
index 49b0e0cff7..d9e46dc86d 100644
--- a/searchindex.js
+++ b/searchindex.js
@@ -1 +1 @@
-Search.setIndex({"alltitles":{"!=":[[74,"op-neq"]],"!~":[[74,"op-re-not-match"]],"!~*":[[74,"op-re-not-match-i"]],"!~~":[[74,"id19"]],"!~~*":[[74,"id20"]],"#":[[74,"op-bit-xor"]],"%":[[74,"op-modulo"]],"&":[[74,"op-bit-and"]],"(relation, name) tuples in logical fields and logical columns are unique":[[15,"relation-name-tuples-in-logical-fields-and-logical-columns-are-unique"]],"*":[[74,"op-multiply"]],"+":[[74,"op-plus"]],"-":[[74,"op-minus"]],"/":[[74,"op-divide"]],"1. Array Literal Con [...]
\ No newline at end of file
+Search.setIndex({"alltitles":{"!=":[[74,"op-neq"]],"!~":[[74,"op-re-not-match"]],"!~*":[[74,"op-re-not-match-i"]],"!~~":[[74,"id19"]],"!~~*":[[74,"id20"]],"#":[[74,"op-bit-xor"]],"%":[[74,"op-modulo"]],"&":[[74,"op-bit-and"]],"(relation, name) tuples in logical fields and logical columns are unique":[[15,"relation-name-tuples-in-logical-fields-and-logical-columns-are-unique"]],"*":[[74,"op-multiply"]],"+":[[74,"op-plus"]],"-":[[74,"op-minus"]],"/":[[74,"op-divide"]],"1. Array Literal Con [...]
\ No newline at end of file
diff --git a/user-guide/sql/scalar_functions.html b/user-guide/sql/scalar_functions.html
index 7633f7bd19..fffb124756 100644
--- a/user-guide/sql/scalar_functions.html
+++ b/user-guide/sql/scalar_functions.html
@@ -3791,6 +3791,7 @@ Integers, unsigned integers, and floats are interpreted as seconds since the uni
<li><p><a class="reference internal" href="#array-any-match">array_any_match</a></p></li>
<li><p><a class="reference internal" href="#array-any-value">array_any_value</a></p></li>
<li><p><a class="reference internal" href="#array-append">array_append</a></p></li>
+<li><p><a class="reference internal" href="#array-avg">array_avg</a></p></li>
<li><p><a class="reference internal" href="#array-cat">array_cat</a></p></li>
<li><p><a class="reference internal" href="#array-compact">array_compact</a></p></li>
<li><p><a class="reference internal" href="#array-concat">array_concat</a></p></li>
@@ -3852,6 +3853,7 @@ Integers, unsigned integers, and floats are interpreted as seconds since the uni
<li><p><a class="reference internal" href="#list-any-match">list_any_match</a></p></li>
<li><p><a class="reference internal" href="#list-any-value">list_any_value</a></p></li>
<li><p><a class="reference internal" href="#list-append">list_append</a></p></li>
+<li><p><a class="reference internal" href="#list-avg">list_avg</a></p></li>
<li><p><a class="reference internal" href="#list-cat">list_cat</a></p></li>
<li><p><a class="reference internal" href="#list-compact">list_compact</a></p></li>
<li><p><a class="reference internal" href="#list-concat">list_concat</a></p></li>
@@ -4036,6 +4038,36 @@ Integers, unsigned integers, and floats are interpreted as seconds since the uni
</ul>
</section>
</section>
+<section id="array-avg">
+<h3><code class="docutils literal notranslate"><span class="pre">array_avg</span></code><a class="headerlink" href="#array-avg" title="Link to this heading">#</a></h3>
+<p>Returns the arithmetic mean (sum divided by count) of the elements of the input array. NULL elements are skipped (per SQL aggregate convention) and excluded from the count. Returns NULL if the input row is NULL, every element is NULL, or the array is empty.</p>
+<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="n">array_avg</span><span class="p">(</span><span class="nb">array</span><span class="p">)</span>
+</pre></div>
+</div>
+<section id="id224">
+<h4>Arguments<a class="headerlink" href="#id224" 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="id225">
+<h4>Example<a class="headerlink" href="#id225" 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_avg</span><span class="p">([</span><span class="mi">1</span><span class="p">.</span><span class="mi">0</span><span class="p">,</span><span class="w"> </span><span class="mi">2</span><span class="p">.</span><span class="mi">0</span><span class="p">,</span><span class="w"> </span><span c [...]
+<span class="o">+</span><span class="c1">----------------------------+</span>
+<span class="o">|</span><span class="w"> </span><span class="n">array_avg</span><span class="p">(</span><span class="n">List</span><span class="p">([</span><span class="mi">1</span><span class="p">.</span><span class="mi">0</span><span class="p">,</span><span class="mi">2</span><span class="p">.</span><span class="mi">0</span><span class="p">,</span><span class="mi">3</span><span class="p">.</span><span class="mi">0</span><span class="p">]))</span><span class="w"> </span><span class="o"> [...]
+<span class="o">+</span><span class="c1">----------------------------+</span>
+<span class="o">|</span><span class="w"> </span><span class="mi">2</span><span class="p">.</span><span class="mi">0</span><span class="w"> </span><span class="o">|</span>
+<span class="o">+</span><span class="c1">----------------------------+</span>
+</pre></div>
+</div>
+</section>
+<section id="id226">
+<h4>Aliases<a class="headerlink" href="#id226" title="Link to this heading">#</a></h4>
+<ul class="simple">
+<li><p>list_avg</p></li>
+</ul>
+</section>
+</section>
<section id="array-cat">
<h3><code class="docutils literal notranslate"><span class="pre">array_cat</span></code><a class="headerlink" href="#array-cat" title="Link to this heading">#</a></h3>
<p><em>Alias of <a class="reference internal" href="#array-concat">array_concat</a>.</em></p>
@@ -4046,14 +4078,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_compact</span><span class="p">(</span><span class="nb">array</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id224">
-<h4>Arguments<a class="headerlink" href="#id224" title="Link to this heading">#</a></h4>
+<section id="id227">
+<h4>Arguments<a class="headerlink" href="#id227" 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="id225">
-<h4>Example<a class="headerlink" href="#id225" title="Link to this heading">#</a></h4>
+<section id="id228">
+<h4>Example<a class="headerlink" href="#id228" 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_compact</span><span class="p">([</span><span class="mi">1</span><span class="p">,</span><span class="w"> </span><span class="k">NULL</span><span class="p">,</span><span class="w"> </span><span class="mi">2</span><span class="p">,</span><span class="w"> </span><span class="k">NULL</span [...]
<span class="o">+</span><span class="c1">-----------+</span>
<span class="o">|</span><span class="w"> </span><span class="n">arr</span><span class="w"> </span><span class="o">|</span>
@@ -4063,8 +4095,8 @@ Integers, unsigned integers, and floats are interpreted as seconds since the uni
</pre></div>
</div>
</section>
-<section id="id226">
-<h4>Aliases<a class="headerlink" href="#id226" title="Link to this heading">#</a></h4>
+<section id="id229">
+<h4>Aliases<a class="headerlink" href="#id229" title="Link to this heading">#</a></h4>
<ul class="simple">
<li><p>list_compact</p></li>
</ul>
@@ -4076,15 +4108,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_concat</span><span class="p">(</span><span class="nb">array</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="id227">
-<h4>Arguments<a class="headerlink" href="#id227" title="Link to this heading">#</a></h4>
+<section id="id230">
+<h4>Arguments<a class="headerlink" href="#id230" 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>array_n</strong>: Subsequent array column or literal array to concatenate.</p></li>
</ul>
</section>
-<section id="id228">
-<h4>Example<a class="headerlink" href="#id228" title="Link to this heading">#</a></h4>
+<section id="id231">
+<h4>Example<a class="headerlink" href="#id231" 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_concat</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><spa [...]
<span class="o">+</span><span class="c1">---------------------------------------------------+</span>
<span class="o">|</span><span class="w"> </span><span class="n">array_concat</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="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 class="n">List</span><span class="p">([</span><span class="mi">5</span><spa [...]
@@ -4094,8 +4126,8 @@ Integers, unsigned integers, and floats are interpreted as seconds since the uni
</pre></div>
</div>
</section>
-<section id="id229">
-<h4>Aliases<a class="headerlink" href="#id229" title="Link to this heading">#</a></h4>
+<section id="id232">
+<h4>Aliases<a class="headerlink" href="#id232" title="Link to this heading">#</a></h4>
<ul class="simple">
<li><p>array_cat</p></li>
<li><p>list_concat</p></li>
@@ -4113,14 +4145,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_dims</span><span class="p">(</span><span class="nb">array</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id230">
-<h4>Arguments<a class="headerlink" href="#id230" title="Link to this heading">#</a></h4>
+<section id="id233">
+<h4>Arguments<a class="headerlink" href="#id233" 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="id231">
-<h4>Example<a class="headerlink" href="#id231" title="Link to this heading">#</a></h4>
+<section id="id234">
+<h4>Example<a class="headerlink" href="#id234" 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_dims</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><span [...]
<span class="o">+</span><span class="c1">---------------------------------+</span>
<span class="o">|</span><span class="w"> </span><span class="n">array_dims</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" [...]
@@ -4130,8 +4162,8 @@ Integers, unsigned integers, and floats are interpreted as seconds since the uni
</pre></div>
</div>
</section>
-<section id="id232">
-<h4>Aliases<a class="headerlink" href="#id232" title="Link to this heading">#</a></h4>
+<section id="id235">
+<h4>Aliases<a class="headerlink" href="#id235" title="Link to this heading">#</a></h4>
<ul class="simple">
<li><p>list_dims</p></li>
</ul>
@@ -4143,15 +4175,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_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="id233">
-<h4>Arguments<a class="headerlink" href="#id233" title="Link to this heading">#</a></h4>
+<section id="id236">
+<h4>Arguments<a class="headerlink" href="#id236" 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="id234">
-<h4>Example<a class="headerlink" href="#id234" title="Link to this heading">#</a></h4>
+<section id="id237">
+<h4>Example<a class="headerlink" href="#id237" 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_distance</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">1</span><span class="p">,</span><span class="w"> </span><s [...]
<span class="o">+</span><span class="c1">------------------------------------+</span>
<span class="o">|</span><span class="w"> </span><span class="n">array_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">2</span><span class="p">],</span><span class="w"> </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="w"> </span><span class="o">|</span>
@@ -4161,8 +4193,8 @@ Integers, unsigned integers, and floats are interpreted as seconds since the uni
</pre></div>
</div>
</section>
-<section id="id235">
-<h4>Aliases<a class="headerlink" href="#id235" title="Link to this heading">#</a></h4>
+<section id="id238">
+<h4>Aliases<a class="headerlink" href="#id238" title="Link to this heading">#</a></h4>
<ul class="simple">
<li><p>list_distance</p></li>
</ul>
@@ -4174,14 +4206,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_distinct</span><span class="p">(</span><span class="nb">array</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id236">
-<h4>Arguments<a class="headerlink" href="#id236" title="Link to this heading">#</a></h4>
+<section id="id239">
+<h4>Arguments<a class="headerlink" href="#id239" 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="id237">
-<h4>Example<a class="headerlink" href="#id237" title="Link to this heading">#</a></h4>
+<section id="id240">
+<h4>Example<a class="headerlink" href="#id240" 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_distinct</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="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_distinct</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="o">|</span>
@@ -4191,8 +4223,8 @@ Integers, unsigned integers, and floats are interpreted as seconds since the uni
</pre></div>
</div>
</section>
-<section id="id238">
-<h4>Aliases<a class="headerlink" href="#id238" title="Link to this heading">#</a></h4>
+<section id="id241">
+<h4>Aliases<a class="headerlink" href="#id241" title="Link to this heading">#</a></h4>
<ul class="simple">
<li><p>list_distinct</p></li>
</ul>
@@ -4204,15 +4236,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_element</span><span class="p">(</span><span class="nb">array</span><span class="p">,</span><span class="w"> </span><span class="k">index</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id239">
-<h4>Arguments<a class="headerlink" href="#id239" title="Link to this heading">#</a></h4>
+<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>index</strong>: Index to extract the element from the array.</p></li>
</ul>
</section>
-<section id="id240">
-<h4>Example<a class="headerlink" href="#id240" title="Link to this heading">#</a></h4>
+<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_element</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_element</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="n">Int64</span><span class="p">(</span><span class="mi">3</span><span class="p">))</span><span class="w"> </span><span cl [...]
@@ -4222,8 +4254,8 @@ Integers, unsigned integers, and floats are interpreted as seconds since the uni
</pre></div>
</div>
</section>
-<section id="id241">
-<h4>Aliases<a class="headerlink" href="#id241" title="Link to this heading">#</a></h4>
+<section id="id244">
+<h4>Aliases<a class="headerlink" href="#id244" title="Link to this heading">#</a></h4>
<ul class="simple">
<li><p>array_extract</p></li>
<li><p>list_element</p></li>
@@ -4241,15 +4273,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_except</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="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>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="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_except</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_except</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"> < [...]
@@ -4265,8 +4297,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_except</p></li>
</ul>
@@ -4282,15 +4314,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_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="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>lambda</strong>: Lambda that returns a boolean. Elements for which the lambda returns true are kept.</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_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< [...]
@@ -4300,8 +4332,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_filter</p></li>
</ul>
@@ -4313,15 +4345,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</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="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>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="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</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>
@@ -4331,8 +4363,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</p></li>
<li><p>array_contains</p></li>
@@ -4346,15 +4378,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="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>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="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_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 [...]
@@ -4364,8 +4396,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_has_all</p></li>
</ul>
@@ -4377,15 +4409,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="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>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="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_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 [...]
@@ -4395,8 +4427,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_has_any</p></li>
<li><p>arrays_overlap</p></li>
@@ -4413,15 +4445,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="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>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="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_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" [...]
@@ -4437,8 +4469,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_intersect</p></li>
</ul>
@@ -4454,15 +4486,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="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>
<li><p><strong>dimension</strong>: Array dimension.</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_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=" [...]
@@ -4472,8 +4504,8 @@ Integers, unsigned integers, and floats are interpreted as seconds since the uni
</pre></div>
</div>
</section>
-<section id="id262">
-<h4>Aliases<a class="headerlink" href="#id262" title="Link to this heading">#</a></h4>
+<section id="id265">
+<h4>Aliases<a class="headerlink" href="#id265" title="Link to this heading">#</a></h4>
<ul class="simple">
<li><p>list_length</p></li>
</ul>
@@ -4485,14 +4517,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="id263">
-<h4>Arguments<a class="headerlink" href="#id263" title="Link to this heading">#</a></h4>
+<section id="id266">
+<h4>Arguments<a class="headerlink" href="#id266" 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="id264">
-<h4>Example<a class="headerlink" href="#id264" title="Link to this heading">#</a></h4>
+<section id="id267">
+<h4>Example<a class="headerlink" href="#id267" 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>
@@ -4502,8 +4534,8 @@ Integers, unsigned integers, and floats are interpreted as seconds since the uni
</pre></div>
</div>
</section>
-<section id="id265">
-<h4>Aliases<a class="headerlink" href="#id265" title="Link to this heading">#</a></h4>
+<section id="id268">
+<h4>Aliases<a class="headerlink" href="#id268" title="Link to this heading">#</a></h4>
<ul class="simple">
<li><p>list_max</p></li>
</ul>
@@ -4515,14 +4547,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="id266">
-<h4>Arguments<a class="headerlink" href="#id266" title="Link to this heading">#</a></h4>
+<section id="id269">
+<h4>Arguments<a class="headerlink" href="#id269" 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="id267">
-<h4>Example<a class="headerlink" href="#id267" title="Link to this heading">#</a></h4>
+<section id="id270">
+<h4>Example<a class="headerlink" href="#id270" 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>
@@ -4539,15 +4571,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="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>
<li><p><strong>element</strong>: Array element.</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_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 [...]
@@ -4557,8 +4589,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_ndims</p></li>
</ul>
@@ -4570,14 +4602,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="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_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>
@@ -4587,8 +4619,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_normalize</p></li>
</ul>
@@ -4600,14 +4632,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="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>
</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_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>
@@ -4617,8 +4649,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_pop_back</p></li>
</ul>
@@ -4630,14 +4662,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="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>
</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_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>
@@ -4647,8 +4679,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_pop_front</p></li>
</ul>
@@ -4661,16 +4693,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="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 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="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_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 [...]
@@ -4686,8 +4718,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_position</p></li>
<li><p>array_indexof</p></li>
@@ -4701,15 +4733,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="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 search for in 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_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 [...]
@@ -4719,8 +4751,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_positions</p></li>
</ul>
@@ -4732,15 +4764,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="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 prepend to 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_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>
@@ -4750,8 +4782,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_prepend</p></li>
<li><p>array_push_front</p></li>
@@ -4765,14 +4797,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_product</span><span class="p">(</span><span class="nb">array</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id289">
-<h4>Arguments<a class="headerlink" href="#id289" title="Link to this heading">#</a></h4>
+<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>
</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_product</span><span class="p">([</span><span class="mi">1</span><span class="p">.</span><span class="mi">0</span><span class="p">,</span><span class="w"> </span><span class="mi">2</span><span class="p">.</span><span class="mi">0</span><span class="p">,</span><span class="w"> </span><sp [...]
<span class="o">+</span><span class="c1">------------------------------------+</span>
<span class="o">|</span><span class="w"> </span><span class="n">array_product</span><span class="p">(</span><span class="n">List</span><span class="p">([</span><span class="mi">1</span><span class="p">.</span><span class="mi">0</span><span class="p">,</span><span class="mi">2</span><span class="p">.</span><span class="mi">0</span><span class="p">,</span><span class="mi">3</span><span class="p">.</span><span class="mi">0</span><span class="p">]))</span><span class="w"> </span><span class= [...]
@@ -4782,8 +4814,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_product</p></li>
</ul>
@@ -4803,15 +4835,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="id292">
-<h4>Arguments<a class="headerlink" href="#id292" title="Link to this heading">#</a></h4>
+<section id="id295">
+<h4>Arguments<a class="headerlink" href="#id295" title="Link to this heading">#</a></h4>
<ul class="simple">
<li><p><strong>array</strong>: Array expression. Can be a constant, column, or function, and any combination of array operators.</p></li>
<li><p><strong>element</strong>: Element to be removed from the array.</p></li>
</ul>
</section>
-<section id="id293">
-<h4>Example<a class="headerlink" href="#id293" title="Link to this heading">#</a></h4>
+<section id="id296">
+<h4>Example<a class="headerlink" href="#id296" title="Link to this heading">#</a></h4>
<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="o">></span><span class="w"> </span><span class="k">select</span><span class="w"> </span><span class="n">array_remove</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 [...]
@@ -4828,8 +4860,8 @@ Integers, unsigned integers, and floats are interpreted as seconds since the uni
</pre></div>
</div>
</section>
-<section id="id294">
-<h4>Aliases<a class="headerlink" href="#id294" title="Link to this heading">#</a></h4>
+<section id="id297">
+<h4>Aliases<a class="headerlink" href="#id297" title="Link to this heading">#</a></h4>
<ul class="simple">
<li><p>list_remove</p></li>
</ul>
@@ -4841,15 +4873,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="id295">
-<h4>Arguments<a class="headerlink" href="#id295" title="Link to this heading">#</a></h4>
+<section id="id298">
+<h4>Arguments<a class="headerlink" href="#id298" title="Link to this heading">#</a></h4>
<ul class="simple">
<li><p><strong>array</strong>: Array expression. Can be a constant, column, or function, and any combination of array operators.</p></li>
<li><p><strong>element</strong>: Element to be removed from the array.</p></li>
</ul>
</section>
-<section id="id296">
-<h4>Example<a class="headerlink" href="#id296" title="Link to this heading">#</a></h4>
+<section id="id299">
+<h4>Example<a class="headerlink" href="#id299" title="Link to this heading">#</a></h4>
<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="o">></span><span class="w"> </span><span class="k">select</span><span class="w"> </span><span class="n">array_remove_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 [...]
@@ -4866,8 +4898,8 @@ Integers, unsigned integers, and floats are interpreted as seconds since the uni
</pre></div>
</div>
</section>
-<section id="id297">
-<h4>Aliases<a class="headerlink" href="#id297" title="Link to this heading">#</a></h4>
+<section id="id300">
+<h4>Aliases<a class="headerlink" href="#id300" title="Link to this heading">#</a></h4>
<ul class="simple">
<li><p>list_remove_all</p></li>
</ul>
@@ -4879,16 +4911,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="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>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="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_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= [...]
@@ -4905,8 +4937,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_remove_n</p></li>
</ul>
@@ -4918,15 +4950,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="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>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="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_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>
@@ -4941,9 +4973,9 @@ Integers, unsigned integers, and floats are interpreted as seconds since the uni
<span class="o">+</span><span class="c1">------------------------------------+</span>
</pre></div>
</div>
-</section>
-<section id="id303">
-<h4>Aliases<a class="headerlink" href="#id303" title="Link to this heading">#</a></h4>
+</section>
+<section id="id306">
+<h4>Aliases<a class="headerlink" href="#id306" title="Link to this heading">#</a></h4>
<ul class="simple">
<li><p>list_repeat</p></li>
</ul>
@@ -4955,16 +4987,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="id304">
-<h4>Arguments<a class="headerlink" href="#id304" title="Link to this heading">#</a></h4>
+<section id="id307">
+<h4>Arguments<a class="headerlink" href="#id307" title="Link to this heading">#</a></h4>
<ul class="simple">
<li><p><strong>array</strong>: Array expression. Can be a constant, column, or function, and any combination of array operators.</p></li>
<li><p><strong>from</strong>: Initial element.</p></li>
<li><p><strong>to</strong>: Final element.</p></li>
</ul>
</section>
-<section id="id305">
-<h4>Example<a class="headerlink" href="#id305" title="Link to this heading">#</a></h4>
+<section id="id308">
+<h4>Example<a class="headerlink" href="#id308" title="Link to this heading">#</a></h4>
<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="o">></span><span class="w"> </span><span class="k">select</span><span class="w"> </span><span class="n">array_replace</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=" [...]
@@ -4974,8 +5006,8 @@ Integers, unsigned integers, and floats are interpreted as seconds since the uni
</pre></div>
</div>
</section>
-<section id="id306">
-<h4>Aliases<a class="headerlink" href="#id306" title="Link to this heading">#</a></h4>
+<section id="id309">
+<h4>Aliases<a class="headerlink" href="#id309" title="Link to this heading">#</a></h4>
<ul class="simple">
<li><p>list_replace</p></li>
</ul>
@@ -4987,16 +5019,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="id307">
-<h4>Arguments<a class="headerlink" href="#id307" title="Link to this heading">#</a></h4>
+<section id="id310">
+<h4>Arguments<a class="headerlink" href="#id310" title="Link to this heading">#</a></h4>
<ul class="simple">
<li><p><strong>array</strong>: Array expression. Can be a constant, column, or function, and any combination of array operators.</p></li>
<li><p><strong>from</strong>: Initial element.</p></li>
<li><p><strong>to</strong>: Final element.</p></li>
</ul>
</section>
-<section id="id308">
-<h4>Example<a class="headerlink" href="#id308" title="Link to this heading">#</a></h4>
+<section id="id311">
+<h4>Example<a class="headerlink" href="#id311" title="Link to this heading">#</a></h4>
<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="o">></span><span class="w"> </span><span class="k">select</span><span class="w"> </span><span class="n">array_replace_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 [...]
@@ -5006,8 +5038,8 @@ Integers, unsigned integers, and floats are interpreted as seconds since the uni
</pre></div>
</div>
</section>
-<section id="id309">
-<h4>Aliases<a class="headerlink" href="#id309" title="Link to this heading">#</a></h4>
+<section id="id312">
+<h4>Aliases<a class="headerlink" href="#id312" title="Link to this heading">#</a></h4>
<ul class="simple">
<li><p>list_replace_all</p></li>
</ul>
@@ -5019,8 +5051,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="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>from</strong>: Initial element.</p></li>
@@ -5028,8 +5060,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="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_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 [...]
@@ -5039,8 +5071,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_replace_n</p></li>
</ul>
@@ -5052,16 +5084,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="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>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="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_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>
@@ -5071,8 +5103,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_resize</p></li>
</ul>
@@ -5084,14 +5116,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="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>
</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_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=" [...]
@@ -5101,8 +5133,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_reverse</p></li>
</ul>
@@ -5114,15 +5146,15 @@ Integers, unsigned integers, and floats are interpreted as seconds since the uni
<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="n">array_scale</span><span class="p">(</span><span class="nb">array</span><span class="p">,</span><span class="w"> </span><span class="n">scalar</span><span class="p">)</span>
</pre></div>
</div>
-<section id="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>scalar</strong>: Numeric scalar to multiply each element by. Can be a constant or column expression.</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_scale</span><span class="p">([</span><span class="mi">1</span><span class="p">.</span><span class="mi">0</span><span class="p">,</span><span class="w"> </span><span class="mi">2</span><span class="p">.</span><span class="mi">0</span><span class="p">,</span><span class="w"> </span><span [...]
<span class="o">+</span><span class="c1">----------------------------------+</span>
<span class="o">|</span><span class="w"> </span><span class="n">array_scale</span><span class="p">(</span><span class="n">List</span><span class="p">([</span><span class="mi">1</span><span class="p">.</span><span class="mi">0</span><span class="p">,</span><span class="mi">2</span><span class="p">.</span><span class="mi">0</span><span class="p">,</span><span class="mi">3</span><span class="p">.</span><span class="mi">0</span><span class="p">]),</span><span class="n">Float64</span><span cl [...]
@@ -5132,8 +5164,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_scale</p></li>
</ul>
@@ -5145,8 +5177,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="id322">
-<h4>Arguments<a class="headerlink" href="#id322" title="Link to this heading">#</a></h4>
+<section id="id325">
+<h4>Arguments<a class="headerlink" href="#id325" title="Link to this heading">#</a></h4>
<ul class="simple">
<li><p><strong>array</strong>: Array expression. Can be a constant, column, or function, and any combination of array operators.</p></li>
<li><p><strong>begin</strong>: Index of the first element. If negative, it counts backward from the end of the array.</p></li>
@@ -5154,8 +5186,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="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_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" [...]
@@ -5165,8 +5197,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_slice</p></li>
</ul>
@@ -5178,16 +5210,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="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>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="id326">
-<h4>Example<a class="headerlink" href="#id326" title="Link to this heading">#</a></h4>
+<section id="id329">
+<h4>Example<a class="headerlink" href="#id329" title="Link to this heading">#</a></h4>
<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="o">></span><span class="w"> </span><span class="k">select</span><span class="w"> </span><span class="n">array_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>
@@ -5197,8 +5229,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_sort</p></li>
</ul>
@@ -5210,15 +5242,15 @@ Integers, unsigned integers, and floats are interpreted as seconds since the uni
<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="n">array_subtract</span><span class="p">(</span><span class="n">array1</span><span class="p">,</span><span class="w"> </span><span class="n">array2</span><span class="p">)</span>
</pre></div>
</div>
-<section id="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>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="id329">
-<h4>Example<a class="headerlink" href="#id329" title="Link to this heading">#</a></h4>
+<section id="id332">
+<h4>Example<a class="headerlink" href="#id332" title="Link to this heading">#</a></h4>
<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="o">></span><span class="w"> </span><span class="k">select</span><span class="w"> </span><span class="n">array_subtract</span><span class="p">([</span><span class="mi">10</span><span class="p">.</span><span class="mi">0</span><span class="p">,</span><span class="w"> </span><span class="mi">20</span><span class="p">.</span><span class="mi">0</span><span class="p">,</span><span class="w"> </span> [...]
<span class="o">+</span><span class="c1">--------------------------------------------------------------+</span>
<span class="o">|</span><span class="w"> </span><span class="n">array_subtract</span><span class="p">(</span><span class="n">List</span><span class="p">([</span><span class="mi">10</span><span class="p">.</span><span class="mi">0</span><span class="p">,</span><span class="mi">20</span><span class="p">.</span><span class="mi">0</span><span class="p">,</span><span class="mi">30</span><span class="p">.</span><span class="mi">0</span><span class="p">]),</span><span class="n">List</span><span [...]
@@ -5228,8 +5260,8 @@ Integers, unsigned integers, and floats are interpreted as seconds since the uni
</pre></div>
</div>
</section>
-<section id="id330">
-<h4>Aliases<a class="headerlink" href="#id330" title="Link to this heading">#</a></h4>
+<section id="id333">
+<h4>Aliases<a class="headerlink" href="#id333" title="Link to this heading">#</a></h4>
<ul class="simple">
<li><p>list_subtract</p></li>
</ul>
@@ -5241,14 +5273,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_sum</span><span class="p">(</span><span class="nb">array</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id331">
-<h4>Arguments<a class="headerlink" href="#id331" title="Link to this heading">#</a></h4>
+<section id="id334">
+<h4>Arguments<a class="headerlink" href="#id334" title="Link to this heading">#</a></h4>
<ul class="simple">
<li><p><strong>array</strong>: Array expression. Can be a constant, column, or function, and any combination of array operators.</p></li>
</ul>
</section>
-<section id="id332">
-<h4>Example<a class="headerlink" href="#id332" title="Link to this heading">#</a></h4>
+<section id="id335">
+<h4>Example<a class="headerlink" href="#id335" title="Link to this heading">#</a></h4>
<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="o">></span><span class="w"> </span><span class="k">select</span><span class="w"> </span><span class="n">array_sum</span><span class="p">([</span><span class="mi">1</span><span class="p">.</span><span class="mi">0</span><span class="p">,</span><span class="w"> </span><span class="mi">2</span><span class="p">.</span><span class="mi">0</span><span class="p">,</span><span class="w"> </span><span c [...]
<span class="o">+</span><span class="c1">----------------------------+</span>
<span class="o">|</span><span class="w"> </span><span class="n">array_sum</span><span class="p">(</span><span class="n">List</span><span class="p">([</span><span class="mi">1</span><span class="p">.</span><span class="mi">0</span><span class="p">,</span><span class="mi">2</span><span class="p">.</span><span class="mi">0</span><span class="p">,</span><span class="mi">3</span><span class="p">.</span><span class="mi">0</span><span class="p">]))</span><span class="w"> </span><span class="o"> [...]
@@ -5258,8 +5290,8 @@ Integers, unsigned integers, and floats are interpreted as seconds since the uni
</pre></div>
</div>
</section>
-<section id="id333">
-<h4>Aliases<a class="headerlink" href="#id333" title="Link to this heading">#</a></h4>
+<section id="id336">
+<h4>Aliases<a class="headerlink" href="#id336" title="Link to this heading">#</a></h4>
<ul class="simple">
<li><p>list_sum</p></li>
</ul>
@@ -5271,16 +5303,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="id334">
-<h4>Arguments<a class="headerlink" href="#id334" title="Link to this heading">#</a></h4>
+<section id="id337">
+<h4>Arguments<a class="headerlink" href="#id337" title="Link to this heading">#</a></h4>
<ul class="simple">
<li><p><strong>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="id335">
-<h4>Example<a class="headerlink" href="#id335" title="Link to this heading">#</a></h4>
+<section id="id338">
+<h4>Example<a class="headerlink" href="#id338" title="Link to this heading">#</a></h4>
<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="o">></span><span class="w"> </span><span class="k">select</span><span class="w"> </span><span class="n">array_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 [...]
@@ -5290,8 +5322,8 @@ Integers, unsigned integers, and floats are interpreted as seconds since the uni
</pre></div>
</div>
</section>
-<section id="id336">
-<h4>Aliases<a class="headerlink" href="#id336" title="Link to this heading">#</a></h4>
+<section id="id339">
+<h4>Aliases<a class="headerlink" href="#id339" title="Link to this heading">#</a></h4>
<ul class="simple">
<li><p>list_to_string</p></li>
<li><p>array_join</p></li>
@@ -5305,15 +5337,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="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>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="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">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" [...]
@@ -5323,8 +5355,8 @@ Integers, unsigned integers, and floats are interpreted as seconds since the uni
</pre></div>
</div>
</section>
-<section id="id339">
-<h4>Aliases<a class="headerlink" href="#id339" title="Link to this heading">#</a></h4>
+<section id="id342">
+<h4>Aliases<a class="headerlink" href="#id342" title="Link to this heading">#</a></h4>
<ul class="simple">
<li><p>list_transform</p></li>
</ul>
@@ -5336,15 +5368,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="id340">
-<h4>Arguments<a class="headerlink" href="#id340" title="Link to this heading">#</a></h4>
+<section id="id343">
+<h4>Arguments<a class="headerlink" href="#id343" title="Link to this heading">#</a></h4>
<ul class="simple">
<li><p><strong>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="id341">
-<h4>Example<a class="headerlink" href="#id341" title="Link to this heading">#</a></h4>
+<section id="id344">
+<h4>Example<a class="headerlink" href="#id344" title="Link to this heading">#</a></h4>
<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="o">></span><span class="w"> </span><span class="k">select</span><span class="w"> </span><span class="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"> </ [...]
@@ -5360,8 +5392,8 @@ Integers, unsigned integers, and floats are interpreted as seconds since the uni
</pre></div>
</div>
</section>
-<section id="id342">
-<h4>Aliases<a class="headerlink" href="#id342" title="Link to this heading">#</a></h4>
+<section id="id345">
+<h4>Aliases<a class="headerlink" href="#id345" title="Link to this heading">#</a></h4>
<ul class="simple">
<li><p>list_union</p></li>
</ul>
@@ -5377,15 +5409,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="id343">
-<h4>Arguments<a class="headerlink" href="#id343" title="Link to this heading">#</a></h4>
+<section id="id346">
+<h4>Arguments<a class="headerlink" href="#id346" 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="id344">
-<h4>Example<a class="headerlink" href="#id344" title="Link to this heading">#</a></h4>
+<section id="id347">
+<h4>Example<a class="headerlink" href="#id347" 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>
@@ -5401,8 +5433,8 @@ Integers, unsigned integers, and floats are interpreted as seconds since the uni
</pre></div>
</div>
</section>
-<section id="id345">
-<h4>Aliases<a class="headerlink" href="#id345" title="Link to this heading">#</a></h4>
+<section id="id348">
+<h4>Aliases<a class="headerlink" href="#id348" title="Link to this heading">#</a></h4>
<ul class="simple">
<li><p>list_zip</p></li>
</ul>
@@ -5414,14 +5446,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="id346">
-<h4>Arguments<a class="headerlink" href="#id346" title="Link to this heading">#</a></h4>
+<section id="id349">
+<h4>Arguments<a class="headerlink" href="#id349" 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="id347">
-<h4>Example<a class="headerlink" href="#id347" title="Link to this heading">#</a></h4>
+<section id="id350">
+<h4>Example<a class="headerlink" href="#id350" 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" [...]
@@ -5438,15 +5470,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="id348">
-<h4>Arguments<a class="headerlink" href="#id348" title="Link to this heading">#</a></h4>
+<section id="id351">
+<h4>Arguments<a class="headerlink" href="#id351" 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="id349">
-<h4>Example<a class="headerlink" href="#id349" title="Link to this heading">#</a></h4>
+<section id="id352">
+<h4>Example<a class="headerlink" href="#id352" 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 [...]
@@ -5467,14 +5499,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="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>array</strong>: Array expression. Can be a constant, column, or function, and any combination of array 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>
<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>
@@ -5484,8 +5516,8 @@ Integers, unsigned integers, and floats are interpreted as seconds since the uni
</pre></div>
</div>
</section>
-<section id="id352">
-<h4>Aliases<a class="headerlink" href="#id352" title="Link to this heading">#</a></h4>
+<section id="id355">
+<h4>Aliases<a class="headerlink" href="#id355" title="Link to this heading">#</a></h4>
<ul class="simple">
<li><p>array_empty</p></li>
<li><p>list_empty</p></li>
@@ -5503,14 +5535,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="id353">
-<h4>Arguments<a class="headerlink" href="#id353" title="Link to this heading">#</a></h4>
+<section id="id356">
+<h4>Arguments<a class="headerlink" href="#id356" 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="id354">
-<h4>Example<a class="headerlink" href="#id354" title="Link to this heading">#</a></h4>
+<section id="id357">
+<h4>Example<a class="headerlink" href="#id357" 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>
@@ -5528,16 +5560,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="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>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="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="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>
@@ -5554,15 +5586,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="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>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="id358">
-<h4>Example<a class="headerlink" href="#id358" title="Link to this heading">#</a></h4>
+<section id="id361">
+<h4>Example<a class="headerlink" href="#id361" title="Link to this heading">#</a></h4>
<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="o">></span><span class="w"> </span><span class="k">select</span><span class="w"> </span><span class="n">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 [...]
@@ -5572,8 +5604,8 @@ Integers, unsigned integers, and floats are interpreted as seconds since the uni
</pre></div>
</div>
</section>
-<section id="id359">
-<h4>Aliases<a class="headerlink" href="#id359" title="Link to this heading">#</a></h4>
+<section id="id362">
+<h4>Aliases<a class="headerlink" href="#id362" title="Link to this heading">#</a></h4>
<ul class="simple">
<li><p>dot_product</p></li>
</ul>
@@ -5595,6 +5627,10 @@ Integers, unsigned integers, and floats are interpreted as seconds since the uni
<h3><code class="docutils literal notranslate"><span class="pre">list_append</span></code><a class="headerlink" href="#list-append" title="Link to this heading">#</a></h3>
<p><em>Alias of <a class="reference internal" href="#array-append">array_append</a>.</em></p>
</section>
+<section id="list-avg">
+<h3><code class="docutils literal notranslate"><span class="pre">list_avg</span></code><a class="headerlink" href="#list-avg" title="Link to this heading">#</a></h3>
+<p><em>Alias of <a class="reference internal" href="#array-avg">array_avg</a>.</em></p>
+</section>
<section id="list-cat">
<h3><code class="docutils literal notranslate"><span class="pre">list_cat</span></code><a class="headerlink" href="#list-cat" title="Link to this heading">#</a></h3>
<p><em>Alias of <a class="reference internal" href="#array-concat">array_concat</a>.</em></p>
@@ -5793,14 +5829,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="id360">
-<h4>Arguments<a class="headerlink" href="#id360" title="Link to this heading">#</a></h4>
+<section id="id363">
+<h4>Arguments<a class="headerlink" href="#id363" 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="id361">
-<h4>Example<a class="headerlink" href="#id361" title="Link to this heading">#</a></h4>
+<section id="id364">
+<h4>Example<a class="headerlink" href="#id364" 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 [...]
@@ -5810,8 +5846,8 @@ Integers, unsigned integers, and floats are interpreted as seconds since the uni
</pre></div>
</div>
</section>
-<section id="id362">
-<h4>Aliases<a class="headerlink" href="#id362" title="Link to this heading">#</a></h4>
+<section id="id365">
+<h4>Aliases<a class="headerlink" href="#id365" title="Link to this heading">#</a></h4>
<ul class="simple">
<li><p>make_list</p></li>
</ul>
@@ -5828,16 +5864,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="id363">
-<h4>Arguments<a class="headerlink" href="#id363" title="Link to this heading">#</a></h4>
+<section id="id366">
+<h4>Arguments<a class="headerlink" href="#id366" 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="id364">
-<h4>Example<a class="headerlink" href="#id364" title="Link to this heading">#</a></h4>
+<section id="id367">
+<h4>Example<a class="headerlink" href="#id367" 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>
@@ -5861,16 +5897,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="id365">
-<h4>Arguments<a class="headerlink" href="#id365" title="Link to this heading">#</a></h4>
+<section id="id368">
+<h4>Arguments<a class="headerlink" href="#id368" 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="id366">
-<h4>Example<a class="headerlink" href="#id366" title="Link to this heading">#</a></h4>
+<section id="id369">
+<h4>Example<a class="headerlink" href="#id369" 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>
@@ -5886,8 +5922,8 @@ Integers, unsigned integers, and floats are interpreted as seconds since the uni
</pre></div>
</div>
</section>
-<section id="id367">
-<h4>Aliases<a class="headerlink" href="#id367" title="Link to this heading">#</a></h4>
+<section id="id370">
+<h4>Aliases<a class="headerlink" href="#id370" title="Link to this heading">#</a></h4>
<ul class="simple">
<li><p>string_to_list</p></li>
</ul>
@@ -5913,15 +5949,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="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_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="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>
<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>
@@ -5956,14 +5992,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="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>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="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>
<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>
@@ -5994,8 +6030,8 @@ a struct type of fields <code class="docutils literal notranslate"><span class="
</pre></div>
</div>
</section>
-<section id="id372">
-<h4>Aliases<a class="headerlink" href="#id372" title="Link to this heading">#</a></h4>
+<section id="id375">
+<h4>Aliases<a class="headerlink" href="#id375" title="Link to this heading">#</a></h4>
<ul class="simple">
<li><p>row</p></li>
</ul>
@@ -6025,8 +6061,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="id373">
-<h4>Arguments<a class="headerlink" href="#id373" title="Link to this heading">#</a></h4>
+<section id="id376">
+<h4>Arguments<a class="headerlink" href="#id376" 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>
@@ -6034,8 +6070,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="id374">
-<h4>Example<a class="headerlink" href="#id374" title="Link to this heading">#</a></h4>
+<section id="id377">
+<h4>Example<a class="headerlink" href="#id377" 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>
@@ -6071,14 +6107,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="id375">
-<h4>Arguments<a class="headerlink" href="#id375" title="Link to this heading">#</a></h4>
+<section id="id378">
+<h4>Arguments<a class="headerlink" href="#id378" 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="id376">
-<h4>Example<a class="headerlink" href="#id376" title="Link to this heading">#</a></h4>
+<section id="id379">
+<h4>Example<a class="headerlink" href="#id379" 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= [...]
@@ -6096,15 +6132,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="id377">
-<h4>Arguments<a class="headerlink" href="#id377" title="Link to this heading">#</a></h4>
+<section id="id380">
+<h4>Arguments<a class="headerlink" href="#id380" 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="id378">
-<h4>Example<a class="headerlink" href="#id378" title="Link to this heading">#</a></h4>
+<section id="id381">
+<h4>Example<a class="headerlink" href="#id381" 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>
@@ -6124,8 +6160,8 @@ For <code class="docutils literal notranslate"><span class="pre">make_map</span>
</pre></div>
</div>
</section>
-<section id="id379">
-<h4>Aliases<a class="headerlink" href="#id379" title="Link to this heading">#</a></h4>
+<section id="id382">
+<h4>Aliases<a class="headerlink" href="#id382" title="Link to this heading">#</a></h4>
<ul class="simple">
<li><p>element_at</p></li>
</ul>
@@ -6137,14 +6173,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="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>map</strong>: Map expression. Can be a constant, column, or function, and any combination of map 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="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>
@@ -6162,14 +6198,14 @@ For <code class="docutils literal notranslate"><span class="pre">make_map</span>
<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="n">map_values</span><span class="p">(</span><span class="k">map</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>map</strong>: Map expression. Can be a constant, column, or function, and any combination of map operators.</p></li>
</ul>
</section>
-<section id="id383">
-<h4>Example<a class="headerlink" href="#id383" title="Link to this heading">#</a></h4>
+<section id="id386">
+<h4>Example<a class="headerlink" href="#id386" title="Link to this heading">#</a></h4>
<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="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>
@@ -6198,8 +6234,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="id384">
-<h4>Arguments<a class="headerlink" href="#id384" title="Link to this heading">#</a></h4>
+<section id="id387">
+<h4>Arguments<a class="headerlink" href="#id387" title="Link to this heading">#</a></h4>
<ul class="simple">
<li><p><strong>expression</strong>: String expression to operate on. Can be a constant, column, or function, and any combination of operators.</p></li>
<li><p><strong>algorithm</strong>: String expression specifying algorithm to use. Must be one of:</p>
@@ -6216,8 +6252,8 @@ For <code class="docutils literal notranslate"><span class="pre">make_map</span>
</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">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>
@@ -6234,14 +6270,14 @@ For <code class="docutils literal notranslate"><span class="pre">make_map</span>
<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="n">md5</span><span class="p">(</span><span class="n">expression</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id386">
-<h4>Arguments<a class="headerlink" href="#id386" title="Link to this heading">#</a></h4>
+<section id="id389">
+<h4>Arguments<a class="headerlink" href="#id389" title="Link to this heading">#</a></h4>
<ul class="simple">
<li><p><strong>expression</strong>: String expression to operate on. Can be a constant, column, or function, and any combination of operators.</p></li>
</ul>
</section>
-<section id="id387">
-<h4>Example<a class="headerlink" href="#id387" title="Link to this heading">#</a></h4>
+<section id="id390">
+<h4>Example<a class="headerlink" href="#id390" title="Link to this heading">#</a></h4>
<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="o">></span><span class="w"> </span><span class="k">select</span><span class="w"> </span><span class="n">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>
@@ -6258,14 +6294,14 @@ For <code class="docutils literal notranslate"><span class="pre">make_map</span>
<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="n">sha224</span><span class="p">(</span><span class="n">expression</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id388">
-<h4>Arguments<a class="headerlink" href="#id388" title="Link to this heading">#</a></h4>
+<section id="id391">
+<h4>Arguments<a class="headerlink" href="#id391" title="Link to this heading">#</a></h4>
<ul class="simple">
<li><p><strong>expression</strong>: String expression to operate on. Can be a constant, column, or function, and any combination of operators.</p></li>
</ul>
</section>
-<section id="id389">
-<h4>Example<a class="headerlink" href="#id389" title="Link to this heading">#</a></h4>
+<section id="id392">
+<h4>Example<a class="headerlink" href="#id392" title="Link to this heading">#</a></h4>
<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="o">></span><span class="w"> </span><span class="k">select</span><span class="w"> </span><span class="n">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>
@@ -6282,14 +6318,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="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>: String expression to operate on. 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">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>
@@ -6306,14 +6342,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="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>: String expression to operate on. Can be a constant, column, or function, and any combination of operators.</p></li>
</ul>
</section>
-<section id="id393">
-<h4>Example<a class="headerlink" href="#id393" title="Link to this heading">#</a></h4>
+<section id="id396">
+<h4>Example<a class="headerlink" href="#id396" title="Link to this heading">#</a></h4>
<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="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>
@@ -6330,14 +6366,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="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>: String expression to operate on. Can be a constant, column, or function, and any combination of operators.</p></li>
</ul>
</section>
-<section id="id395">
-<h4>Example<a class="headerlink" href="#id395" title="Link to this heading">#</a></h4>
+<section id="id398">
+<h4>Example<a class="headerlink" href="#id398" title="Link to this heading">#</a></h4>
<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="o">></span><span class="w"> </span><span class="k">select</span><span class="w"> </span><span class="n">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>
@@ -6362,15 +6398,15 @@ For <code class="docutils literal notranslate"><span class="pre">make_map</span>
<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="n">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="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>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="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="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 [...]
@@ -6391,14 +6427,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="id398">
-<h4>Arguments<a class="headerlink" href="#id398" title="Link to this heading">#</a></h4>
+<section id="id401">
+<h4>Arguments<a class="headerlink" href="#id401" title="Link to this heading">#</a></h4>
<ul class="simple">
<li><p><strong>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="id399">
-<h4>Example<a class="headerlink" href="#id399" title="Link to this heading">#</a></h4>
+<section id="id402">
+<h4>Example<a class="headerlink" href="#id402" title="Link to this heading">#</a></h4>
<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="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>
@@ -6436,15 +6472,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="id400">
-<h4>Arguments<a class="headerlink" href="#id400" title="Link to this heading">#</a></h4>
+<section id="id403">
+<h4>Arguments<a class="headerlink" href="#id403" title="Link to this heading">#</a></h4>
<ul class="simple">
<li><p><strong>expression</strong>: Expression to cast. The expression can be a constant, column, or function, and any combination of operators.</p></li>
<li><p><strong>datatype</strong>: <a class="reference external" href="https://docs.rs/arrow/latest/arrow/datatypes/enum.DataType.html">Arrow data type</a> name to cast to, as a string. The format is the same as that returned by [<code class="docutils literal notranslate"><span class="pre">arrow_typeof</span></code>]</p></li>
</ul>
</section>
-<section id="id401">
-<h4>Example<a class="headerlink" href="#id401" title="Link to this heading">#</a></h4>
+<section id="id404">
+<h4>Example<a class="headerlink" href="#id404" title="Link to this heading">#</a></h4>
<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="o">></span><span class="w"> </span><span class="k">select</span>
<span class="w"> </span><span class="n">arrow_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>
@@ -6475,14 +6511,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="id402">
-<h4>Arguments<a class="headerlink" href="#id402" title="Link to this heading">#</a></h4>
+<section id="id405">
+<h4>Arguments<a class="headerlink" href="#id405" title="Link to this heading">#</a></h4>
<ul class="simple">
<li><p><strong>expression</strong>: Expression to evaluate. The expression can be a constant, column, or function, and any combination of operators.</p></li>
</ul>
</section>
-<section id="id403">
-<h4>Example<a class="headerlink" href="#id403" title="Link to this heading">#</a></h4>
+<section id="id406">
+<h4>Example<a class="headerlink" href="#id406" title="Link to this heading">#</a></h4>
<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="o">></span><span class="w"> </span><span class="k">select</span><span class="w"> </span><span class="n">arrow_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>
@@ -6506,15 +6542,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="id404">
-<h4>Arguments<a class="headerlink" href="#id404" title="Link to this heading">#</a></h4>
+<section id="id407">
+<h4>Arguments<a class="headerlink" href="#id407" title="Link to this heading">#</a></h4>
<ul class="simple">
<li><p><strong>expression</strong>: The expression to 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="id405">
-<h4>Example<a class="headerlink" href="#id405" title="Link to this heading">#</a></h4>
+<section id="id408">
+<h4>Example<a class="headerlink" href="#id408" title="Link to this heading">#</a></h4>
<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="o">></span><span class="w"> </span><span class="k">select</span><span class="w"> </span><span class="n">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>
@@ -6537,15 +6573,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="id406">
-<h4>Arguments<a class="headerlink" href="#id406" title="Link to this heading">#</a></h4>
+<section id="id409">
+<h4>Arguments<a class="headerlink" href="#id409" title="Link to this heading">#</a></h4>
<ul class="simple">
<li><p><strong>expression</strong>: 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="id407">
-<h4>Example<a class="headerlink" href="#id407" title="Link to this heading">#</a></h4>
+<section id="id410">
+<h4>Example<a class="headerlink" href="#id410" title="Link to this heading">#</a></h4>
<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="o">></span><span class="w"> </span><span class="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>
@@ -6564,14 +6600,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="id408">
-<h4>Arguments<a class="headerlink" href="#id408" title="Link to this heading">#</a></h4>
+<section id="id411">
+<h4>Arguments<a class="headerlink" href="#id411" title="Link to this heading">#</a></h4>
<ul class="simple">
<li><p><strong>expression</strong>: Expression to evaluate. The expression can be a constant, column, or function, and any combination of operators.</p></li>
</ul>
</section>
-<section id="id409">
-<h4>Example<a class="headerlink" href="#id409" title="Link to this heading">#</a></h4>
+<section id="id412">
+<h4>Example<a class="headerlink" href="#id412" title="Link to this heading">#</a></h4>
<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="o">></span><span class="w"> </span><span class="k">select</span><span class="w"> </span><span class="n">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=" [...]
@@ -6588,15 +6624,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="id410">
-<h4>Arguments<a class="headerlink" href="#id410" title="Link to this heading">#</a></h4>
+<section id="id413">
+<h4>Arguments<a class="headerlink" href="#id413" 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="id411">
-<h4>Example<a class="headerlink" href="#id411" title="Link to this heading">#</a></h4>
+<section id="id414">
+<h4>Example<a class="headerlink" href="#id414" 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>
@@ -6626,8 +6662,8 @@ evaluation returns an error.</p>
<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="n">file_row_index</span><span class="p">()</span>
</pre></div>
</div>
-<section id="id412">
-<h4>Example<a class="headerlink" href="#id412" title="Link to this heading">#</a></h4>
+<section id="id415">
+<h4>Example<a class="headerlink" href="#id415" title="Link to this heading">#</a></h4>
<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="k">SELECT</span><span class="w"> </span><span class="n">file_row_index</span><span class="p">()</span><span class="w"> </span><span class="k">FROM</span><span class="w"> </span><span class="n">t</span><span class="p">;</span>
</pre></div>
</div>
@@ -6645,15 +6681,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="id413">
-<h4>Arguments<a class="headerlink" href="#id413" title="Link to this heading">#</a></h4>
+<section id="id416">
+<h4>Arguments<a class="headerlink" href="#id416" 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="id414">
-<h4>Example<a class="headerlink" href="#id414" title="Link to this heading">#</a></h4>
+<section id="id417">
+<h4>Example<a class="headerlink" href="#id417" 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>
@@ -6696,8 +6732,8 @@ evaluated outside a file scan, or was not pushed down into one), direct evaluati
<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="n">input_file_name</span><span class="p">()</span>
</pre></div>
</div>
-<section id="id415">
-<h4>Example<a class="headerlink" href="#id415" title="Link to this heading">#</a></h4>
+<section id="id418">
+<h4>Example<a class="headerlink" href="#id418" 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">input_file_name</span><span class="p">()</span><span class="w"> </span><span class="k">FROM</span><span class="w"> </span><span class="n">t</span><span class="p">;</span>
</pre></div>
</div>
@@ -6709,15 +6745,15 @@ evaluated outside a file scan, or was not pushed down into one), direct evaluati
<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="id416">
-<h4>Arguments<a class="headerlink" href="#id416" title="Link to this heading">#</a></h4>
+<section id="id419">
+<h4>Arguments<a class="headerlink" href="#id419" 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="id417">
-<h4>Example<a class="headerlink" href="#id417" title="Link to this heading">#</a></h4>
+<section id="id420">
+<h4>Example<a class="headerlink" href="#id420" 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>
@@ -6736,8 +6772,8 @@ evaluated outside a file scan, or was not pushed down into one), direct evaluati
<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="id418">
-<h4>Example<a class="headerlink" href="#id418" title="Link to this heading">#</a></h4>
+<section id="id421">
+<h4>Example<a class="headerlink" href="#id421" 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>
@@ -6754,16 +6790,16 @@ evaluated outside a file scan, or was not pushed down into one), direct evaluati
<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="id419">
-<h4>Arguments<a class="headerlink" href="#id419" title="Link to this heading">#</a></h4>
+<section id="id422">
+<h4>Arguments<a class="headerlink" href="#id422" 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="id420">
-<h4>Example<a class="headerlink" href="#id420" title="Link to this heading">#</a></h4>
+<section id="id423">
+<h4>Example<a class="headerlink" href="#id423" 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 [...]
@@ -7409,297 +7445,304 @@ evaluated outside a file scan, or was not pushed down into one), direct evaluati
<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id223">Aliases</a></li>
</ul>
</li>
-<li class="toc-h3 nav-item toc-entry"><a class="reference internal nav-link" href="#array-cat"><code class="docutils literal notranslate"><span class="pre">array_cat</span></code></a></li>
-<li class="toc-h3 nav-item toc-entry"><a class="reference internal nav-link" href="#array-compact"><code class="docutils literal notranslate"><span class="pre">array_compact</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-avg"><code class="docutils literal notranslate"><span class="pre">array_avg</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="#id224">Arguments</a></li>
<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id225">Example</a></li>
<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id226">Aliases</a></li>
</ul>
</li>
-<li class="toc-h3 nav-item toc-entry"><a class="reference internal nav-link" href="#array-concat"><code class="docutils literal notranslate"><span class="pre">array_concat</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-cat"><code class="docutils literal notranslate"><span class="pre">array_cat</span></code></a></li>
+<li class="toc-h3 nav-item toc-entry"><a class="reference internal nav-link" href="#array-compact"><code class="docutils literal notranslate"><span class="pre">array_compact</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="#id227">Arguments</a></li>
<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id228">Example</a></li>
<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id229">Aliases</a></li>
</ul>
</li>
-<li class="toc-h3 nav-item toc-entry"><a class="reference internal nav-link" href="#array-contains"><code class="docutils literal notranslate"><span class="pre">array_contains</span></code></a></li>
-<li class="toc-h3 nav-item toc-entry"><a class="reference internal nav-link" href="#array-dims"><code class="docutils literal notranslate"><span class="pre">array_dims</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-concat"><code class="docutils literal notranslate"><span class="pre">array_concat</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="#id230">Arguments</a></li>
<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id231">Example</a></li>
<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id232">Aliases</a></li>
</ul>
</li>
-<li class="toc-h3 nav-item toc-entry"><a class="reference internal nav-link" href="#array-distance"><code class="docutils literal notranslate"><span class="pre">array_distance</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-contains"><code class="docutils literal notranslate"><span class="pre">array_contains</span></code></a></li>
+<li class="toc-h3 nav-item toc-entry"><a class="reference internal nav-link" href="#array-dims"><code class="docutils literal notranslate"><span class="pre">array_dims</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="#id233">Arguments</a></li>
<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id234">Example</a></li>
<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id235">Aliases</a></li>
</ul>
</li>
-<li class="toc-h3 nav-item toc-entry"><a class="reference internal nav-link" href="#array-distinct"><code class="docutils literal notranslate"><span class="pre">array_distinct</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-distance"><code class="docutils literal notranslate"><span class="pre">array_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="#id236">Arguments</a></li>
<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id237">Example</a></li>
<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id238">Aliases</a></li>
</ul>
</li>
-<li class="toc-h3 nav-item toc-entry"><a class="reference internal nav-link" href="#array-element"><code class="docutils literal notranslate"><span class="pre">array_element</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-distinct"><code class="docutils literal notranslate"><span class="pre">array_distinct</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="#id239">Arguments</a></li>
<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id240">Example</a></li>
<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id241">Aliases</a></li>
</ul>
</li>
-<li class="toc-h3 nav-item toc-entry"><a class="reference internal nav-link" href="#array-empty"><code class="docutils literal notranslate"><span class="pre">array_empty</span></code></a></li>
-<li class="toc-h3 nav-item toc-entry"><a class="reference internal nav-link" href="#array-except"><code class="docutils literal notranslate"><span class="pre">array_except</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-element"><code class="docutils literal notranslate"><span class="pre">array_element</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-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-filter"><code class="docutils literal notranslate"><span class="pre">array_filter</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-empty"><code class="docutils literal notranslate"><span class="pre">array_empty</span></code></a></li>
+<li class="toc-h3 nav-item toc-entry"><a class="reference internal nav-link" href="#array-except"><code class="docutils literal notranslate"><span class="pre">array_except</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"><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-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-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="#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-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="#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-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="#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-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="#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-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="#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-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="#id263">Arguments</a></li>
<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id264">Example</a></li>
<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id265">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="#id266">Arguments</a></li>
<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id267">Example</a></li>
+<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id268">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="#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>
+<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="#id269">Arguments</a></li>
+<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id270">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="#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-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="#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-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="#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-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="#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-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="#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-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="#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-product"><code class="docutils literal notranslate"><span class="pre">array_product</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="#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-push-back"><code class="docutils literal notranslate"><span class="pre">array_push_back</span></code></a></li>
-<li class="toc-h3 nav-item toc-entry"><a class="reference internal nav-link" href="#array-push-front"><code class="docutils literal notranslate"><span class="pre">array_push_front</span></code></a></li>
-<li class="toc-h3 nav-item toc-entry"><a class="reference internal nav-link" href="#array-remove"><code class="docutils literal notranslate"><span class="pre">array_remove</span></code></a><ul class="nav section-nav flex-column">
+<li class="toc-h3 nav-item toc-entry"><a class="reference internal nav-link" href="#array-product"><code class="docutils literal notranslate"><span class="pre">array_product</span></code></a><ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id292">Arguments</a></li>
<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id293">Example</a></li>
<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id294">Aliases</a></li>
</ul>
</li>
-<li class="toc-h3 nav-item toc-entry"><a class="reference internal nav-link" href="#array-remove-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="#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-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="#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-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="#id301">Arguments</a></li>
<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id302">Example</a></li>
<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id303">Aliases</a></li>
</ul>
</li>
-<li class="toc-h3 nav-item toc-entry"><a class="reference internal nav-link" href="#array-replace"><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="#id304">Arguments</a></li>
<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id305">Example</a></li>
<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id306">Aliases</a></li>
</ul>
</li>
-<li class="toc-h3 nav-item toc-entry"><a class="reference internal nav-link" href="#array-replace-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="#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-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="#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-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="#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-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="#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-scale"><code class="docutils literal notranslate"><span class="pre">array_scale</span></code></a><ul class="nav section-nav flex-column">
+<li class="toc-h3 nav-item toc-entry"><a class="reference internal nav-link" href="#array-reverse"><code class="docutils literal notranslate"><span class="pre">array_reverse</span></code></a><ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#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-slice"><code class="docutils literal notranslate"><span class="pre">array_slice</span></code></a><ul class="nav section-nav flex-column">
+<li class="toc-h3 nav-item toc-entry"><a class="reference internal nav-link" href="#array-scale"><code class="docutils literal notranslate"><span class="pre">array_scale</span></code></a><ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id322">Arguments</a></li>
<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id323">Example</a></li>
<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id324">Aliases</a></li>
</ul>
</li>
-<li class="toc-h3 nav-item toc-entry"><a class="reference internal nav-link" href="#array-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="#id325">Arguments</a></li>
<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id326">Example</a></li>
<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id327">Aliases</a></li>
</ul>
</li>
-<li class="toc-h3 nav-item toc-entry"><a class="reference internal nav-link" href="#array-subtract"><code class="docutils literal notranslate"><span class="pre">array_subtract</span></code></a><ul class="nav section-nav flex-column">
+<li class="toc-h3 nav-item toc-entry"><a class="reference internal nav-link" href="#array-sort"><code class="docutils literal notranslate"><span class="pre">array_sort</span></code></a><ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id328">Arguments</a></li>
<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id329">Example</a></li>
<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id330">Aliases</a></li>
</ul>
</li>
-<li class="toc-h3 nav-item toc-entry"><a class="reference internal nav-link" href="#array-sum"><code class="docutils literal notranslate"><span class="pre">array_sum</span></code></a><ul class="nav section-nav flex-column">
+<li class="toc-h3 nav-item toc-entry"><a class="reference internal nav-link" href="#array-subtract"><code class="docutils literal notranslate"><span class="pre">array_subtract</span></code></a><ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id331">Arguments</a></li>
<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id332">Example</a></li>
<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id333">Aliases</a></li>
</ul>
</li>
-<li class="toc-h3 nav-item toc-entry"><a class="reference internal nav-link" href="#array-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-sum"><code class="docutils literal notranslate"><span class="pre">array_sum</span></code></a><ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id334">Arguments</a></li>
<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id335">Example</a></li>
<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id336">Aliases</a></li>
</ul>
</li>
-<li class="toc-h3 nav-item toc-entry"><a class="reference internal nav-link" href="#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="#id337">Arguments</a></li>
<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id338">Example</a></li>
<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id339">Aliases</a></li>
</ul>
</li>
-<li class="toc-h3 nav-item toc-entry"><a class="reference internal nav-link" href="#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="#id340">Arguments</a></li>
<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id341">Example</a></li>
<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id342">Aliases</a></li>
</ul>
</li>
-<li class="toc-h3 nav-item toc-entry"><a class="reference internal nav-link" href="#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="#id343">Arguments</a></li>
<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id344">Example</a></li>
<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id345">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="#id346">Arguments</a></li>
<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id347">Example</a></li>
+<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id348">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="#id349">Arguments</a></li>
+<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id350">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="#id348">Arguments</a></li>
-<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id349">Example</a></li>
+<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id351">Arguments</a></li>
+<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id352">Example</a></li>
</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="#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>
+<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>
+<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id355">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="#id353">Arguments</a></li>
-<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id354">Example</a></li>
+<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id356">Arguments</a></li>
+<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id357">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="#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="#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="#id357">Arguments</a></li>
-<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id358">Example</a></li>
-<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id359">Aliases</a></li>
+<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>
+<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id362">Aliases</a></li>
</ul>
</li>
<li class="toc-h3 nav-item toc-entry"><a class="reference internal nav-link" href="#list-add"><code class="docutils literal notranslate"><span class="pre">list_add</span></code></a></li>
<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>
<li class="toc-h3 nav-item toc-entry"><a class="reference internal nav-link" href="#list-any-value"><code class="docutils literal notranslate"><span class="pre">list_any_value</span></code></a></li>
<li class="toc-h3 nav-item toc-entry"><a class="reference internal nav-link" href="#list-append"><code class="docutils literal notranslate"><span class="pre">list_append</span></code></a></li>
+<li class="toc-h3 nav-item toc-entry"><a class="reference internal nav-link" href="#list-avg"><code class="docutils literal notranslate"><span class="pre">list_avg</span></code></a></li>
<li class="toc-h3 nav-item toc-entry"><a class="reference internal nav-link" href="#list-cat"><code class="docutils literal notranslate"><span class="pre">list_cat</span></code></a></li>
<li class="toc-h3 nav-item toc-entry"><a class="reference internal nav-link" href="#list-compact"><code class="docutils literal notranslate"><span class="pre">list_compact</span></code></a></li>
<li class="toc-h3 nav-item toc-entry"><a class="reference internal nav-link" href="#list-concat"><code class="docutils literal notranslate"><span class="pre">list_concat</span></code></a></li>
@@ -7749,21 +7792,21 @@ evaluated outside a file scan, or was not pushed down into one), direct evaluati
<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="#id360">Arguments</a></li>
-<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id361">Example</a></li>
-<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id362">Aliases</a></li>
+<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id363">Arguments</a></li>
+<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id364">Example</a></li>
+<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id365">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="#id363">Arguments</a></li>
-<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id364">Example</a></li>
+<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>
</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="#id365">Arguments</a></li>
-<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id366">Example</a></li>
-<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id367">Aliases</a></li>
+<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="#id370">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>
@@ -7771,15 +7814,15 @@ evaluated outside a file scan, or was not pushed down into one), direct evaluati
</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="#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="#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="#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="#id372">Aliases</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>
+<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id375">Aliases</a></li>
</ul>
</li>
</ul>
@@ -7787,135 +7830,135 @@ evaluated outside a file scan, or was not pushed down into one), direct evaluati
<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="#id373">Arguments</a></li>
-<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id374">Example</a></li>
+<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>
</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="#id375">Arguments</a></li>
-<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id376">Example</a></li>
+<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>
</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="#id377">Arguments</a></li>
-<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id378">Example</a></li>
-<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id379">Aliases</a></li>
+<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="#id382">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="#id380">Arguments</a></li>
-<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id381">Example</a></li>
+<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id383">Arguments</a></li>
+<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id384">Example</a></li>
</ul>
</li>
<li class="toc-h3 nav-item toc-entry"><a class="reference internal nav-link" href="#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="#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>
</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="#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="#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="#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="#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="#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="#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="#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="#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="#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="#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="#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>
</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="#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="#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="#id398">Arguments</a></li>
-<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id399">Example</a></li>
+<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id401">Arguments</a></li>
+<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id402">Example</a></li>
</ul>
</li>
</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="#id400">Arguments</a></li>
-<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id401">Example</a></li>
+<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id403">Arguments</a></li>
+<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id404">Example</a></li>
</ul>
</li>
<li class="toc-h3 nav-item toc-entry"><a class="reference internal nav-link" href="#arrow-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="#id402">Arguments</a></li>
-<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id403">Example</a></li>
+<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id405">Arguments</a></li>
+<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id406">Example</a></li>
</ul>
</li>
<li class="toc-h3 nav-item toc-entry"><a class="reference internal nav-link" href="#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="#id404">Arguments</a></li>
-<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id405">Example</a></li>
+<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id407">Arguments</a></li>
+<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id408">Example</a></li>
</ul>
</li>
<li class="toc-h3 nav-item toc-entry"><a class="reference internal nav-link" href="#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="#id406">Arguments</a></li>
-<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id407">Example</a></li>
+<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id409">Arguments</a></li>
+<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id410">Example</a></li>
</ul>
</li>
<li class="toc-h3 nav-item toc-entry"><a class="reference internal nav-link" href="#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="#id408">Arguments</a></li>
-<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id409">Example</a></li>
+<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id411">Arguments</a></li>
+<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id412">Example</a></li>
</ul>
</li>
<li class="toc-h3 nav-item toc-entry"><a class="reference internal nav-link" href="#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="#id410">Arguments</a></li>
-<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id411">Example</a></li>
+<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id413">Arguments</a></li>
+<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id414">Example</a></li>
</ul>
</li>
<li class="toc-h3 nav-item toc-entry"><a class="reference internal nav-link" href="#file-row-index"><code class="docutils literal notranslate"><span class="pre">file_row_index</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="#id412">Example</a></li>
+<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id415">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="#id413">Arguments</a></li>
-<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id414">Example</a></li>
+<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id416">Arguments</a></li>
+<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id417">Example</a></li>
</ul>
</li>
<li class="toc-h3 nav-item toc-entry"><a class="reference internal nav-link" href="#input-file-name"><code class="docutils literal notranslate"><span class="pre">input_file_name</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="#id415">Example</a></li>
+<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id418">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="#id416">Arguments</a></li>
-<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id417">Example</a></li>
+<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id419">Arguments</a></li>
+<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id420">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="#id418">Example</a></li>
+<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id421">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="#id419">Arguments</a></li>
-<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id420">Example</a></li>
+<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id422">Arguments</a></li>
+<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link" href="#id423">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