What is the best language to learn for working with databases and data visualization?

Question

Programming languages

I work in a design company, there was a need to automate reports and collect data on projects from different directions. With the help of what technologies or in what language is it better and more optimal to build such a data processing system with subsequent visualization and output of various reports for each head of the department?
For myself, I understand that it should be a database like MySQL with a server part in PHP and visualization in JS like D3.js.
How relevant is it to use PHP now and what can be used instead?
PS The base must be expandable, with the ability to connect external data (from 1C.Accounting)

Answer 1

TSQL and some kind of MSSQL or Oracle, although with small volumes MySQL will pull. I would leave all sorting and grouping for the database. And according to ready-made data, it doesn’t matter what to work on.