SQL is here to stay, for enterprise complex application is a must. If you know that your app will not exceed few thousand users at a time (like an ERP) it is better to use SQL.
SQL does not scale easily, you will have huge payments and at some point you will need to build very complex distributed databases architectures if you start to have millions users on-line.
I do have projects that uses SQL (PostgreSQL), all are for enterprises, I do not think to change that into the future. Using modern RESTful API's SQL can be used virtually anywhere.