my %default = (rank => "Bishop");
$dbh->xprepare(ph { "SELECT * FROM $table WHERE rank = $_{rank} AND length(username) = 4" } %default)->execute(rank => "Prior");