Sebastian Redl wrote:
Rene Rivera wrote:
Thorsten Ottosen wrote:
Portability is another reason to go away from sql queries as strings.
Since SQL is a standard language I don't see how using it in strings makes it non-portable. Could you explain you reasoning?
Different DBs actually use different "dialects" of SQL. There is a subset of SQL that can be used pretty portably, but also a large amount of stuff that can't.
[snip] Sure... But we could use that same argument to propose that we write C++ programs by writing an abstraction on top of C++ compilers in Python so that we can remove the incompatibilities in the various C++ implementations. Having had the displeasure of dealing with PL/SQL there is one serious drawback to the language embedded approach, it ties ones to the capabilities of the abstraction. -- -- Grafik - Don't Assume Anything -- Redshift Software, Inc. - http://redshift-software.com -- rrivera/acm.org - grafik/redshift-software.com -- 102708583/icq - grafikrobot/aim - grafikrobot/yahoo