SQL will always exist as a lingua Franca for data because its declarative nature lets anybody immediately start using a new database/data tool just knowing basic SQL. At the same time, it’s far from perfect for all use cases - it can be much easier to write certain queries imperatively than declaratively.

I can envision a future in which databases are primarily used imperatively while still supporting SQL for those who want to use it.