Fabrik is probably the most powerful (if not the only) open source web application builder that allows us build Lists and Forms + different Visualizations using "as many data joins and exactly those data joins that I need".
Data joins are offered in different ways and could be set up