Dashboards and other UI are used because most people don't know how to do sql so yeah once you start using LLMs as the UI layer things start to happen.

Here is an example of an agent that is communicating with an SQL database using simple language.

https://www.youtube.com/watch?v=jh9gJoDqFoU&t=2s