my $sth = $dbh->prepare("SELECT f.bar, f.baz FROM foo f WHERE f.???");
$sth->execute({ bar => 42});