On Monday 18 February 2008, David Durham, Jr. wrote:
On Feb 18, 2008 2:19 PM, David Durham, Jr. <david.durham.jr@gmail.com> wrote:
On Feb 18, 2008 2:07 PM, Larry Garfield <larry@garfieldtech.com> wrote:
An ORM requires a query builder. A query builder alone is not an ORM. I don't think we need/want a complete database-ORM, but a query builder is very valuable to have.
I know what you're saying, but a single query builder doesn't seem to suffice. You need one for mysql, postgres .. etc.
forgot to mention that something as seemingly trivial as join tables can required different sql. Think someone brought up a point about the new version of postgres requires casts when the datatypes used to join are different.
First, there's only so far a database can customize its syntax before it doesn't count as SQL anymore. :-) Second, please have a look at the database_query_builder.inc file in the pdo directory of my sandbox. (My CVS name is crell.) It should handle any reasonably standard SQL database, and is fully overridable for a specific database type using simple class inheritance. I am working on the patch to integrate it into core, which I hope to have ready for testing by the end of the week. At that point I welcome feedback on its compatibility with other databases. -- Larry Garfield AIM: LOLG42 larry@garfieldtech.com ICQ: 6817012 "If nature has made any one thing less susceptible than all others of exclusive property, it is the action of the thinking power called an idea, which an individual may exclusively possess as long as he keeps it to himself; but the moment it is divulged, it forces itself into the possession of every one, and the receiver cannot dispossess himself of it." -- Thomas Jefferson