This fascinating post confirms some hunches I started to have in the late 2010s when everybody was overengineering their ETL pipelines.
Worth a read, the tl;dr at the beginning of the post more or less gets it. I haven’t used DuckDB in a professional project yet, but the team seems great, and you should read everything on their technical blog.