Your original code (using the x operator instead of map) also works just fine if you move the join outside of the quotes:

my $ID = $dbh->selectall_arrayref("SELECT table FROM tags WHERE tag IN
+ " . join(', ', ('?') x @tagList));
[download]