Ask HN: What have you used DuckDB for?

DuckDB looks cool, but what practical things are you using it for?<p>And why it rather than Clickhouse?