The “SQL doesn’t scale” argument is a lazy and absurd generalization.
The real question isn’t whether SQL or NoSQL scales; it’s whether a database meets your requirements or not. If a specific feature is critical to your usecase and only one database provides it, would you choose something else? Of course not.
Every database both scales and doesn’t scale - it depends on the usecase you are building on top of it. If you are getting 100 req/sec, why bother with a sharded database? A single node instance is good enough.
Scalability is just one factor in database selection, not the only one. Always consider the core properties, needs, and requirements you need for your use case and then choose an apt database, but be ready to live with the flaws and limitations that come with it.
If someone tells you SQL doesn’t scale, ask them what they actually mean.