Ask HN: Is anyone use Cloud based SQL databases anymore?

Almost all of greenfield projects that I see in my team are using nosql. The senior developers and architects I interact with often making a case that the simplicity of no schema and the lack of complexity in designing a relation schema. Even when the tradeoff are called out (lack of complex joins and more cost).

So I am curious if that is the slowly becoming the industry norm or now?

Is anyone using nosql databases in the cloud any more ? If yes then what for what use case ?