If we are faced to either go ahead with sql Or nosql from scratch.
Why should we ever choose sql? because in the long term, if let’s say I reach a scale where horizontal sharding is the only way forward, then I would have an edge with nosql since they naturally support it while not a lot of good managed solutions exist for distributed sql databases.

What could be some factors affecting this decision?