Re: Call for an API standard for SQL statements
Date: 20 Oct 2004 22:06:58 -0700
Message-ID: <31f7e57d.0410202106.3112dcd6_at_posting.google.com>
"Marshall Spight" <mspight_at_dnai.com> wrote:
> The problem with this idea is that the object model would
I am using an (non-standardized) object model now for making queries
and I don't agree that it is more cumbersome than writing SQL
statements as string. It is about the same amount of lines of code and
if you are using a flexible script language like python the code can
be rather nice and clean. I think it is more about what you are used
> be more cumbersome than the SQL strings, even in a language
> that isn't great at string handling. I've tried this several times;
> I now believe it is not a good idea.
But the main purpose for having an object model is not to make the query building more compact. The purpose is the let the database framework have knowledge about how the query is constructed, which makes a lot of extra features in the framework possible.
Fredrik Bertilsson
http://butler.sourceforge.net
Received on Thu Oct 21 2004 - 07:06:58 CEST