Creating array of values from multiple rows

Hi all,

Suppose you have 2 tables that relate as 1:n. When joining the tables in a query without filtering, the result will be n rows. 

My requirement is to have just one row returned, with the values of the n-table shown as an array. In SQL Server you could use a query like

SELECT 

    p.PK_ONETEST,

    p.Name,

    p.Description,

    (SELECT 

        c.Name

     FROM ODS.NTEST c

     WHERE c.FK_ONETEST = p.PK_ONETEST

     FOR JSON PATH) AS Children

FROM ODS.ONETEST p

;

resulting in 

My question is if we can also achieve this in one or more steps in One Desktop.

Kind regards,

Albert