Those aren't Perl single-quotes; since their wrapped inside double-quotes, they're literal single-quotes. Therefore $employee_number will interpolate.

However, if the employee number were actually stored in the database as a numeric type, there could be a problem with sending it as a SQL string.

Nevertheless, as you (and everyone else) has said, placeholders are a better solution.

Impossible Robot