> Would you say that the main reason to use a software instead of code is to onboard non-coding business partners
That is usually a key selling point of GUI based ETL solutions. Relatively non-technical users, that know little of coding but do understand their data and what they want out of it, can put together basic (and sometimes not so basic) data flows and debug them.
