BSON_BUILD_ARRAY

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;

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

SQL

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

+---------------------------------------------------------+
| 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;

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