SQL
Creating Lists
Lists can be created using the [`list_value(expr, ...)`](#docs:sql:functions:list::list_valueany-) function or the equivalent bracket notation `[expr, ...]`. The expressions can be constants or arbitrary expressions. To create a list from a table column, use the [`list`](#docs:sql:functions:aggregates::general-aggregate-functions) aggregate function.  
List of integers:  
```sql
SELECT [1, 2, 3];
```  
List of strings with a `NULL` value:  
```sql
SELECT ['duck', 'goose', NULL, 'heron'];
```  
List of lists with `NULL` values:  
```sql
SELECT [['duck', 'goose', 'heron'], NULL, ['frog', 'toad'], []];
```  
Create a list with the list_value function:  
```sql
SELECT list_value(1, 2, 3);
```  
Create a table with an `INTEGER` list column and a `VARCHAR` list column:  
```sql
CREATE TABLE list_table (int_list INTEGER[], varchar_list VARCHAR[]);
```