Is there a function in CodeIgniter to get all rows of the database query result as single array, rather than a resource that has to be iterated. Sometimes all rows in one array is all one needs.

Something like:

$this->db->query("MULTI-ROW QUERY")->all_rows();