VBA is the famous example, but Power Query deserves a shout out. I use it to make tables that pull their data from other tables with custom transformation logic.
Google Sheets didn't even support tables until fairly recently.
LibreOffice still doesn't have tables! Not to mention the new(ish) functions in Excel, like LET and LAMBDA.
Power Query the language is nice, I kinda like it. I've read the UI and engine works quite well in PowerBI, but I haven't used it.
The Excel engine is way too slow though. Apparently they're two entirely separate implementations, for some architectural reason, not exactly sure why.
Excel's Power Query editor on the other hand, is an affront to every god from every religion ever. Calling it an "advanced editor", while lacking even the most basic functionality, is just further proof of their heresy.
Google Sheets didn't even support tables until fairly recently.