Steampipe demonstrates a rather impressive range of scenarios for using FDWs + SQL in place of more traditional ETL and API integrations: https://steampipe.io/
I like this when I tried it out. The AWS API plugin was neat, query resources with SQL.
However, I like to limit my toolset to three things, these days thats duckdb, julia for analysis side, and... OK two things.