There are obvious constraints on what you can do with embedded SQL to make it readable. I personally would format the lines above as

my $sql = qq{ SELECT a.somedata1,       }
        . qq{        a.somedata2,       }
        . qq{        a.somedata3,       }
        . qq{        [...]              }
        . qq{ FROM table1 a,            }
        . qq{      table2 b,            }
        . qq{      table3 c             }
        . qq{ WHERE a.somedata4 > ?     }
        ;

$sql .=   qq{   AND a.somedata5 <= ?    }
        . qq{   AND [...]               }
        if some_perl_code_condition1;

$sql .=   qq{   AND b.somedata6 >= ?    }
        . qq{   [...]                   }
        if some_perl_code_condition2;

$sql .=   qq{ ORDER BY somedata7        };

[download]

It removes a lot of the white space and all the new lines, but I'm pretty sure that my floating ; is not PBP. I'll play with field widths depending on case, but always put starting period and the closing brace at tab stops. One nice thing about this format is that mixing and matching is generally easy and safe, and changing width tends to be very fast.

In reply to Re: Perl style/best practice question: how to [better] embed SQL in code ? by kennethk
in thread Perl style/best practice question: how to [better] embed SQL in code ? by Krambambuli

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.