> ## 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`](https://docs.e6data.com/query/sql/functions/table/explode) | Table | Expands each ARRAY element or MAP entry into a row. |
| [`explode_outer`](https://docs.e6data.com/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`](https://docs.e6data.com/query/sql/functions/table/generator) | Table | Produces the specified number of rows with zero visible columns. |
| [`inline`](https://docs.e6data.com/query/sql/functions/table/inline) | Table | Expands ARRAY\<STRUCT> elements into rows with one output column per struct field. |
| [`inline_outer`](https://docs.e6data.com/query/sql/functions/table/inline_outer) | Table | Expands ARRAY\<STRUCT> elements into rows with one output column per struct field. |
| [`json_tuple`](https://docs.e6data.com/query/sql/functions/table/json_tuple) | Table | Extracts JSON paths into generated STRING columns. |
| [`posexplode`](https://docs.e6data.com/query/sql/functions/table/posexplode) | Table | Expands each ARRAY element or MAP entry into a row. |
| [`range`](https://docs.e6data.com/query/sql/functions/table/range) | Table | Generates an exclusive-end sequence of BIGINT values. |
| [`stack`](https://docs.e6data.com/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.