(datafusion) branch asf-site updated: Publish built docs triggered by 05bb56913ecaeed981c8913cca030af482e6c39b

[github-bot]

This is an automated email from the ASF dual-hosted git repository.

github-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 b931e911fc Publish built docs triggered by 
05bb56913ecaeed981c8913cca030af482e6c39b
b931e911fc is described below

commit b931e911fc97931a4e9c40483130c22bbd41cb91
Author: github-actions[bot] <github-actions[bot]@users.noreply.github.com>
AuthorDate: Fri Mar 7 10:26:50 2025 +0000

    Publish built docs triggered by 05bb56913ecaeed981c8913cca030af482e6c39b
---
 _sources/user-guide/sql/scalar_functions.md.txt |  33 ++
 searchindex.js                                  |   2 +-
 user-guide/sql/scalar_functions.html            | 731 +++++++++++++-----------
 3 files changed, 435 insertions(+), 331 deletions(-)

diff --git a/_sources/user-guide/sql/scalar_functions.md.txt 
b/_sources/user-guide/sql/scalar_functions.md.txt
index fb4043c33e..60ecf7bd78 100644
--- a/_sources/user-guide/sql/scalar_functions.md.txt
+++ b/_sources/user-guide/sql/scalar_functions.md.txt
@@ -2524,6 +2524,7 @@ _Alias of [current_date](#current_date)._
 - [array_intersect](#array_intersect)
 - [array_join](#array_join)
 - [array_length](#array_length)
+- [array_max](#array_max)
 - [array_ndims](#array_ndims)
 - [array_pop_back](#array_pop_back)
 - [array_pop_front](#array_pop_front)
@@ -2569,6 +2570,7 @@ _Alias of [current_date](#current_date)._
 - [list_intersect](#list_intersect)
 - [list_join](#list_join)
 - [list_length](#list_length)
+- [list_max](#list_max)
 - [list_ndims](#list_ndims)
 - [list_pop_back](#list_pop_back)
 - [list_pop_front](#list_pop_front)
@@ -3002,6 +3004,33 @@ array_length(array, dimension)
 
 - list_length
 
+### `array_max`
+
+Returns the maximum value in the array.
+
+```sql
+array_max(array)
+```
+
+#### Arguments
+
+- **array**: Array expression. Can be a constant, column, or function, and any 
combination of array operators.
+
+#### Example
+
+```sql
+> select array_max([3,1,4,2]);
++-----------------------------------------+
+| array_max(List([3,1,4,2]))              |
++-----------------------------------------+
+| 4                                       |
++-----------------------------------------+
+```
+
+#### Aliases
+
+- list_max
+
 ### `array_ndims`
 
 Returns the number of dimensions of the array.
@@ -3759,6 +3788,10 @@ _Alias of [array_to_string](#array_to_string)._
 
 _Alias of [array_length](#array_length)._
 
+### `list_max`
+
+_Alias of [array_max](#array_max)._
+
 ### `list_ndims`
 
 _Alias of [array_ndims](#array_ndims)._
diff --git a/searchindex.js b/searchindex.js
index 54c4110205..6efabe4005 100644
--- a/searchindex.js
+++ b/searchindex.js
@@ -1 +1 @@
-Search.setIndex({"alltitles":{"!=":[[52,"op-neq"]],"!~":[[52,"op-re-not-match"]],"!~*":[[52,"op-re-not-match-i"]],"!~~":[[52,"id19"]],"!~~*":[[52,"id20"]],"#":[[52,"op-bit-xor"]],"%":[[52,"op-modulo"]],"&":[[52,"op-bit-and"]],"(relation,
 name) tuples in logical fields and logical columns are 
unique":[[12,"relation-name-tuples-in-logical-fields-and-logical-columns-are-unique"]],"*":[[52,"op-multiply"]],"+":[[52,"op-plus"]],"-":[[52,"op-minus"]],"/":[[52,"op-divide"]],"2022
 Q2":[[10,"q2"]] [...]
\ No newline at end of file
+Search.setIndex({"alltitles":{"!=":[[52,"op-neq"]],"!~":[[52,"op-re-not-match"]],"!~*":[[52,"op-re-not-match-i"]],"!~~":[[52,"id19"]],"!~~*":[[52,"id20"]],"#":[[52,"op-bit-xor"]],"%":[[52,"op-modulo"]],"&":[[52,"op-bit-and"]],"(relation,
 name) tuples in logical fields and logical columns are 
unique":[[12,"relation-name-tuples-in-logical-fields-and-logical-columns-are-unique"]],"*":[[52,"op-multiply"]],"+":[[52,"op-plus"]],"-":[[52,"op-minus"]],"/":[[52,"op-divide"]],"2022
 Q2":[[10,"q2"]] [...]
\ No newline at end of file
diff --git a/user-guide/sql/scalar_functions.html 
b/user-guide/sql/scalar_functions.html
index 4674cf6406..4fba5db908 100644
--- a/user-guide/sql/scalar_functions.html
+++ b/user-guide/sql/scalar_functions.html
@@ -2996,10 +2996,10 @@
     </ul>
    </li>
    <li class="toc-h3 nav-item toc-entry">
-    <a class="reference internal nav-link" href="#array-ndims">
+    <a class="reference internal nav-link" href="#array-max">
      <code class="docutils literal notranslate">
       <span class="pre">
-       array_ndims
+       array_max
       </span>
      </code>
     </a>
@@ -3022,10 +3022,10 @@
     </ul>
    </li>
    <li class="toc-h3 nav-item toc-entry">
-    <a class="reference internal nav-link" href="#array-pop-back">
+    <a class="reference internal nav-link" href="#array-ndims">
      <code class="docutils literal notranslate">
       <span class="pre">
-       array_pop_back
+       array_ndims
       </span>
      </code>
     </a>
@@ -3048,10 +3048,10 @@
     </ul>
    </li>
    <li class="toc-h3 nav-item toc-entry">
-    <a class="reference internal nav-link" href="#array-pop-front">
+    <a class="reference internal nav-link" href="#array-pop-back">
      <code class="docutils literal notranslate">
       <span class="pre">
-       array_pop_front
+       array_pop_back
       </span>
      </code>
     </a>
@@ -3074,10 +3074,10 @@
     </ul>
    </li>
    <li class="toc-h3 nav-item toc-entry">
-    <a class="reference internal nav-link" href="#array-position">
+    <a class="reference internal nav-link" href="#array-pop-front">
      <code class="docutils literal notranslate">
       <span class="pre">
-       array_position
+       array_pop_front
       </span>
      </code>
     </a>
@@ -3100,10 +3100,10 @@
     </ul>
    </li>
    <li class="toc-h3 nav-item toc-entry">
-    <a class="reference internal nav-link" href="#array-positions">
+    <a class="reference internal nav-link" href="#array-position">
      <code class="docutils literal notranslate">
       <span class="pre">
-       array_positions
+       array_position
       </span>
      </code>
     </a>
@@ -3126,10 +3126,10 @@
     </ul>
    </li>
    <li class="toc-h3 nav-item toc-entry">
-    <a class="reference internal nav-link" href="#array-prepend">
+    <a class="reference internal nav-link" href="#array-positions">
      <code class="docutils literal notranslate">
       <span class="pre">
-       array_prepend
+       array_positions
       </span>
      </code>
     </a>
@@ -3151,6 +3151,32 @@
      </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-h4 nav-item toc-entry">
+      <a class="reference internal nav-link" href="#id219">
+       Arguments
+      </a>
+     </li>
+     <li class="toc-h4 nav-item toc-entry">
+      <a class="reference internal nav-link" href="#id220">
+       Example
+      </a>
+     </li>
+     <li class="toc-h4 nav-item toc-entry">
+      <a class="reference internal nav-link" href="#id221">
+       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">
@@ -3179,17 +3205,17 @@
     </a>
     <ul class="nav section-nav flex-column">
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id219">
+      <a class="reference internal nav-link" href="#id222">
        Arguments
       </a>
      </li>
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id220">
+      <a class="reference internal nav-link" href="#id223">
        Example
       </a>
      </li>
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id221">
+      <a class="reference internal nav-link" href="#id224">
        Aliases
       </a>
      </li>
@@ -3205,17 +3231,17 @@
     </a>
     <ul class="nav section-nav flex-column">
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id222">
+      <a class="reference internal nav-link" href="#id225">
        Arguments
       </a>
      </li>
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id223">
+      <a class="reference internal nav-link" href="#id226">
        Example
       </a>
      </li>
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id224">
+      <a class="reference internal nav-link" href="#id227">
        Aliases
       </a>
      </li>
@@ -3231,17 +3257,17 @@
     </a>
     <ul class="nav section-nav flex-column">
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id225">
+      <a class="reference internal nav-link" href="#id228">
        Arguments
       </a>
      </li>
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id226">
+      <a class="reference internal nav-link" href="#id229">
        Example
       </a>
      </li>
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id227">
+      <a class="reference internal nav-link" href="#id230">
        Aliases
       </a>
      </li>
@@ -3257,17 +3283,17 @@
     </a>
     <ul class="nav section-nav flex-column">
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id228">
+      <a class="reference internal nav-link" href="#id231">
        Arguments
       </a>
      </li>
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id229">
+      <a class="reference internal nav-link" href="#id232">
        Example
       </a>
      </li>
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id230">
+      <a class="reference internal nav-link" href="#id233">
        Aliases
       </a>
      </li>
@@ -3283,17 +3309,17 @@
     </a>
     <ul class="nav section-nav flex-column">
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id231">
+      <a class="reference internal nav-link" href="#id234">
        Arguments
       </a>
      </li>
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id232">
+      <a class="reference internal nav-link" href="#id235">
        Example
       </a>
      </li>
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id233">
+      <a class="reference internal nav-link" href="#id236">
        Aliases
       </a>
      </li>
@@ -3309,17 +3335,17 @@
     </a>
     <ul class="nav section-nav flex-column">
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id234">
+      <a class="reference internal nav-link" href="#id237">
        Arguments
       </a>
      </li>
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id235">
+      <a class="reference internal nav-link" href="#id238">
        Example
       </a>
      </li>
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id236">
+      <a class="reference internal nav-link" href="#id239">
        Aliases
       </a>
      </li>
@@ -3335,17 +3361,17 @@
     </a>
     <ul class="nav section-nav flex-column">
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id237">
+      <a class="reference internal nav-link" href="#id240">
        Arguments
       </a>
      </li>
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id238">
+      <a class="reference internal nav-link" href="#id241">
        Example
       </a>
      </li>
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id239">
+      <a class="reference internal nav-link" href="#id242">
        Aliases
       </a>
      </li>
@@ -3361,17 +3387,17 @@
     </a>
     <ul class="nav section-nav flex-column">
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id240">
+      <a class="reference internal nav-link" href="#id243">
        Arguments
       </a>
      </li>
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id241">
+      <a class="reference internal nav-link" href="#id244">
        Example
       </a>
      </li>
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id242">
+      <a class="reference internal nav-link" href="#id245">
        Aliases
       </a>
      </li>
@@ -3387,17 +3413,17 @@
     </a>
     <ul class="nav section-nav flex-column">
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id243">
+      <a class="reference internal nav-link" href="#id246">
        Arguments
       </a>
      </li>
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id244">
+      <a class="reference internal nav-link" href="#id247">
        Example
       </a>
      </li>
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id245">
+      <a class="reference internal nav-link" href="#id248">
        Aliases
       </a>
      </li>
@@ -3413,17 +3439,17 @@
     </a>
     <ul class="nav section-nav flex-column">
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id246">
+      <a class="reference internal nav-link" href="#id249">
        Arguments
       </a>
      </li>
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id247">
+      <a class="reference internal nav-link" href="#id250">
        Example
       </a>
      </li>
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id248">
+      <a class="reference internal nav-link" href="#id251">
        Aliases
       </a>
      </li>
@@ -3439,17 +3465,17 @@
     </a>
     <ul class="nav section-nav flex-column">
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id249">
+      <a class="reference internal nav-link" href="#id252">
        Arguments
       </a>
      </li>
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id250">
+      <a class="reference internal nav-link" href="#id253">
        Example
       </a>
      </li>
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id251">
+      <a class="reference internal nav-link" href="#id254">
        Aliases
       </a>
      </li>
@@ -3465,17 +3491,17 @@
     </a>
     <ul class="nav section-nav flex-column">
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id252">
+      <a class="reference internal nav-link" href="#id255">
        Arguments
       </a>
      </li>
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id253">
+      <a class="reference internal nav-link" href="#id256">
        Example
       </a>
      </li>
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id254">
+      <a class="reference internal nav-link" href="#id257">
        Aliases
       </a>
      </li>
@@ -3491,17 +3517,17 @@
     </a>
     <ul class="nav section-nav flex-column">
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id255">
+      <a class="reference internal nav-link" href="#id258">
        Arguments
       </a>
      </li>
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id256">
+      <a class="reference internal nav-link" href="#id259">
        Example
       </a>
      </li>
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id257">
+      <a class="reference internal nav-link" href="#id260">
        Aliases
       </a>
      </li>
@@ -3526,12 +3552,12 @@
     </a>
     <ul class="nav section-nav flex-column">
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id258">
+      <a class="reference internal nav-link" href="#id261">
        Arguments
       </a>
      </li>
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id259">
+      <a class="reference internal nav-link" href="#id262">
        Example
       </a>
      </li>
@@ -3547,17 +3573,17 @@
     </a>
     <ul class="nav section-nav flex-column">
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id260">
+      <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="#id261">
+      <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="#id262">
+      <a class="reference internal nav-link" href="#id265">
        Aliases
       </a>
      </li>
@@ -3573,12 +3599,12 @@
     </a>
     <ul class="nav section-nav flex-column">
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id263">
+      <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="#id264">
+      <a class="reference internal nav-link" href="#id267">
        Example
       </a>
      </li>
@@ -3594,12 +3620,12 @@
     </a>
     <ul class="nav section-nav flex-column">
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id265">
+      <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="#id266">
+      <a class="reference internal nav-link" href="#id269">
        Example
       </a>
      </li>
@@ -3776,6 +3802,15 @@
      </code>
     </a>
    </li>
+   <li class="toc-h3 nav-item toc-entry">
+    <a class="reference internal nav-link" href="#list-max">
+     <code class="docutils literal notranslate">
+      <span class="pre">
+       list_max
+      </span>
+     </code>
+    </a>
+   </li>
    <li class="toc-h3 nav-item toc-entry">
     <a class="reference internal nav-link" href="#list-ndims">
      <code class="docutils literal notranslate">
@@ -3975,17 +4010,17 @@
     </a>
     <ul class="nav section-nav flex-column">
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id267">
+      <a class="reference internal nav-link" href="#id270">
        Arguments
       </a>
      </li>
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id268">
+      <a class="reference internal nav-link" href="#id271">
        Example
       </a>
      </li>
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id269">
+      <a class="reference internal nav-link" href="#id272">
        Aliases
       </a>
      </li>
@@ -4010,12 +4045,12 @@
     </a>
     <ul class="nav section-nav flex-column">
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id270">
+      <a class="reference internal nav-link" href="#id273">
        Arguments
       </a>
      </li>
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id271">
+      <a class="reference internal nav-link" href="#id274">
        Example
       </a>
      </li>
@@ -4031,17 +4066,17 @@
     </a>
     <ul class="nav section-nav flex-column">
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id272">
+      <a class="reference internal nav-link" href="#id275">
        Arguments
       </a>
      </li>
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id273">
+      <a class="reference internal nav-link" href="#id276">
        Example
       </a>
      </li>
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id274">
+      <a class="reference internal nav-link" href="#id277">
        Aliases
       </a>
      </li>
@@ -4073,12 +4108,12 @@
     </a>
     <ul class="nav section-nav flex-column">
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id275">
+      <a class="reference internal nav-link" href="#id278">
        Arguments
       </a>
      </li>
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id276">
+      <a class="reference internal nav-link" href="#id279">
        Example
       </a>
      </li>
@@ -4103,17 +4138,17 @@
     </a>
     <ul class="nav section-nav flex-column">
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id277">
+      <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="#id278">
+      <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="#id279">
+      <a class="reference internal nav-link" href="#id282">
        Aliases
       </a>
      </li>
@@ -4145,12 +4180,12 @@
     </a>
     <ul class="nav section-nav flex-column">
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id280">
+      <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="#id281">
+      <a class="reference internal nav-link" href="#id284">
        Example
       </a>
      </li>
@@ -4166,17 +4201,17 @@
     </a>
     <ul class="nav section-nav flex-column">
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id282">
+      <a class="reference internal nav-link" href="#id285">
        Arguments
       </a>
      </li>
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id283">
+      <a class="reference internal nav-link" href="#id286">
        Example
       </a>
      </li>
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id284">
+      <a class="reference internal nav-link" href="#id287">
        Aliases
       </a>
      </li>
@@ -4192,12 +4227,12 @@
     </a>
     <ul class="nav section-nav flex-column">
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id285">
+      <a class="reference internal nav-link" href="#id288">
        Arguments
       </a>
      </li>
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id286">
+      <a class="reference internal nav-link" href="#id289">
        Example
       </a>
      </li>
@@ -4213,12 +4248,12 @@
     </a>
     <ul class="nav section-nav flex-column">
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id287">
+      <a class="reference internal nav-link" href="#id290">
        Arguments
       </a>
      </li>
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id288">
+      <a class="reference internal nav-link" href="#id291">
        Example
       </a>
      </li>
@@ -4241,12 +4276,12 @@
     </a>
     <ul class="nav section-nav flex-column">
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id289">
+      <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="#id290">
+      <a class="reference internal nav-link" href="#id293">
        Example
       </a>
      </li>
@@ -4262,12 +4297,12 @@
     </a>
     <ul class="nav section-nav flex-column">
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id291">
+      <a class="reference internal nav-link" href="#id294">
        Arguments
       </a>
      </li>
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id292">
+      <a class="reference internal nav-link" href="#id295">
        Example
       </a>
      </li>
@@ -4283,12 +4318,12 @@
     </a>
     <ul class="nav section-nav flex-column">
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id293">
+      <a class="reference internal nav-link" href="#id296">
        Arguments
       </a>
      </li>
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id294">
+      <a class="reference internal nav-link" href="#id297">
        Example
       </a>
      </li>
@@ -4304,12 +4339,12 @@
     </a>
     <ul class="nav section-nav flex-column">
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id295">
+      <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="#id296">
+      <a class="reference internal nav-link" href="#id299">
        Example
       </a>
      </li>
@@ -4325,12 +4360,12 @@
     </a>
     <ul class="nav section-nav flex-column">
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id297">
+      <a class="reference internal nav-link" href="#id300">
        Arguments
       </a>
      </li>
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id298">
+      <a class="reference internal nav-link" href="#id301">
        Example
       </a>
      </li>
@@ -4346,12 +4381,12 @@
     </a>
     <ul class="nav section-nav flex-column">
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id299">
+      <a class="reference internal nav-link" href="#id302">
        Arguments
       </a>
      </li>
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id300">
+      <a class="reference internal nav-link" href="#id303">
        Example
       </a>
      </li>
@@ -4374,12 +4409,12 @@
     </a>
     <ul class="nav section-nav flex-column">
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id301">
+      <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="#id302">
+      <a class="reference internal nav-link" href="#id305">
        Example
       </a>
      </li>
@@ -4402,12 +4437,12 @@
     </a>
     <ul class="nav section-nav flex-column">
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id303">
+      <a class="reference internal nav-link" href="#id306">
        Arguments
       </a>
      </li>
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id304">
+      <a class="reference internal nav-link" href="#id307">
        Example
       </a>
      </li>
@@ -4423,12 +4458,12 @@
     </a>
     <ul class="nav section-nav flex-column">
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id305">
+      <a class="reference internal nav-link" href="#id308">
        Arguments
       </a>
      </li>
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id306">
+      <a class="reference internal nav-link" href="#id309">
        Example
       </a>
      </li>
@@ -4444,12 +4479,12 @@
     </a>
     <ul class="nav section-nav flex-column">
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id307">
+      <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="#id308">
+      <a class="reference internal nav-link" href="#id311">
        Example
       </a>
      </li>
@@ -4465,7 +4500,7 @@
     </a>
     <ul class="nav section-nav flex-column">
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id309">
+      <a class="reference internal nav-link" href="#id312">
        Example
       </a>
      </li>
@@ -7143,6 +7178,7 @@ an error will be returned.</p></li>
 <li><p><a class="reference internal" 
href="#array-intersect">array_intersect</a></p></li>
 <li><p><a class="reference internal" href="#array-join">array_join</a></p></li>
 <li><p><a class="reference internal" 
href="#array-length">array_length</a></p></li>
+<li><p><a class="reference internal" href="#array-max">array_max</a></p></li>
 <li><p><a class="reference internal" 
href="#array-ndims">array_ndims</a></p></li>
 <li><p><a class="reference internal" 
href="#array-pop-back">array_pop_back</a></p></li>
 <li><p><a class="reference internal" 
href="#array-pop-front">array_pop_front</a></p></li>
@@ -7188,6 +7224,7 @@ an error will be returned.</p></li>
 <li><p><a class="reference internal" 
href="#list-intersect">list_intersect</a></p></li>
 <li><p><a class="reference internal" href="#list-join">list_join</a></p></li>
 <li><p><a class="reference internal" 
href="#list-length">list_length</a></p></li>
+<li><p><a class="reference internal" href="#list-max">list_max</a></p></li>
 <li><p><a class="reference internal" href="#list-ndims">list_ndims</a></p></li>
 <li><p><a class="reference internal" 
href="#list-pop-back">list_pop_back</a></p></li>
 <li><p><a class="reference internal" 
href="#list-pop-front">list_pop_front</a></p></li>
@@ -7660,51 +7697,81 @@ an error will be returned.</p></li>
 </ul>
 </section>
 </section>
-<section id="array-ndims">
-<h3><code class="docutils literal notranslate"><span 
class="pre">array_ndims</span></code><a class="headerlink" href="#array-ndims" 
title="Link to this heading">¶</a></h3>
-<p>Returns the number of dimensions of the array.</p>
-<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>
+<section id="array-max">
+<h3><code class="docutils literal notranslate"><span 
class="pre">array_max</span></code><a class="headerlink" href="#array-max" 
title="Link to this heading">¶</a></h3>
+<p>Returns the maximum value in the array.</p>
+<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="id201">
 <h4>Arguments<a class="headerlink" href="#id201" 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="id202">
 <h4>Example<a class="headerlink" href="#id202" title="Link to this 
heading">¶</a></h4>
-<div class="highlight-sql notranslate"><div 
class="highlight"><pre><span></span><span class="o">&gt;</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 [...]
-<span class="o">+</span><span 
class="c1">----------------------------------+</span>
-<span class="o">|</span><span class="w"> </span><span class="mi">2</span><span 
class="w">                                </span><span class="o">|</span>
-<span class="o">+</span><span 
class="c1">----------------------------------+</span>
+<div class="highlight-sql notranslate"><div 
class="highlight"><pre><span></span><span class="o">&gt;</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>
+<span class="o">+</span><span 
class="c1">-----------------------------------------+</span>
+<span class="o">|</span><span class="w"> </span><span class="mi">4</span><span 
class="w">                                       </span><span class="o">|</span>
+<span class="o">+</span><span 
class="c1">-----------------------------------------+</span>
 </pre></div>
 </div>
 </section>
 <section id="id203">
 <h4>Aliases<a class="headerlink" href="#id203" title="Link to this 
heading">¶</a></h4>
 <ul class="simple">
-<li><p>list_ndims</p></li>
+<li><p>list_max</p></li>
 </ul>
 </section>
 </section>
-<section id="array-pop-back">
-<h3><code class="docutils literal notranslate"><span 
class="pre">array_pop_back</span></code><a class="headerlink" 
href="#array-pop-back" title="Link to this heading">¶</a></h3>
-<p>Returns the array without the last element.</p>
-<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="id204">
+<section id="array-ndims">
+<h3><code class="docutils literal notranslate"><span 
class="pre">array_ndims</span></code><a class="headerlink" href="#array-ndims" 
title="Link to this heading">¶</a></h3>
+<p>Returns the number of dimensions of the array.</p>
+<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="id204">
 <h4>Arguments<a class="headerlink" href="#id204" 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="id205">
 <h4>Example<a class="headerlink" href="#id205" title="Link to this 
heading">¶</a></h4>
+<div class="highlight-sql notranslate"><div 
class="highlight"><pre><span></span><span class="o">&gt;</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 [...]
+<span class="o">+</span><span 
class="c1">----------------------------------+</span>
+<span class="o">|</span><span class="w"> </span><span class="mi">2</span><span 
class="w">                                </span><span class="o">|</span>
+<span class="o">+</span><span 
class="c1">----------------------------------+</span>
+</pre></div>
+</div>
+</section>
+<section id="id206">
+<h4>Aliases<a class="headerlink" href="#id206" title="Link to this 
heading">¶</a></h4>
+<ul class="simple">
+<li><p>list_ndims</p></li>
+</ul>
+</section>
+</section>
+<section id="array-pop-back">
+<h3><code class="docutils literal notranslate"><span 
class="pre">array_pop_back</span></code><a class="headerlink" 
href="#array-pop-back" title="Link to this heading">¶</a></h3>
+<p>Returns the array without the last element.</p>
+<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="id207">
+<h4>Arguments<a class="headerlink" href="#id207" 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="id208">
+<h4>Example<a class="headerlink" href="#id208" title="Link to this 
heading">¶</a></h4>
 <div class="highlight-sql notranslate"><div 
class="highlight"><pre><span></span><span class="o">&gt;</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>
@@ -7714,8 +7781,8 @@ an error will be returned.</p></li>
 </pre></div>
 </div>
 </section>
-<section id="id206">
-<h4>Aliases<a class="headerlink" href="#id206" title="Link to this 
heading">¶</a></h4>
+<section id="id209">
+<h4>Aliases<a class="headerlink" href="#id209" title="Link to this 
heading">¶</a></h4>
 <ul class="simple">
 <li><p>list_pop_back</p></li>
 </ul>
@@ -7727,14 +7794,14 @@ an error will be returned.</p></li>
 <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="id207">
-<h4>Arguments<a class="headerlink" href="#id207" title="Link to this 
heading">¶</a></h4>
+<section id="id210">
+<h4>Arguments<a class="headerlink" href="#id210" 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="id208">
-<h4>Example<a class="headerlink" href="#id208" title="Link to this 
heading">¶</a></h4>
+<section id="id211">
+<h4>Example<a class="headerlink" href="#id211" title="Link to this 
heading">¶</a></h4>
 <div class="highlight-sql notranslate"><div 
class="highlight"><pre><span></span><span class="o">&gt;</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>
@@ -7744,8 +7811,8 @@ an error will be returned.</p></li>
 </pre></div>
 </div>
 </section>
-<section id="id209">
-<h4>Aliases<a class="headerlink" href="#id209" title="Link to this 
heading">¶</a></h4>
+<section id="id212">
+<h4>Aliases<a class="headerlink" href="#id212" title="Link to this 
heading">¶</a></h4>
 <ul class="simple">
 <li><p>list_pop_front</p></li>
 </ul>
@@ -7758,16 +7825,16 @@ an error will be returned.</p></li>
 <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="id210">
-<h4>Arguments<a class="headerlink" href="#id210" title="Link to this 
heading">¶</a></h4>
+<section id="id213">
+<h4>Arguments<a class="headerlink" href="#id213" 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 position in the 
array.</p></li>
 <li><p><strong>index</strong>: Index at which to start searching.</p></li>
 </ul>
 </section>
-<section id="id211">
-<h4>Example<a class="headerlink" href="#id211" title="Link to this 
heading">¶</a></h4>
+<section id="id214">
+<h4>Example<a class="headerlink" href="#id214" title="Link to this 
heading">¶</a></h4>
 <div class="highlight-sql notranslate"><div 
class="highlight"><pre><span></span><span class="o">&gt;</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 [...]
@@ -7783,8 +7850,8 @@ an error will be returned.</p></li>
 </pre></div>
 </div>
 </section>
-<section id="id212">
-<h4>Aliases<a class="headerlink" href="#id212" title="Link to this 
heading">¶</a></h4>
+<section id="id215">
+<h4>Aliases<a class="headerlink" href="#id215" title="Link to this 
heading">¶</a></h4>
 <ul class="simple">
 <li><p>list_position</p></li>
 <li><p>array_indexof</p></li>
@@ -7798,15 +7865,15 @@ an error will be returned.</p></li>
 <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="id213">
-<h4>Arguments<a class="headerlink" href="#id213" title="Link to this 
heading">¶</a></h4>
+<section id="id216">
+<h4>Arguments<a class="headerlink" href="#id216" 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 position in the 
array.</p></li>
 </ul>
 </section>
-<section id="id214">
-<h4>Example<a class="headerlink" href="#id214" title="Link to this 
heading">¶</a></h4>
+<section id="id217">
+<h4>Example<a class="headerlink" href="#id217" title="Link to this 
heading">¶</a></h4>
 <div class="highlight-sql notranslate"><div 
class="highlight"><pre><span></span><span class="o">&gt;</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  
[...]
@@ -7816,8 +7883,8 @@ an error will be returned.</p></li>
 </pre></div>
 </div>
 </section>
-<section id="id215">
-<h4>Aliases<a class="headerlink" href="#id215" title="Link to this 
heading">¶</a></h4>
+<section id="id218">
+<h4>Aliases<a class="headerlink" href="#id218" title="Link to this 
heading">¶</a></h4>
 <ul class="simple">
 <li><p>list_positions</p></li>
 </ul>
@@ -7829,15 +7896,15 @@ an error will be returned.</p></li>
 <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="id216">
-<h4>Arguments<a class="headerlink" href="#id216" title="Link to this 
heading">¶</a></h4>
+<section id="id219">
+<h4>Arguments<a class="headerlink" href="#id219" 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="id217">
-<h4>Example<a class="headerlink" href="#id217" title="Link to this 
heading">¶</a></h4>
+<section id="id220">
+<h4>Example<a class="headerlink" href="#id220" title="Link to this 
heading">¶</a></h4>
 <div class="highlight-sql notranslate"><div 
class="highlight"><pre><span></span><span class="o">&gt;</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>
@@ -7847,8 +7914,8 @@ an error will be returned.</p></li>
 </pre></div>
 </div>
 </section>
-<section id="id218">
-<h4>Aliases<a class="headerlink" href="#id218" title="Link to this 
heading">¶</a></h4>
+<section id="id221">
+<h4>Aliases<a class="headerlink" href="#id221" title="Link to this 
heading">¶</a></h4>
 <ul class="simple">
 <li><p>list_prepend</p></li>
 <li><p>array_push_front</p></li>
@@ -7870,15 +7937,15 @@ an error will be returned.</p></li>
 <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="id219">
-<h4>Arguments<a class="headerlink" href="#id219" title="Link to this 
heading">¶</a></h4>
+<section id="id222">
+<h4>Arguments<a class="headerlink" href="#id222" 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="id220">
-<h4>Example<a class="headerlink" href="#id220" title="Link to this 
heading">¶</a></h4>
+<section id="id223">
+<h4>Example<a class="headerlink" href="#id223" title="Link to this 
heading">¶</a></h4>
 <div class="highlight-sql notranslate"><div 
class="highlight"><pre><span></span><span class="o">&gt;</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 [...]
@@ -7888,8 +7955,8 @@ an error will be returned.</p></li>
 </pre></div>
 </div>
 </section>
-<section id="id221">
-<h4>Aliases<a class="headerlink" href="#id221" title="Link to this 
heading">¶</a></h4>
+<section id="id224">
+<h4>Aliases<a class="headerlink" href="#id224" title="Link to this 
heading">¶</a></h4>
 <ul class="simple">
 <li><p>list_remove</p></li>
 </ul>
@@ -7901,15 +7968,15 @@ an error will be returned.</p></li>
 <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="id222">
-<h4>Arguments<a class="headerlink" href="#id222" title="Link to this 
heading">¶</a></h4>
+<section id="id225">
+<h4>Arguments<a class="headerlink" href="#id225" 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="id223">
-<h4>Example<a class="headerlink" href="#id223" title="Link to this 
heading">¶</a></h4>
+<section id="id226">
+<h4>Example<a class="headerlink" href="#id226" title="Link to this 
heading">¶</a></h4>
 <div class="highlight-sql notranslate"><div 
class="highlight"><pre><span></span><span class="o">&gt;</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 
[...]
@@ -7919,8 +7986,8 @@ an error will be returned.</p></li>
 </pre></div>
 </div>
 </section>
-<section id="id224">
-<h4>Aliases<a class="headerlink" href="#id224" title="Link to this 
heading">¶</a></h4>
+<section id="id227">
+<h4>Aliases<a class="headerlink" href="#id227" title="Link to this 
heading">¶</a></h4>
 <ul class="simple">
 <li><p>list_remove_all</p></li>
 </ul>
@@ -7932,16 +7999,16 @@ an error will be returned.</p></li>
 <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="id225">
-<h4>Arguments<a class="headerlink" href="#id225" title="Link to this 
heading">¶</a></h4>
+<section id="id228">
+<h4>Arguments<a class="headerlink" href="#id228" 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="id226">
-<h4>Example<a class="headerlink" href="#id226" title="Link to this 
heading">¶</a></h4>
+<section id="id229">
+<h4>Example<a class="headerlink" href="#id229" title="Link to this 
heading">¶</a></h4>
 <div class="highlight-sql notranslate"><div 
class="highlight"><pre><span></span><span class="o">&gt;</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= [...]
@@ -7951,8 +8018,8 @@ an error will be returned.</p></li>
 </pre></div>
 </div>
 </section>
-<section id="id227">
-<h4>Aliases<a class="headerlink" href="#id227" title="Link to this 
heading">¶</a></h4>
+<section id="id230">
+<h4>Aliases<a class="headerlink" href="#id230" title="Link to this 
heading">¶</a></h4>
 <ul class="simple">
 <li><p>list_remove_n</p></li>
 </ul>
@@ -7964,15 +8031,15 @@ an error will be returned.</p></li>
 <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="id228">
-<h4>Arguments<a class="headerlink" href="#id228" title="Link to this 
heading">¶</a></h4>
+<section id="id231">
+<h4>Arguments<a class="headerlink" href="#id231" 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="id229">
-<h4>Example<a class="headerlink" href="#id229" title="Link to this 
heading">¶</a></h4>
+<section id="id232">
+<h4>Example<a class="headerlink" href="#id232" title="Link to this 
heading">¶</a></h4>
 <div class="highlight-sql notranslate"><div 
class="highlight"><pre><span></span><span class="o">&gt;</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>
@@ -7988,8 +8055,8 @@ an error will be returned.</p></li>
 </pre></div>
 </div>
 </section>
-<section id="id230">
-<h4>Aliases<a class="headerlink" href="#id230" title="Link to this 
heading">¶</a></h4>
+<section id="id233">
+<h4>Aliases<a class="headerlink" href="#id233" title="Link to this 
heading">¶</a></h4>
 <ul class="simple">
 <li><p>list_repeat</p></li>
 </ul>
@@ -8001,16 +8068,16 @@ an error will be returned.</p></li>
 <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="id231">
-<h4>Arguments<a class="headerlink" href="#id231" title="Link to this 
heading">¶</a></h4>
+<section id="id234">
+<h4>Arguments<a class="headerlink" href="#id234" 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="id232">
-<h4>Example<a class="headerlink" href="#id232" title="Link to this 
heading">¶</a></h4>
+<section id="id235">
+<h4>Example<a class="headerlink" href="#id235" title="Link to this 
heading">¶</a></h4>
 <div class="highlight-sql notranslate"><div 
class="highlight"><pre><span></span><span class="o">&gt;</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=" [...]
@@ -8020,8 +8087,8 @@ an error will be returned.</p></li>
 </pre></div>
 </div>
 </section>
-<section id="id233">
-<h4>Aliases<a class="headerlink" href="#id233" title="Link to this 
heading">¶</a></h4>
+<section id="id236">
+<h4>Aliases<a class="headerlink" href="#id236" title="Link to this 
heading">¶</a></h4>
 <ul class="simple">
 <li><p>list_replace</p></li>
 </ul>
@@ -8033,16 +8100,16 @@ an error will be returned.</p></li>
 <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="id234">
-<h4>Arguments<a class="headerlink" href="#id234" title="Link to this 
heading">¶</a></h4>
+<section id="id237">
+<h4>Arguments<a class="headerlink" href="#id237" 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="id235">
-<h4>Example<a class="headerlink" href="#id235" title="Link to this 
heading">¶</a></h4>
+<section id="id238">
+<h4>Example<a class="headerlink" href="#id238" title="Link to this 
heading">¶</a></h4>
 <div class="highlight-sql notranslate"><div 
class="highlight"><pre><span></span><span class="o">&gt;</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 
[...]
@@ -8052,8 +8119,8 @@ an error will be returned.</p></li>
 </pre></div>
 </div>
 </section>
-<section id="id236">
-<h4>Aliases<a class="headerlink" href="#id236" title="Link to this 
heading">¶</a></h4>
+<section id="id239">
+<h4>Aliases<a class="headerlink" href="#id239" title="Link to this 
heading">¶</a></h4>
 <ul class="simple">
 <li><p>list_replace_all</p></li>
 </ul>
@@ -8065,8 +8132,8 @@ an error will be returned.</p></li>
 <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="id237">
-<h4>Arguments<a class="headerlink" href="#id237" title="Link to this 
heading">¶</a></h4>
+<section id="id240">
+<h4>Arguments<a class="headerlink" href="#id240" 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>
@@ -8074,8 +8141,8 @@ an error will be returned.</p></li>
 <li><p><strong>max</strong>: Number of first occurrences to replace.</p></li>
 </ul>
 </section>
-<section id="id238">
-<h4>Example<a class="headerlink" href="#id238" title="Link to this 
heading">¶</a></h4>
+<section id="id241">
+<h4>Example<a class="headerlink" href="#id241" title="Link to this 
heading">¶</a></h4>
 <div class="highlight-sql notranslate"><div 
class="highlight"><pre><span></span><span class="o">&gt;</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 
[...]
@@ -8085,8 +8152,8 @@ an error will be returned.</p></li>
 </pre></div>
 </div>
 </section>
-<section id="id239">
-<h4>Aliases<a class="headerlink" href="#id239" title="Link to this 
heading">¶</a></h4>
+<section id="id242">
+<h4>Aliases<a class="headerlink" href="#id242" title="Link to this 
heading">¶</a></h4>
 <ul class="simple">
 <li><p>list_replace_n</p></li>
 </ul>
@@ -8098,16 +8165,16 @@ an error will be returned.</p></li>
 <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="id240">
-<h4>Arguments<a class="headerlink" href="#id240" title="Link to this 
heading">¶</a></h4>
+<section id="id243">
+<h4>Arguments<a class="headerlink" href="#id243" 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="id241">
-<h4>Example<a class="headerlink" href="#id241" title="Link to this 
heading">¶</a></h4>
+<section id="id244">
+<h4>Example<a class="headerlink" href="#id244" title="Link to this 
heading">¶</a></h4>
 <div class="highlight-sql notranslate"><div 
class="highlight"><pre><span></span><span class="o">&gt;</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>
@@ -8117,8 +8184,8 @@ an error will be returned.</p></li>
 </pre></div>
 </div>
 </section>
-<section id="id242">
-<h4>Aliases<a class="headerlink" href="#id242" title="Link to this 
heading">¶</a></h4>
+<section id="id245">
+<h4>Aliases<a class="headerlink" href="#id245" title="Link to this 
heading">¶</a></h4>
 <ul class="simple">
 <li><p>list_resize</p></li>
 </ul>
@@ -8130,14 +8197,14 @@ an error will be returned.</p></li>
 <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="id243">
-<h4>Arguments<a class="headerlink" href="#id243" title="Link to this 
heading">¶</a></h4>
+<section id="id246">
+<h4>Arguments<a class="headerlink" href="#id246" 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="id244">
-<h4>Example<a class="headerlink" href="#id244" title="Link to this 
heading">¶</a></h4>
+<section id="id247">
+<h4>Example<a class="headerlink" href="#id247" title="Link to this 
heading">¶</a></h4>
 <div class="highlight-sql notranslate"><div 
class="highlight"><pre><span></span><span class="o">&gt;</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=" [...]
@@ -8147,8 +8214,8 @@ an error will be returned.</p></li>
 </pre></div>
 </div>
 </section>
-<section id="id245">
-<h4>Aliases<a class="headerlink" href="#id245" title="Link to this 
heading">¶</a></h4>
+<section id="id248">
+<h4>Aliases<a class="headerlink" href="#id248" title="Link to this 
heading">¶</a></h4>
 <ul class="simple">
 <li><p>list_reverse</p></li>
 </ul>
@@ -8160,8 +8227,8 @@ an error will be returned.</p></li>
 <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="id246">
-<h4>Arguments<a class="headerlink" href="#id246" title="Link to this 
heading">¶</a></h4>
+<section id="id249">
+<h4>Arguments<a class="headerlink" href="#id249" 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>
@@ -8169,8 +8236,8 @@ an error will be returned.</p></li>
 <li><p><strong>stride</strong>: Stride of the array slice. The default is 
1.</p></li>
 </ul>
 </section>
-<section id="id247">
-<h4>Example<a class="headerlink" href="#id247" title="Link to this 
heading">¶</a></h4>
+<section id="id250">
+<h4>Example<a class="headerlink" href="#id250" title="Link to this 
heading">¶</a></h4>
 <div class="highlight-sql notranslate"><div 
class="highlight"><pre><span></span><span class="o">&gt;</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" [...]
@@ -8180,8 +8247,8 @@ an error will be returned.</p></li>
 </pre></div>
 </div>
 </section>
-<section id="id248">
-<h4>Aliases<a class="headerlink" href="#id248" title="Link to this 
heading">¶</a></h4>
+<section id="id251">
+<h4>Aliases<a class="headerlink" href="#id251" title="Link to this 
heading">¶</a></h4>
 <ul class="simple">
 <li><p>list_slice</p></li>
 </ul>
@@ -8193,16 +8260,16 @@ an error will be returned.</p></li>
 <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="id249">
-<h4>Arguments<a class="headerlink" href="#id249" title="Link to this 
heading">¶</a></h4>
+<section id="id252">
+<h4>Arguments<a class="headerlink" href="#id252" 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 descending order(<code 
class="docutils literal notranslate"><span class="pre">ASC</span></code> or 
<code class="docutils literal notranslate"><span 
class="pre">DESC</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 <code class="docutils literal 
notranslate"><span class="pre">NULLS</span> <span 
class="pre">LAST</span></code>).</p></li>
 </ul>
 </section>
-<section id="id250">
-<h4>Example<a class="headerlink" href="#id250" title="Link to this 
heading">¶</a></h4>
+<section id="id253">
+<h4>Example<a class="headerlink" href="#id253" title="Link to this 
heading">¶</a></h4>
 <div class="highlight-sql notranslate"><div 
class="highlight"><pre><span></span><span class="o">&gt;</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>
@@ -8212,8 +8279,8 @@ an error will be returned.</p></li>
 </pre></div>
 </div>
 </section>
-<section id="id251">
-<h4>Aliases<a class="headerlink" href="#id251" title="Link to this 
heading">¶</a></h4>
+<section id="id254">
+<h4>Aliases<a class="headerlink" href="#id254" title="Link to this 
heading">¶</a></h4>
 <ul class="simple">
 <li><p>list_sort</p></li>
 </ul>
@@ -8225,16 +8292,16 @@ an error will be returned.</p></li>
 <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="id252">
-<h4>Arguments<a class="headerlink" href="#id252" title="Link to this 
heading">¶</a></h4>
+<section id="id255">
+<h4>Arguments<a class="headerlink" href="#id255" 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 replace null values 
in the array. If not provided, nulls will be handled by default 
behavior.</p></li>
 </ul>
 </section>
-<section id="id253">
-<h4>Example<a class="headerlink" href="#id253" title="Link to this 
heading">¶</a></h4>
+<section id="id256">
+<h4>Example<a class="headerlink" href="#id256" title="Link to this 
heading">¶</a></h4>
 <div class="highlight-sql notranslate"><div 
class="highlight"><pre><span></span><span class="o">&gt;</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 
[...]
@@ -8244,8 +8311,8 @@ an error will be returned.</p></li>
 </pre></div>
 </div>
 </section>
-<section id="id254">
-<h4>Aliases<a class="headerlink" href="#id254" title="Link to this 
heading">¶</a></h4>
+<section id="id257">
+<h4>Aliases<a class="headerlink" href="#id257" title="Link to this 
heading">¶</a></h4>
 <ul class="simple">
 <li><p>list_to_string</p></li>
 <li><p>array_join</p></li>
@@ -8259,15 +8326,15 @@ an error will be returned.</p></li>
 <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="id255">
-<h4>Arguments<a class="headerlink" href="#id255" title="Link to this 
heading">¶</a></h4>
+<section id="id258">
+<h4>Arguments<a class="headerlink" href="#id258" 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="id256">
-<h4>Example<a class="headerlink" href="#id256" title="Link to this 
heading">¶</a></h4>
+<section id="id259">
+<h4>Example<a class="headerlink" href="#id259" title="Link to this 
heading">¶</a></h4>
 <div class="highlight-sql notranslate"><div 
class="highlight"><pre><span></span><span class="o">&gt;</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"> </ [...]
@@ -8283,8 +8350,8 @@ an error will be returned.</p></li>
 </pre></div>
 </div>
 </section>
-<section id="id257">
-<h4>Aliases<a class="headerlink" href="#id257" title="Link to this 
heading">¶</a></h4>
+<section id="id260">
+<h4>Aliases<a class="headerlink" href="#id260" title="Link to this 
heading">¶</a></h4>
 <ul class="simple">
 <li><p>list_union</p></li>
 </ul>
@@ -8300,14 +8367,14 @@ an error will be returned.</p></li>
 <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="id258">
-<h4>Arguments<a class="headerlink" href="#id258" title="Link to this 
heading">¶</a></h4>
+<section id="id261">
+<h4>Arguments<a class="headerlink" href="#id261" 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="id259">
-<h4>Example<a class="headerlink" href="#id259" title="Link to this 
heading">¶</a></h4>
+<section id="id262">
+<h4>Example<a class="headerlink" href="#id262" title="Link to this 
heading">¶</a></h4>
 <div class="highlight-sql notranslate"><div 
class="highlight"><pre><span></span><span class="o">&gt;</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" [...]
@@ -8324,14 +8391,14 @@ an error will be returned.</p></li>
 <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="id260">
-<h4>Arguments<a class="headerlink" href="#id260" title="Link to this 
heading">¶</a></h4>
+<section id="id263">
+<h4>Arguments<a class="headerlink" href="#id263" title="Link to this 
heading">¶</a></h4>
 <ul class="simple">
 <li><p><strong>array</strong>: Array expression. Can be a constant, column, or 
function, and any combination of array operators.</p></li>
 </ul>
 </section>
-<section id="id261">
-<h4>Example<a class="headerlink" href="#id261" title="Link to this 
heading">¶</a></h4>
+<section id="id264">
+<h4>Example<a class="headerlink" href="#id264" title="Link to this 
heading">¶</a></h4>
 <div class="highlight-sql notranslate"><div 
class="highlight"><pre><span></span><span class="o">&gt;</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>
@@ -8341,8 +8408,8 @@ an error will be returned.</p></li>
 </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>array_empty</p></li>
 <li><p>list_empty</p></li>
@@ -8360,14 +8427,14 @@ an error will be returned.</p></li>
 <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="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">&gt;</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>
@@ -8384,16 +8451,16 @@ an error will be returned.</p></li>
 <div class="highlight-sql notranslate"><div 
class="highlight"><pre><span></span><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="id265">
-<h4>Arguments<a class="headerlink" href="#id265" title="Link to this 
heading">¶</a></h4>
+<section id="id268">
+<h4>Arguments<a class="headerlink" href="#id268" title="Link to this 
heading">¶</a></h4>
 <ul class="simple">
 <li><p><strong>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="id266">
-<h4>Example<a class="headerlink" href="#id266" title="Link to this 
heading">¶</a></h4>
+<section id="id269">
+<h4>Example<a class="headerlink" href="#id269" title="Link to this 
heading">¶</a></h4>
 <div class="highlight-sql notranslate"><div 
class="highlight"><pre><span></span><span class="o">&gt;</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>
@@ -8480,6 +8547,10 @@ an error will be returned.</p></li>
 <h3><code class="docutils literal notranslate"><span 
class="pre">list_length</span></code><a class="headerlink" href="#list-length" 
title="Link to this heading">¶</a></h3>
 <p><em>Alias of <a class="reference internal" 
href="#array-length">array_length</a>.</em></p>
 </section>
+<section id="list-max">
+<h3><code class="docutils literal notranslate"><span 
class="pre">list_max</span></code><a class="headerlink" href="#list-max" 
title="Link to this heading">¶</a></h3>
+<p><em>Alias of <a class="reference internal" 
href="#array-max">array_max</a>.</em></p>
+</section>
 <section id="list-ndims">
 <h3><code class="docutils literal notranslate"><span 
class="pre">list_ndims</span></code><a class="headerlink" href="#list-ndims" 
title="Link to this heading">¶</a></h3>
 <p><em>Alias of <a class="reference internal" 
href="#array-ndims">array_ndims</a>.</em></p>
@@ -8570,14 +8641,14 @@ an error will be returned.</p></li>
 <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="id267">
-<h4>Arguments<a class="headerlink" href="#id267" title="Link to this 
heading">¶</a></h4>
+<section id="id270">
+<h4>Arguments<a class="headerlink" href="#id270" 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="id268">
-<h4>Example<a class="headerlink" href="#id268" title="Link to this 
heading">¶</a></h4>
+<section id="id271">
+<h4>Example<a class="headerlink" href="#id271" title="Link to this 
heading">¶</a></h4>
 <div class="highlight-sql notranslate"><div 
class="highlight"><pre><span></span><span class="o">&gt;</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 
[...]
@@ -8587,8 +8658,8 @@ an error will be returned.</p></li>
 </pre></div>
 </div>
 </section>
-<section id="id269">
-<h4>Aliases<a class="headerlink" href="#id269" title="Link to this 
heading">¶</a></h4>
+<section id="id272">
+<h4>Aliases<a class="headerlink" href="#id272" title="Link to this 
heading">¶</a></h4>
 <ul class="simple">
 <li><p>make_list</p></li>
 </ul>
@@ -8604,16 +8675,16 @@ an error will be returned.</p></li>
 <div class="highlight-sql notranslate"><div 
class="highlight"><pre><span></span><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="id270">
-<h4>Arguments<a class="headerlink" href="#id270" title="Link to this 
heading">¶</a></h4>
+<section id="id273">
+<h4>Arguments<a class="headerlink" href="#id273" 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="id271">
-<h4>Example<a class="headerlink" href="#id271" title="Link to this 
heading">¶</a></h4>
+<section id="id274">
+<h4>Example<a class="headerlink" href="#id274" title="Link to this 
heading">¶</a></h4>
 <div class="highlight-sql notranslate"><div 
class="highlight"><pre><span></span><span class="o">&gt;</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>
@@ -8637,16 +8708,16 @@ an error will be returned.</p></li>
 <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="id272">
-<h4>Arguments<a class="headerlink" href="#id272" title="Link to this 
heading">¶</a></h4>
+<section id="id275">
+<h4>Arguments<a class="headerlink" href="#id275" 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="id273">
-<h4>Example<a class="headerlink" href="#id273" title="Link to this 
heading">¶</a></h4>
+<section id="id276">
+<h4>Example<a class="headerlink" href="#id276" title="Link to this 
heading">¶</a></h4>
 <div class="highlight-sql notranslate"><div 
class="highlight"><pre><span></span><span class="o">&gt;</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">&#39;abc##def&#39;</span><span class="p">,</span><span class="w"> 
</span><span class="s1">&#39;##&#39;</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">&#39;abc##def&#39;</span><span class="p">))</span><span class="w">  
</span><span class="o">|</span>
@@ -8662,8 +8733,8 @@ an error will be returned.</p></li>
 </pre></div>
 </div>
 </section>
-<section id="id274">
-<h4>Aliases<a class="headerlink" href="#id274" title="Link to this 
heading">¶</a></h4>
+<section id="id277">
+<h4>Aliases<a class="headerlink" href="#id277" title="Link to this 
heading">¶</a></h4>
 <ul class="simple">
 <li><p>string_to_list</p></li>
 </ul>
@@ -8687,15 +8758,15 @@ an error will be returned.</p></li>
 <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="id275">
-<h4>Arguments<a class="headerlink" href="#id275" title="Link to this 
heading">¶</a></h4>
+<section id="id278">
+<h4>Arguments<a class="headerlink" href="#id278" 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="id276">
-<h4>Example<a class="headerlink" href="#id276" title="Link to this 
heading">¶</a></h4>
+<section id="id279">
+<h4>Example<a class="headerlink" href="#id279" 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">&gt;</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>
@@ -8728,14 +8799,14 @@ For example: <code class="docutils literal 
notranslate"><span class="pre">c0</sp
 <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="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>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="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>
 <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">&gt;</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>
@@ -8766,8 +8837,8 @@ a struct type of fields <code class="docutils literal 
notranslate"><span class="
 </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>row</p></li>
 </ul>
@@ -8796,8 +8867,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">&#39;key1&#39;</span><span class="p">,</span><span class="w"> 
</span><span class="s1">&#39;key2&#39;</span><span class="p">],</span><span 
class="w"> </span><span class="p">[</span><span 
class="s1">&#39;value1&#39;</span><span class="p">,</span><span class="w"> 
</span><span class="s1">&#39;value2&#39;</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>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>
@@ -8805,8 +8876,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="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="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">&#39;type&#39;</span><span class="p">,</span><span class="w"> 
</span><span class="s1">&#39;test&#39;</span><span class="p">);</span>
 <span class="c1">----</span>
@@ -8842,15 +8913,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="id282">
-<h4>Arguments<a class="headerlink" href="#id282" title="Link to this 
heading">¶</a></h4>
+<section id="id285">
+<h4>Arguments<a class="headerlink" href="#id285" 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="id283">
-<h4>Example<a class="headerlink" href="#id283" title="Link to this 
heading">¶</a></h4>
+<section id="id286">
+<h4>Example<a class="headerlink" href="#id286" 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">&#39;a&#39;</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">&#39;b&#39;</span><span class="p">:</span><span clas [...]
 <span class="c1">----</span>
 <span class="p">[</span><span class="mi">1</span><span class="p">]</span>
@@ -8865,8 +8936,8 @@ For <code class="docutils literal notranslate"><span 
class="pre">make_map</span>
 </pre></div>
 </div>
 </section>
-<section id="id284">
-<h4>Aliases<a class="headerlink" href="#id284" title="Link to this 
heading">¶</a></h4>
+<section id="id287">
+<h4>Aliases<a class="headerlink" href="#id287" title="Link to this 
heading">¶</a></h4>
 <ul class="simple">
 <li><p>element_at</p></li>
 </ul>
@@ -8878,14 +8949,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="id285">
-<h4>Arguments<a class="headerlink" href="#id285" title="Link to this 
heading">¶</a></h4>
+<section id="id288">
+<h4>Arguments<a class="headerlink" href="#id288" 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="id286">
-<h4>Example<a class="headerlink" href="#id286" title="Link to this 
heading">¶</a></h4>
+<section id="id289">
+<h4>Example<a class="headerlink" href="#id289" 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">&#39;a&#39;</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">&#39;b&#39;</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>
@@ -8903,14 +8974,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="id287">
-<h4>Arguments<a class="headerlink" href="#id287" title="Link to this 
heading">¶</a></h4>
+<section id="id290">
+<h4>Arguments<a class="headerlink" href="#id290" 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="id288">
-<h4>Example<a class="headerlink" href="#id288" title="Link to this 
heading">¶</a></h4>
+<section id="id291">
+<h4>Example<a class="headerlink" href="#id291" 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">&#39;a&#39;</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">&#39;b&#39;</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>
@@ -8939,8 +9010,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="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>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>
@@ -8957,8 +9028,8 @@ For <code class="docutils literal notranslate"><span 
class="pre">make_map</span>
 </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">&gt;</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">&#39;foo&#39;</span><span class="p">,</span><span class="w"> 
</span><span class="s1">&#39;sha256&#39;</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">&quot;foo&quot;</span><span 
class="p">),</span><span class="w"> </span><span class="n">Utf8</span><span 
class="p">(</span><span class="ss">&quot;sha256&quot;</span><span 
class="p">))</span><span class="w">      </span><span class="o">|</span>
@@ -8975,14 +9046,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="id291">
-<h4>Arguments<a class="headerlink" href="#id291" title="Link to this 
heading">¶</a></h4>
+<section id="id294">
+<h4>Arguments<a class="headerlink" href="#id294" 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="id292">
-<h4>Example<a class="headerlink" href="#id292" title="Link to this 
heading">¶</a></h4>
+<section id="id295">
+<h4>Example<a class="headerlink" href="#id295" title="Link to this 
heading">¶</a></h4>
 <div class="highlight-sql notranslate"><div 
class="highlight"><pre><span></span><span class="o">&gt;</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">&#39;foo&#39;</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">&quot;foo&quot;</span><span 
class="p">))</span><span class="w">                    </span><span 
class="o">|</span>
@@ -8999,14 +9070,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="id293">
-<h4>Arguments<a class="headerlink" href="#id293" title="Link to this 
heading">¶</a></h4>
+<section id="id296">
+<h4>Arguments<a class="headerlink" href="#id296" 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="id294">
-<h4>Example<a class="headerlink" href="#id294" title="Link to this 
heading">¶</a></h4>
+<section id="id297">
+<h4>Example<a class="headerlink" href="#id297" title="Link to this 
heading">¶</a></h4>
 <div class="highlight-sql notranslate"><div 
class="highlight"><pre><span></span><span class="o">&gt;</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">&#39;foo&#39;</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">&quot;foo&quot;</span><span 
class="p">))</span><span class="w">                      </span><span 
class="o">|</span>
@@ -9023,14 +9094,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="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>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="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">&gt;</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">&#39;foo&#39;</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">&quot;foo&quot;</span><span 
class="p">))</span><span class="w">                  </span><span 
class="o">|</span>
@@ -9047,14 +9118,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="id297">
-<h4>Arguments<a class="headerlink" href="#id297" title="Link to this 
heading">¶</a></h4>
+<section id="id300">
+<h4>Arguments<a class="headerlink" href="#id300" 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="id298">
-<h4>Example<a class="headerlink" href="#id298" title="Link to this 
heading">¶</a></h4>
+<section id="id301">
+<h4>Example<a class="headerlink" href="#id301" title="Link to this 
heading">¶</a></h4>
 <div class="highlight-sql notranslate"><div 
class="highlight"><pre><span></span><span class="o">&gt;</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">&#39;foo&#39;</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">&quot;foo&quot;</span><span 
class="p">))</span><span class="w">                     </span><span 
class="o">|</span>
@@ -9071,14 +9142,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="id299">
-<h4>Arguments<a class="headerlink" href="#id299" title="Link to this 
heading">¶</a></h4>
+<section id="id302">
+<h4>Arguments<a class="headerlink" href="#id302" 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="id300">
-<h4>Example<a class="headerlink" href="#id300" title="Link to this 
heading">¶</a></h4>
+<section id="id303">
+<h4>Example<a class="headerlink" href="#id303" title="Link to this 
heading">¶</a></h4>
 <div class="highlight-sql notranslate"><div 
class="highlight"><pre><span></span><span class="o">&gt;</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">&#39;foo&#39;</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">&quot;foo&quot;</span><span 
class="p">))</span><span class="w">                       </span><span 
class="o">|</span>
@@ -9102,15 +9173,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="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>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="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="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">&#39;a&#39;</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">&#39;a&#39;</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 [...]
@@ -9140,15 +9211,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="id303">
-<h4>Arguments<a class="headerlink" href="#id303" title="Link to this 
heading">¶</a></h4>
+<section id="id306">
+<h4>Arguments<a class="headerlink" href="#id306" 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="id304">
-<h4>Example<a class="headerlink" href="#id304" title="Link to this 
heading">¶</a></h4>
+<section id="id307">
+<h4>Example<a class="headerlink" href="#id307" title="Link to this 
heading">¶</a></h4>
 <div class="highlight-sql notranslate"><div 
class="highlight"><pre><span></span><span class="o">&gt;</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">&#39;Int8&#39;</span><span 
class="p">)</span><span class="w"> </span><span class="k">as</span><span 
class="w"> </span><span class="n">a</ [...]
 <span class="w">  </span><span class="n">arrow_cast</span><span 
class="p">(</span><span class="s1">&#39;foo&#39;</span><span 
class="p">,</span><span class="w"> </span><span 
class="s1">&#39;Dictionary(Int32, Utf8)&#39;</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>
 <span class="w">  </span><span class="n">arrow_cast</span><span 
class="p">(</span><span class="s1">&#39;bar&#39;</span><span 
class="p">,</span><span class="w"> </span><span 
class="s1">&#39;LargeUtf8&#39;</span><span class="p">)</span><span class="w"> 
</span><span class="k">as</span><span class="w"> </span><span 
class="k">c</span><span class="p">,</span>
@@ -9169,14 +9240,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="id305">
-<h4>Arguments<a class="headerlink" href="#id305" title="Link to this 
heading">¶</a></h4>
+<section id="id308">
+<h4>Arguments<a class="headerlink" href="#id308" 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="id306">
-<h4>Example<a class="headerlink" href="#id306" title="Link to this 
heading">¶</a></h4>
+<section id="id309">
+<h4>Example<a class="headerlink" href="#id309" title="Link to this 
heading">¶</a></h4>
 <div class="highlight-sql notranslate"><div 
class="highlight"><pre><span></span><span class="o">&gt;</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">&#39;foo&#39;</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">&quot;foo&quot;</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=" [...]
@@ -9196,15 +9267,15 @@ syntax such as <code class="docutils literal 
notranslate"><span class="pre">my_s
 <div class="highlight-sql notranslate"><div 
class="highlight"><pre><span></span><span class="n">get_field</span><span 
class="p">(</span><span class="n">expression1</span><span 
class="p">,</span><span class="w"> </span><span 
class="n">expression2</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>expression1</strong>: The map or struct to retrieve a field 
for.</p></li>
 <li><p><strong>expression2</strong>: The field name in the map or struct to 
retrieve data for. Must evaluate to a string.</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">&gt;</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">t</span><span 
class="w"> </span><span class="p">(</span><span class="n">idx</span><span 
class="w"> </span><span class="nb">varchar</span><span class="p">,</span><span 
class="w"> </span><span class="n">v</span><span class="w"> </span><span c [...]
 <span class="o">&gt;</span><span class="w"> </span><span 
class="k">select</span><span class="w"> </span><span 
class="n">struct</span><span class="p">(</span><span class="n">idx</span><span 
class="p">,</span><span class="w"> </span><span class="n">v</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="w"> </span><span 
class="k">as</span><span class="w"> </span><span class="k">c</span><span 
class="p">;</span>
 <span class="o">+</span><span class="c1">-------------------------+</span>
@@ -9237,8 +9308,8 @@ syntax such as <code class="docutils literal 
notranslate"><span class="pre">my_s
 <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="id309">
-<h4>Example<a class="headerlink" href="#id309" title="Link to this 
heading">¶</a></h4>
+<section id="id312">
+<h4>Example<a class="headerlink" href="#id312" title="Link to this 
heading">¶</a></h4>
 <div class="highlight-sql notranslate"><div 
class="highlight"><pre><span></span><span class="o">&gt;</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>


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscr...@datafusion.apache.org
For additional commands, e-mail: commits-h...@datafusion.apache.org