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...
Hyperscale/Aurora are definitely not competitors and it seems odd you got that premise from the article since it argues the complete opposite.
Anyone have any first-hand experience combining transactional and analytic workloads on this vs. Aurora, or something like CockroachDB? Seems like a major advantage of CockroachDB is being able to horizontally scale writes.