As mentioned elsewhere, subqueries are not currently supported. A subquery is the way that seems recommended to get only the latest entry in a time series (e.g. the latest time-clock entry for all employees).
Is there an ObjectDB way to get the latest entry in a series?