Honestly, projects like AppSmith and Baserow are pretty good at this. Google AppSheet is by far the best implementation of this style of low-to-no-code app builders, but comes with the obvious caveat of being a Google product.
If someone managed to make an open-source solution as slick as Google’s, I’d be right on it. As it stands, all the competition that I’ve found requires a decent existing knowledge of SQL queries to run the widgets themselves.









I just did some digging and Grist actually seems to do most of what I need it to. There may be hope yet! It’s still not quite as slick as AppSheet, but may be a step in the right direction.