Why Do Experts Favor Python/RStudio Over KNIME/<insert any other visual ETL tool here> for ETL an...

I personally prefer KNIME for all my ETL and data preprocessing—it’s visual, intuitive, and gets the job done. But I’ve noticed that most experts seem to default to Python or RStudio for these tasks, even for things KNIME can handle.

Why do you think Python/RStudio is so popular among experts for ETL and transformations? Are there specific limitations in KNIME that make scripting tools a better choice for advanced use cases? For those who use both, do you still lean on Python/R for certain tasks, even if KNIME can technically do them? Any tips on when to stick with KNIME vs. switching to scripting?

I’m trying to understand if I’m missing something or if it’s just a matter of preference.

Thanks!