I've always been impressed by the architecture of the Hyperscale service tier of MSSQL in Azure. It is arguably a competitor in this area.
https://learn.microsoft.com/en-us/azure/azure-sql/database/h...
https://learn.microsoft.com/en-us/azure/azure-sql/database/h...