# BSON\_BUILD\_ARRAY

Creates a BSON array from the input values.

## Syntax

```
BSON_BUILD_ARRAY([value_1, value_2, ..., value_n])
```

## Arguments

`<value_n>`: A valid BSON value or an expression that evaluates to a valid BSON value.

## Return Type

A BSON array.

## Remarks

* If the input is SQL `NULL`, it is considered equivalent to BSON `NULL` and appended to the array.

## Examples

**Note**: The following examples explicitly cast string to BSON for clarity. Similarly, the output is cast to JSON.

```sql
SELECT BSON_BUILD_ARRAY():>JSON AS Result;

```

```output

+--------+
| Result |
+--------+
| []     |
+--------+
```

```sql
SELECT BSON_BUILD_ARRAY(1:>BSON, 'true':>BSON,'null':>BSON, '{"$date":"2023-03-14T09:48:10.720Z"}':>BSON, NULL):>JSON AS Result;

```

```output

+---------------------------------------------------------+
| Result                                                  |
+---------------------------------------------------------+
| [1,true,null,{"$date":"2023-03-14T09:48:10.720Z"},null] |
+---------------------------------------------------------+
```

Note that in the previous example the SQL `NULL` is also inserted as BSON `NULL` in the array.

```sql
SELECT BSON_BUILD_ARRAY('{"$undefined":true}':>BSON,'{"$oid":"641044fd4542e7dc53758df9"}':>BSON, 'true':>BSON, '{"$date":"2023-03-14T09:48:10.720Z"}':>BSON, 'null':>BSON):>JSON AS Result;

```

```output

+----------------------------------------------------------------------------------------------------------+
| Result                                                                                                   |
+----------------------------------------------------------------------------------------------------------+
| [{"$undefined":true},{"$oid":"641044fd4542e7dc53758df9"},true,{"$date":"2023-03-14T09:48:10.720Z"},null] |
+----------------------------------------------------------------------------------------------------------+
```

***

Modified at: May 8, 2024

Source: [/db/v9.1/reference/sql-reference/bson-functions/bson-build-array/](https://docs.singlestore.com/db/v9.1/reference/sql-reference/bson-functions/bson-build-array/)

(An index of the documentation is available at /llms.txt)