Chunchun Ye

Just curious, @cobyge added support for backslash escape for MySQL in https://github.com/sqlparser-rs/sqlparser-rs/pull/844. Why not for all other SQL?

> I am not sure I have the time to do that in the next week -- maybe @appletreeisyellow does 🤔 @alamb I'm happy to coordinate with our performance team...

> I don't think this needs a performance test -- I was thinking just the main test suite I was thinking performance regression 😅 Got it! I can put up...

Thank you @alamb for the updating the description

Thank you @alamb! One question for this line: > File 2: `col_b`, `col_B` (`col_b` was added later) Do you actually mean: File 2: `col_a`, `col_b` (`col_b` was added later)

Thanks for verifying. I plan to work on this issue

> I think this would only be valid for top level expressions in the `AND` clause (not any arbitrary sub expression) Do you mean something like this? For example, rewriting...

I think case expression can be wrapped around the `OR` clause as well. For example, `x = 8 OR x < 0` can be rewrite into ```sql CASE WHEN x_null_count...

For a predicate with more than one columns, we might want to have a WHEN clause for each column. For example, rewriting a predicate like `x < 5 AND x...

> It might also now be a good time to look into how we could rewrite pruning predicate to use the range analysis in [docs.rs/datafusion/latest/datafusion/physical_expr/intervals/cp_solver/index.html](https://docs.rs/datafusion/latest/datafusion/physical_expr/intervals/cp_solver/index.html) 🤔 > > That would...