I am also interested in implementation of this feature. Generaly speaking making possible to query not only by revisions but also by time would be a very interesting feature.
Maybe it could be added for all vendors and when Hibernate is using Oracle database version which supports flashbacks then uses it?