Add sharding, rebalancing, replication and partition tolerance to the mix... I know some nosql dbs don't support that, but horizontal scalability is the benefit

Add sharding, rebalancing, replication and partition tolerance to the mix... I know some nosql dbs don't support that, but horizontal scalability is the benefit you should expect for dropping sql