When you use DBI to pull the data, one of the ways you can pull it is in an array of hashes.

Each element in the array is a row from the database.

Each element in the hash is the column -- and the hash allows you to access it by name.

So the answer to your question on how to access it by index and column name -- is to do so. It's already in that format if you run the query that way.