As far as I am aware, if you use bind-parameters (which are unquoted question-marks), and provide a corresponding number of replacement values, say, to execute, then the SQL handler never cares about what those replacement values contain.   (The SQL statement parser never sees the values.)

The following comment in the DBI documentation for the quote method also gives me pause:

The quote() method should not be used with "Placeholders and Bind Values".

In short, I suspect that the code “that has been giving you a problem for years” isn’t correct.   Could you please give a short, specific example of what you are doing now?   (The SQL string, the prepare and the execute.)