Re:SQL should be your default choice for data engineering pi...
by xupybd on Monday January 30, 2023 @03:06PM
(#34585620)
Many developers, good developers haven't worked with complex SQL queries.
So on seeing one they can sometimes think it's quicker to redo this in a language I know rather than upskill enough to understand this.
Also unfamiliarity will make SQL feel inefficient for non-SQL programmers. The experience of rewriting SQL teaches some this lesson. But others find that the familiarity of the language of the rewrite makes it seem better to them, even though it is objectively worse. An objectively worse that only becomes visible when someone needs to optimize it for performance reasons. And it is seldom the programmer who did the inefficient write who has the skills to optimize it back to what SQL did in the first place!
(Yeah, I've had to do those optimization fixes.)