my @DB_FIELDS = qw/ foo bar baz /; my $sql = 'INSERT INTO table ('; $sql .= join( ', ', @DB_FIELDS ); $sql .= ') VALUES ('; $sql .= join( ', ', map( '?', @DB_FIELDS ) ); $sql .= ')';