I have, and haven’t come away impressed. I have in fact done this multiple times. perhaps this doesn’t work with actual complex analytics and stuff? DuckDB doesn’t even do proper SIMD for example.
To be clear I have used Duckdb in some serverless ideas and it has worked well, but nothing has bet hyper optimized engines like snowflake and redshift.
What I'm talking about is snowflake vs a $50 EC2 instance running DuckDB reading data from S3.
Try it out sometime — the results might surprise you