But these days obviously ten lines of python (or whatever else) calling the database do exactly the same thing, except you actually have git, debuggers, ides, etc.
Many BI departments still cling to them because they're comparing 2020s no-code tools to early 2000s programming languages.