As a part of his WinPHP Challenge project Rob Allen has come up with a method to combing the Zend_Db_Table component of the Zend Framework with the SuccessSQL tool to extract the table information directly from the database.

Zend_Db_Table provides all this information directly which is quite useful, however the intended use-case for Zend_Db_Table is that you extend Zend_Db_Table_Abstract for each table that you want to interact with. Obviously, SuccesSQL doesn't know in advance the names of the tables, so I created a stub class that allowed me to instantiate a Zend_Db_Table dynamically.

A few code snippets later and he has a working example showing a var_dump of the object's output - complete with full data for the two columns - ID and artist.