SQL is still a valid choice and in some cases preferable over noSQL and the other way a around.
The point is, it's a tool, if you need a screwdriver use a screwdriver, and if you need a hammer use a hammer.
And there are a lot of use cases where it doesn't matter at all so it boils down to taste and experience.
You can scale with both for example
very often just certain parts get moved to schemaless databases.
I even know a company that switched from Redis back to Memcached because the reads are much faster. It's all about what you need in the end.