How do you guys design a typical 'good' model?
I see alot of examples of models that extends Zend_Db_Table or Zend_Db_Select.
I don't like the way working with table relationship with Zend_Db_Table.
I just want to write complex SQL statements, prepare them and execute them. What is the way to do that?

Mysqli prepared statements be of any use?

nice tutorial:
ext/mysqli: Part I - Overview and Prepared Statements

__________________
mysql> SELECT * FROM `users` WHERE `users`.`clue` > 0;
Empty set (0.00 sec)

I already understands preparing, I need to know how to implement this using Zend Framework.

Sorry, i misunderstood. But your question led me to believe that you wanted an alternative to the zend framework:

__________________
mysql> SELECT * FROM `users` WHERE `users`.`clue` > 0;
Empty set (0.00 sec)

I'm looking for good examples of models querying the database, with static functions.