@ids = @{$dbh->selectcol_arrayref('select id from table where foo > 42', { Columns => [1]})};