use strict; 
use warnings;

my $str = 'A string with a "double quoted" string in it';
(my $quoted = $str) =~ s/\"/\\\"/g;

print "$str\n$quoted\n";
[download]

Prints:

A string with a "double quoted" string in it
A string with a \"double quoted\" string in it
[download]

Where's the problem?

As an example of what happens when you do that, see the latest postgresql security update: http://www.postgresql.org/docs/techdocs.48.

If it isn't, you should have been on #perl just now. {grin}

you really ought to declare that you're taking resources from parallel locations at once, so we don't waste time answering a question that has already been answered in another forum.

I disagree. Such an advisory is meaningless, useless, and a waste of time to those who inhabit only the one space or the other (e.g., nearly everyone on PerlMonks); and for you few who inhabit both spaces, the advisory would be redundant.

Besides, it's not a problem to ask in a channel/chatroom/chatterbox and (possibly later) in a persistent forum like this. Quite the contrary, as the PerlMonks site docs show.

We're building the house of the future together.

Be interesting to see if OP gets a better answer here than there. :)

---

DWIM is Perl's answer to Gödel

On IRC, we correctly identified that this was an XY problem, and that they really wanted to use placeholders on a DBI insert. Success.

-- Randal L. Schwartz, Perl hacker
Be sure to read my standard disclaimer if this is a reply.