From my own experimentation, CockroachDB is fantastic and exactly what you just described (90%+ of the features of postgres, but transparently sharded). It is

From my own experimentation, CockroachDB is fantastic and exactly what you just described (90%+ of the features of postgres, but transparently sharded). It is somehow new and shiny and boring old tech all at the same time.