I thought you can filter only the columns you want in your sql statement.

I try $db->fetchAll('SELECT col1, col2 FROM table WHERE condition LIMIT n, m');
I got an associative array.

I guess the default fetch mode is FETCH_ASSOC.

Don't worry if you don't know what I am talking about. I only play with the Zend Framework for 3 days and haven't play with any other PHP framework. If the way I am doing is wrong please let me know.

Hopefully, I answer your question.