I wanted to do the simple queries:
"select userid, count(*) from roles group by userid"
"select count(*) from entries where userid=:userid"
And I found it was difficult to do through Ebean. RawSql might work, but it's not easy or elegant, and even with that, I don' think there is a way to return the result to a scalar or other non entity classes.
In these cases of doing flat non-oo type report queries, it should be possible to return the result as a List