> Maybe a NoSql DB that “understands” the Postgres API?

I believe there are several of these already, like Cockroach DB.