How to select into array?

[DJDaveMark]

I need to use the following style of query:

select
    array(select col1 from table where id = ?) as col1,
    array(select col2 from table where id = ?) as col2;

Which produces something like:

col1	col2
{1,2,3}	{4,5,6}

How can I turn it into a squel query while still using squel.toParam()?

[DJDaveMark]

Here's a workaround I hacked together:

var query = squel.select()
    .field(
        Squel.select()
            .field('col1')
            .from('table')
            .where('id = ?', id),
        'col1' // subquery alias
    )
    .from('DELETE_FROM')
    .toParam();

// SELECT (SELECT col1 FROM table WHERE (parent_id = 1)) AS col1 FROM DELETE_FROM

query.text = modifiedQuery.text.split('(SELECT').join('ARRAY(SELECT'); // replace all
query.text = modifiedQuery.text.replace(' FROM DELETE_FROM', '');

// SELECT ARRAY(SELECT col1 FROM table WHERE (id = 1)) AS col1

Things I didn't expect:

• If I didn't use .from() then the field parts weren't added.
• By using subqueries, the arguments are no longer parameterized via query.values