That post is long enough, so I won't edit it to add new things :).

I just realized, among the advantages of the ph BLOCK [HASH] version (syntax that looks like the other command BLOCK PARAMS, not having to parse the opcode, access pads or lexicals out of their scope), it also means you don't need that rule with the leading _, just use any variable that's not %_: 

my %default = (rank => "Bishop");
$dbh->xprepare(ph { "SELECT * FROM $table WHERE rank = $_{rank} AND le
+ngth(username) = 4" } %default)->execute(rank => "Prior");

[download]

I'll give it a try tomorrow, but I think that should be fairly easy to implement.

In reply to Re^6: RFC: Placeholder creation for SQL statements by Eily
in thread RFC: Placeholder creation for SQL statements by LanX

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.