Hello,

We have a CMS (built in Flutter), with a backend based on PHP and MySQL.Colleagues often ask IT for data exports, which takes up quite some time to write the queries and so.

Is there framework or so, that would allow use to allow the CMS users to perform SELECT queries on a read-only database?

It would have to be a very user friendly. UI, no code writing whatsoever.Like they can drag blocks with simple if statements and so.

For example in the CMS they select following "blocks" in one way or another

• All users
• If registered before 05-06-2023
• Who have more than 10 credits

This would imply a query that joins the users and payments (for the credits) tables, and only grabs the users who registered before 05-06-2023.

Anyone who implemented something like this, knows a framework or existing tools who can do this?

Kind regards