my $sql = '';
if (cond) {
  $sql = $dbh->prepare(SQL_CODE);
} elsif (cond2) {
  $sql = $dbh->prepare(SQL_CODE2);
} else {
  $sql = $dbh->prepare(SQL_CODE3);
}

$sql->execute(@params);