Logical->Logical rules

[jurplel]

List of logical->logical rule files to port from datafusion:

• [ ] "analyzer rules" (what are these? there are 6 files)
• [ ] simplify_expressions (big)
• [ ] common_subexpr_eliminate
• [ ] decorrelate
• [ ] decorrelate_predicate_subquery
• [ ] eliminate_cross_join
  • TODO: assigned to avery
• [x] eliminate_duplicated_expr
  • PR
• [x] eliminate_filter
  • PR
• [x] eliminate_join
  • PR
• [x] eliminate_limit
  • PR
• [ ] eliminate_nested_union
• [ ] eliminate_one_union
• [ ] eliminate_outer_join
• [ ] extract_equijoin_predicate
• [ ] filter_null_join_keys
• [ ] optimize_projections
• [ ] propagate_empty_relation
• [x] push_down_filter
  • Ben is working on this
• [ ] push_down_limit
• [ ] push_down_projection
• [ ] replace_distinct_aggregate
• [ ] rewrite_disjunctive_predicate
• [ ] scalar_subquery_to_join
• [ ] simplify_expressions
• [ ] single_distinct_to_groupby
• [ ] unwrap_cast_in_comparison

Make sub-issues as needed and link them here.