Results 8 comments of lokax

let me try 🦅

I want to support column pruning for some operators. Can I have a try 😇 😇

> It's here! #661 Thanks. 😇😇

@Tishj It seems that TryCast::Operation doesn't handle scale like TryCastFromDecimal/StringCastFromDecimal does, which results in ```cpp query("SELECT 0.5::DECIMAL(18, 1)"); duckdb_value_double(...) // get value 5 ```

It seems that `deprecated_duckdb_translate_column()` always writes DECIMAL into an array of hugeint. Maybe there is no need to distinguish the internal type? This is just my opinion, not necessarily correct.

Thanks for the review. I have no passion to finish it. And the optimizer has been refactored. So I closed this pr.

Bounds checking does not allow the compiler to auto-vectorize. Try and test res = vec::from_iter(a.iter().zip(b.iter()).map())