my $sth = $dbh->prepare("SELECT f.bar, f.baz FROM foo f WHERE f.???"); $sth->execute({ bar => 42}); #### { var => (value > 5) & (value <= 10) }