Move optimized revision picking logic out of the datastore

[jakedt]

Revision picking needs more request metadata than we have in the datastore API. Datastore implementations that use non-timestamp revisions (memdb, postgres) will need to made such that they can accept an arbitrary timestamp revision and map that back to a transaction ID.