I'd need a finder like this one:

SELECT OBJECT(o) FROM log AS o WHERE o.owner.name = ?1 AND (SELECT COUNT(*) FROM log WHERE o.owner.name = ?1 AND id > o.id) < 1

jboss-ql is defined as SELECT .. FROM ... and seems not to allow another SELECT statement in subquery. Does anybody know how could I solve this?