[DF] Remaining DataFusion / sqlparser work for the GA release

[andygrove]

Is your feature request related to a problem? Please describe.
I really need one place to track all of the work that needs to happen in the dependencies.

sqlparser

• Add ability for dialects to override prefix, infix, and statement parsing sqlparser-rs/sqlparser-rs#581
• Add support for Postgres OVERLAY syntax sqlparser-rs/sqlparser-rs#593
• Add support for aggregate expressions with filters sqlparser-rs/sqlparser-rs#585
• Release sqlparser 0.22

DataFusion

• Add SQL planner support for Like, ILike and SimilarTo, with optional escape character apache/datafusion#3101
• Add SQL query planner support for DISTRIBUTE BY apache/datafusion#3208
• Support "IS TRUE/FALSE" syntax (redo) apache/datafusion#3235
• Implement IS UNKNOWN/IS NOT UNKNOWN operators apache/datafusion#3246
• Review / improve type coercion & validation logic by implementing as optimizer rule(s)
  • Add optimizer rule for type coercion (binary operations only) apache/datafusion#3222
  • Add type coercion for UDFs in logical plan apache/datafusion#3254
  • Change output name of CAST expressions apache/datafusion#3328
  • Introduce physical plan version of Operator enum apache/datafusion#3269
  • IS TRUE/FALSE/UNKNOWN - Introduce Expr variants for IS [NOT] TRUE / FALSE / UNKNOWN apache/datafusion#3268
  • Case when (test)
  • Integer division (test)
• Add support for TIME literal values apache/datafusion#2883
• overlay operator (parsing error) (postgresql syntax https://www.postgresql.org/docs/9.1/functions-string.html)
• datetime ops (test)
• DataFusion 12.0.0 Release apache/datafusion#3097
• Make type coercion rule more robust apache/datafusion#3390
• Precedence bug with date comparison to date plus interval apache/datafusion#3408
• Fix conflict between simplify_expression rule and CAST expressions apache/datafusion#3409

Stretch Goals (nice to have but can wait until next release)

• position (POSITION('a' IN a FROM 4)) (non standard sql syntax)

[isidentical]

@andygrove does that make sense to also include #705 (or apache/datafusion/issues/3195) in here as well?

[andygrove]

@andygrove does that make sense to also include #705 (or apache/arrow-datafusion/issues/3195) in here as well?

Yes, it does. Thanks for that. Feel free to add to the list above as there is a good chance I am not aware of all the issues, as in this case.

[andygrove]

I think we can close this now. I did move some items to a new issue - #822