array

Function

Description

Create an array with all the args.

This function accepts arbitrary arguments and creates an array by flattening the arguments.

Examples

array(a=1, b=2) -> [1, 2]

You can use this to flatten a subquery as well:

SELECT array(a1={ SELECT User FROM Artifact.Windows.System.Users() }) as Users FROM scope()

Will return a single row with Users being an array of names.