# could be any number of artists
my @vals =("Artist1", "Artist2")
# And now I build the SQL statement with placeholders based on values
my $sql = 'SELECT * FROM Songs WHERE Songs.Artist IN (' .join (", ", map {"?"} @vals) .')';