I work on Apache Superset (https://github.com/apache/superset/) for a living, building an open source web application for business intelligence and data exploration/visualization. Lately I've been putting a lot of love on Shillelagh (https://github.com/betodealmeida/shillelagh), a Python library for accessing APIs via SQL.
BTW, if you want to give Superset a try you can sign up for the free tier on the amazing company where I work for: https://preset.io/