> ## Documentation Index
> Fetch the complete documentation index at: https://docs.e6data.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Table functions

> Functions that return rows instead of a single value, such as exploding arrays or generating ranges.

Functions that return rows instead of a single value, such as exploding arrays or generating ranges.

| Function | Type | What it does |
| - | - | - |
| [`explode`](/query/sql/functions/table/explode) | Table | Expands each ARRAY element or MAP entry into a row. |
| [`explode_outer`](/query/sql/functions/table/explode_outer) | Table | Expands each ARRAY element or MAP entry into a row, preserving empty/NULL inputs as one NULL row. |
| [`generator`](/query/sql/functions/table/generator) | Table | Produces the specified number of rows with zero visible columns. |
| [`inline`](/query/sql/functions/table/inline) | Table | Expands ARRAY\<STRUCT> elements into rows with one output column per struct field. |
| [`inline_outer`](/query/sql/functions/table/inline_outer) | Table | Expands ARRAY\<STRUCT> elements into rows with one output column per struct field. |
| [`json_tuple`](/query/sql/functions/table/json_tuple) | Table | Extracts JSON paths into generated STRING columns. |
| [`posexplode`](/query/sql/functions/table/posexplode) | Table | Expands each ARRAY element or MAP entry into a row. |
| [`range`](/query/sql/functions/table/range) | Table | Generates an exclusive-end sequence of BIGINT values. |
| [`stack`](/query/sql/functions/table/stack) | Table | Splits row-major values into a fixed number of generated rows. |


This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.