How to implement a user-friendly web-interface for performing various queries to the database?

Question

Web development

Good afternoon! Problem: how can you organize a simple and understandable interface for interacting with an existing database (groups, users in these groups, purchases by users, etc.) to obtain any data?
Problems: users are ordinary users who have no idea about select queries or any tools for working with the database, the form of the report is not defined.
Purpose: to provide a tool so that users can get the data they need. For example, the number of purchases by a user or group per week, month, some time-based metrics, etc. etc. In fact, the ability to perform select queries with ordinary filters, groupings, aggregate functions.

Answer 1

See how pivot tables are organized in excel

Answer 2

may be interested in microsoft power bi
https://powerbi.microsoft.com/ru-ru/
https://netpeak.net/ru/blog/kak-rabotat-s-microsof...

Answer 3

You need an application server that will accept requests from users outside of the API and return them as JSON/XML data suitable for further processing.
For example, https://clck.ru/E3nCQ (link to download the archive). The library is written in PHP.
Query: example.com/mysql/records/posts/1
Will return you a record from the posts table that has id1 in Json format:

{
    "id": 1
    "title": "Сэмпл пейдж",
    "content": "Текст сообщения или что-то ещё...",
    "created": "2018-05-27T20:12:56Z"
}

In addition, either can write to a table, filter data, apply complex operators, etc.
Video instruction: https://www.youtube.com/watch?v=Xcsns-K41es