The document is quite slim on this. Is it possible to, for a parent row to retrieve child rows and ‘pack’ a column from the detail rows into a list using the LIST function?

E.g. something like

Select

P.*,

LIST(C.ID)

from PARENT P

join CHILD C on C.PARENT_ID = P.ID

to yield

P_COLUMN_VALUE 1,2,3,4

Thanks