Since most useful databases support SQL I don't understand how the syntax changes between them. mSQL, mySQL, PostGreSQL, Oracle all support SQL 92. Some of them omit commands, like leaving out rollback if they don't support transactions, but that isn't a different syntax, just a cut down command set.

Do you actually have an example of a 'syntax change' that you could show us? In your example that query will run on all the databases that I mention above.

The delayed syntax checking is annoying but nothing stops you from logging into the database from a command shell and running your queries directly to check. There are large parts of Perl that only explode when you execute them, so this is at least consistent.

Finally there is a module that does what you want, it's called Tie::DBI. It presents tables as hash variables and you can write to or read from them.

You could conceivably write a module that checks your SQL at compile time, which would be kind of convenient.

____________________
Jeremy
I didn't believe in evil until I dated it.

In reply to Re: SQL/DBI by jepri
in thread SQL/DBI by tomazos

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.