SQL is pretty darn perfect for its purpose. As long as databases exist, SQL will exist. It is also super easy and intuitive to learn- I taught myself and it has been my bread and butter for the ~17 years since .
I can envision a future in which databases are primarily used imperatively while still supporting SQL for those who want to use it.