while ( my $row = $sth->fetchrow_hashref ) {
    my %data;
    $data{ col1 } = 'bar';

    push @output, \%data;
}