Won't fetchall_arrayref give you what you want? It gives you an array reference where each element is a row and an array reference to the row data (columns). i.e. a multidimensional array with the first dimension being the row and the second being the columns. If you want it by some id look at fetchall_hashref.