in reply to Using placeholders in selectall_arrayref
You are so close. The line you have provided looks like:
my $employees_loh = $dbh->selectall_arrayref($query2, {Slice => {}});
To add the parameter the selectall line needs to read:
my $employees_loh = $dbh->selectall_arrayref($query2, {Slice => {}}, $employer);