ah yes, selectcol_arrayref would do the trick. That's exactly why it was written, I bet. I had forgotten about that function

use DBI;
my $dbh = DBI->connect(...);
my $stmt = 'select id from items where foo > 42';
my @ids = @{ $dbh->selectcol_arrayref($stmt) };
[download]