How to print exact sql query in zend framework ?

In Zend Framework 1 (ZF1), you can use the Zend_Db_Select object's __toString() method to print the exact SQL query that will be executed. Here is an example:

Example of printing exact sql query in Zend framework

// $db is assumed to be a Zend_Db_Adapter instance
$select = $db->select()
    ->from('users', array('id', 'username'))
    ->where('status = ?', 'active');

echo $select->__toString();

This will output the exact SQL query that will be executed when the $select object is used.

Note: The above example is for demonstration only. Avoid echoing SQL queries in production for security reasons, as it may expose sensitive information during debugging.