Re: Call for an API standard for SQL statements

From: Jonathan Leffler <jleffler_at_earthlink.net>
Date: Wed, 20 Oct 2004 06:19:52 GMT
Message-ID: <csndd.2096$%h1.528_at_newsread3.news.pas.earthlink.net>


Fredrik Bertilsson wrote:

> It does not seem to exists any standard for how to define SQL
> statements in a object oriented API. Currently different products have
> completely different syntax. Until such standard exists, people can
> always argue that it safer to type SQL statements directly as strings
> in the application source code. But there are many situations there an
> application framework need to know how the statements is built up, not
> just that it is a stream of characters.

What's wrong with the SQL Standard on the subject?

ISO/IEC 9075-10:2003 SQL/Object Language Bindings?

One answer might be "it is SQLJ, for Java only". There is also the JDBC standard - and SQL/OLB mentions JDBC.

-- 
Jonathan Leffler                   #include <disclaimer.h>
Email: jleffler_at_earthlink.net, jleffler_at_us.ibm.com
Guardian of DBD::Informix v2003.04 -- http://dbi.perl.org/
Received on Wed Oct 20 2004 - 08:19:52 CEST

Original text of this message