And yes, unfortunately, you will have to take care of quoting the data yourself.

...that's half the point of my question, and being forced to use 'generate' defeats the benefit of using SQL::Abstract.

Nonetheless, thanks. I'd glossed over the generate function in the first place, and the following is sufficient for simple inserts:

my $dbh = DBI->Connect(@params); # initialized elsewhere
my $sqlgen = SQL::Abstract->new;
my %data = (a => undef, b => 1, c => q/'string and string'/);
$_ = $dbh->quote($_) for values %data;
print scalar $sqlgen->generate('insert into',\'atable',\%data);
__END__
# prints:
INSERT INTO atable SET a = NULL, b = '1', c = '\'string and string\''

[download]

(Not sure whether the way it's quoting might cause trouble with, e.g., ZIP codes, where '08540' <> 8540...)

Still interested in a broader solution.

In reply to Re^2: Concrete SQL from SQL::Abstract? by benizi
in thread Concrete SQL from SQL::Abstract? by benizi

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.