Make value generation strategies more relational

Our current value generation strategy is completely internal to each provider; there's a lot of complexity there that needs to be ported, and it's one of the big paint points when syncing up external provider to EF Core.

We should look into moving as much of this logic into relational.