This is a topic that I talked a lot with Daniel a few years ago. When we saw many requests that in fact are naturally part of the client layer (business logic) and not the database.
It’s nice to have different features in DB. But the real duty of a database is to store things And fight to keep fast for query data. Since in the application we only have ephemeral states and sessions. “cookies, Redux, state, Mobx”. DBs were created to store long-term information and not for data mining. For that we have specific tools. For example Python, PowerBI or OpenRefine and others.
I think it’s cool to have fancy features, but don’t expect a DB to be responsible for everything. Otherwise, nobody needs to invent anything, since DB does everything. Right?
This part of data analysis, usually someone uses some lib in python, R or something similar. But I agree on improoving DQL and I will fight for the DQL to have cool features. That make people addicted to DQL and never want anything else 
PS. If you want to do many things at once. You will inevitably be bad at all of them.