$query->add_join($table, $alias, $condition); $query->add_fields(array('field1', 'field2' => 'fieldalias')); $query->add_condition($operator, $condition); ...