I have used LibreOffice Base to spin up a quick data entry front end to Postgresql. Has some basic reporting functionality as well, and can integrate to other LIber\Office products.
Poor man's version of MS Access.
As for other tools, https://querytreeapp.com seems to have some of the species you are looking for, but have never used it.
We have a need to display some very simple reports generated from views in an rds postgres database. We need little more functionality beyond simple filtering, column hiding, sorting, grouping. Anything much beyond that would be a strike against the tool.
i'm looking for something similar to oracle application express's interactive reports (i come from an oracle background).
i took a look at what's available from amazon's aws marketplace but quickly got overwhelmed. every application i saw was overkill.
users will not be tech savvy. we have a tentative fallback plan to use excel with pages linked to views in the database but i'm looking for something a little more targeted.
does anyone have any suggestions that fit the description above?
