Hello, i create a dynamic query by using criteria. But query has some things criteria cannot provide (like count, group by etc). Question is, is it possible to use criteria result list in a normal hibernate Query?
Something like this:

List cats = sess.createCriteria(Cat.class)
.add( Expression.like("name", "F%")
.addOrder( Order.asc("name") )
.setMaxResults(50)
.list();

Then using the results like this:

Collection counts = s.filter( cats, "select this.type, count(this) group by this.type" );

i think it'll be just fine if your session is still open.