What tool to use to build reports on given SQL queries with GUI?

Question

SQL

Share your experience on how to solve a problem of such a plan:
There is some database (PostgreSQL) and a set of queries / reports that need to be constantly done on it with different parameters. Like:

SELECT title, status, published_at
FROM articles
WHERE published_at BETWEEN <дата_начала_отчета> AND <дата_завершения_отчета>
     AND status = 'declined';

And periodically you need to run these kinds of queries and export them to Excel for analysis by other people.
Is there a tool in nature in which it was possible to give such tasks to the customers themselves to solve? We prepare, for example, a request template, mark up in it the parameters that can be changed by users and which widgets in the GUI to use to change these parameters. Further, users themselves, when they need to, can make a report on the date interval they need, a set of statuses, etc.
I would also like it to be cross-platform, safe and not as cumbersome as 1C - where all this is, but at such a price that it’s scary to live ...

Answer 1

With a GUI, you probably won't find that if you want a secure solution.
The most likely option is to take one of the common web frameworks and make a server application on the same machine as the database. Admin part - editing requests with parameters. The client part - selecting a request, entering parameters, choosing an output format (csv, xls, something else) and getting the result. Thus, the user will not get direct access to the database.