The idea would be to give non-technical people the power to get at data that is available without having to program custom GUIs.
If you are after richly formatted data then try Metabase https://www.metabase.com/
This is what I am building: https://www.jigdev.com
It’s based on ObservableHQ, and is meant to give you ui components that you’d generally use in small tools: buttons, selectboxes, inputs, tables and charts…
The code part is javascript, so you can just connect to rest apis no problem, and do some data wrangling using javascript.
The doc is non-existant, and the product is in early beta (in use at exactly 1 company).
It’s an electron app people can run on their computers. The apps generated are text files containing mostly javascript code that you can diff/audit.
Shoot me an email if you want a demo / more info.
Edit: the current version can query mysql databases as well. I could write other modules as well. Also planning to add pivot table soon.