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.