+-----+------------+
| id  |  somedata  |  
+-----+------------+
|  1  |  aaaaaaaa  |  
+-----+------------+
|  2  |  bbbbbbbb  |  
+-----+------------+
|  3  |  cccccccc  |  
+-----+------------+
|  4  |  dddddddd  |  
+-----+------------+
|  5  |  eeeeeeee  |  
+-----+------------+

##</code><code>##

my $stmt = "SELECT somedata FROM table WHERE id = $ids_to_match[0]";

for my $i ( 1 .. $#ids_to_match ) {
   $stmt .= " OR id = $ids_to_match[$i]";
}

##</code><code>##

for my $i ( 0 .. $#ids_to_match ) {
   my $stmt = "SELECT somedata FROM table WHERE id = $ids_to_match[$i]";
   [execute, fetch, push into AoH]
}