Continuing on my open-source , Shillelagh (github.com/betodealmeida/shill) is a Python library that lets you query APIs using SQL. You can use it as a CLI, Python library, or with SQLAlchemy.

You can use it to manage Google Sheets, manipulate Pandas dataframes, fetch data from , and much more. It has a complete SQL engine based on SQLite, and you can even join across different APIs.

There are also 3rd party plugins for GraphQL and Airtable, and it's easy to write new ones.

A lot of people ask me "why SQL?", implying it's old (it is) and outdated (it's not).

is like sharks. Sharks have been around for a long time. They're older than trees and the rings of Saturn, actually! The reason they haven't changed that much in hundreds of millions of years is because they're really good at what they do.

SQL has been around for some 50 years for the same reason: it's really good at what it does.

Sign in to participate in the conversation
2¢ / 道&c

Personal Mastodon instance of Beto Dealmeida