For very simple queries (retrieving arrays to populate select lists) I write out SQL strings. For more complex queries, and for those that need to be built dynamically or used across controllers, I use model classes that extend Zend_Db_Table_Abstract.