As many others have said here, you should just think about transactional vs analytical as well as single user in-process vs multi-user client-server when making choices.

That said, I do think duckdb has a wider range of use cases than people here might think. It can whip through fairly large datasets (I use it for ~1B row tables all the time)