Adrian Rossouw wrote:
On 10 Jun 2006, at 8:38 PM, Karoly Negyesi wrote:
Well, markus has a nice library for phpBB that uses something very close to mysql DDL AND is cross DB.
Yup. and I fully support a patch that uses it.
The only reason I recommended we do db_* functions, is because it has fewer moving parts, and is pretty much like what we already have.
I didn't want to see us write an sql parser, but if one already exists (which coincidentally happens to be written by a trusted drupal contributor) we should definitely use it.
Just for the record: I don't really like parsers. I'd prefer we write our SQL as structured arrays. It will still be readable as SQL and it is easier to manipulate, ie insert additional conditions or remove them. Cheers, Gerhard