Zend Framework's Zend_Db is nice - usually something like $select = $db->select(); $select->from( 'T_Shirt' ); $select->where( 'something = ?', $a );

Zend Framework's Zend_Db is nice - usually something like $select = $db->select(); $select->from( 'T_Shirt' ); $select->where( 'something = ?', $a ); And so on. You still have to write queries longhand if you're doing something more complex that a few joins, but Zend_Db is pretty handy.