Isn't this basically the premise of FoundationDB? I'd argue if you know your access patterns and they're not going to change you're always going to be better off using a key/value store and appropriately designing a schema around those access patterns.