Database

Actually, by default, if your expression includes parentheses, {{Zend_Db_Select}} will cast the statement appopriately. However, if it does not, or you are having problems, you can use {{Zend_Db_Expr}} to explicitly create the expression:

{code:php}
/* Build the SQL:
* SELECT p."product_id", p.cost * 1.08 AS cost_plus_tax
* FROM "products" AS p
*/
$select = $db->select()
->from(array('p' => 'products'),
array(
'product_id',
'cost_plus_tax' => new Zend_Db_Expr('p.cost * 1.08'),
));
{code}
{cloak}