https://preset.io/blog/accessing-apis-with-superset/
"Shillelagh (ʃɪˈleɪlɪ) is a Python library and CLI that allows you to query many resources (APIs, files, in memory objects) using SQL. It's both user and developer friendly, making it trivial to access resources and easy to add support for new ones"
https://github.com/betodealmeida/shillelagh