I've been doing some reading of Domas Mituzas (the inhouse MySQL dev. for MediaWiki) and came across this interesting blog post: http://dammit.lt/2006/03/05/db-abstract ... mediawiki/ essentially describing the differences between Zend and MediaWiki's db abstraction layers.
However, what struck me was the idea that SQL was structured rather than just text, so you ought to be able to generate it with a query builder, like...
Code: Select all
$select->where('field = ?',$value);It seems to be a quite interesting approach (I've never heard of it before, but it makes sense). Do you use it? And also, do you think it would be a good idea to augment the database wrapper in a toolkit to support query building (is it a feature or a core item)?