Looking for the best way to accomplish the following:

myList = hibernateSession.createQuery(
"select perf.url, avg(perf.time) from com.pg.statistics.performance.PerformanceStatistic as perf where perf.application = :appName group by perf.url"
).setParameter("appName", application).list();

(so returning url [String] and average of time [Aggregate - int] )

I can iterate over "myList" but the returns are Object[].

Current I am doing:
for ( int q = 0; q < myList.size(); q++ ) {
Object[] rets = (Object[])performanceReporting.get(q);
String url = (String)rets[0];
Float avg = (Float)rets[1];
}

But I feel there is a better way (I swear I've seen something before that struck me as better )

Thanks

You can create a DTO POJO which has a constructer matching your data thus your return set will be a List of these objects with the properties set. The query would look like ..

select new my.containerPOJO( perf.url, avg(perf.time)) from .....

See docos for more information.