What's Changed
* Datafusion aggregate by jdye64 in https://github.com/dask-contrib/dask-sql/pull/471
* Bump DataFusion version by andygrove in https://github.com/dask-contrib/dask-sql/pull/494
* Basic DataFusion Select Functionality by jdye64 in https://github.com/dask-contrib/dask-sql/pull/489
* Allow for Cast parsing and logicalplan by jdye64 in https://github.com/dask-contrib/dask-sql/pull/498
* Minor code cleanup in row_type() by andygrove in https://github.com/dask-contrib/dask-sql/pull/504
* Bump rust version by jdye64 in https://github.com/dask-contrib/dask-sql/pull/508
* Improve code for getting column name from expression by andygrove in https://github.com/dask-contrib/dask-sql/pull/509
* Update exceptions that are thrown by jdye64 in https://github.com/dask-contrib/dask-sql/pull/507
* Add support for Expr::Sort in expr_to_field by andygrove in https://github.com/dask-contrib/dask-sql/pull/515
* Reduce crate dependencies by andygrove in https://github.com/dask-contrib/dask-sql/pull/516
* Datafusion dsql explain by ayushdg in https://github.com/dask-contrib/dask-sql/pull/511
* Port sort logic to the datafusion planner by ayushdg in https://github.com/dask-contrib/dask-sql/pull/505
* Add helper method to convert LogicalPlan to Python type by andygrove in https://github.com/dask-contrib/dask-sql/pull/522
* Support CASE WHEN and BETWEEN by jdye64 in https://github.com/dask-contrib/dask-sql/pull/502
* Upgrade to DataFusion 8.0.0 by andygrove in https://github.com/dask-contrib/dask-sql/pull/533
* Enable passing tests by jdye64 in https://github.com/dask-contrib/dask-sql/pull/539
* Datafusion crossjoin by jdye64 in https://github.com/dask-contrib/dask-sql/pull/521
* Implement TryFrom for plans by andygrove in https://github.com/dask-contrib/dask-sql/pull/543
* Support for LIMIT clause with DataFusion by jdye64 in https://github.com/dask-contrib/dask-sql/pull/529
* Support Joins using DataFusion planner/parser by jdye64 in https://github.com/dask-contrib/dask-sql/pull/512
* Datafusion is not by jdye64 in https://github.com/dask-contrib/dask-sql/pull/557
* [REVIEW] Add support for `UNION` by galipremsagar in https://github.com/dask-contrib/dask-sql/pull/542
* [REVIEW] Fix issue with duplicates in column renaming by galipremsagar in https://github.com/dask-contrib/dask-sql/pull/559
* [REVIEW] Enable `LIMIT` tests by galipremsagar in https://github.com/dask-contrib/dask-sql/pull/560
* Add CODEOWNERS file by charlesbluca in https://github.com/dask-contrib/dask-sql/pull/562
* Upgrade DataFusion version & support non-equijoin join conditions by andygrove in https://github.com/dask-contrib/dask-sql/pull/566
* [DF] Add `ayushdg` and `galipremsagar` to rust codeowners by charlesbluca in https://github.com/dask-contrib/dask-sql/pull/572
* Enable DataFusion CBO and introduce DaskSqlOptimizer by jdye64 in https://github.com/dask-contrib/dask-sql/pull/558
* Only use the specific DataFusion crates that we need by andygrove in https://github.com/dask-contrib/dask-sql/pull/568
* Fix some clippy warnings by andygrove in https://github.com/dask-contrib/dask-sql/pull/574
* Datafusion invalid projection by jdye64 in https://github.com/dask-contrib/dask-sql/pull/571
* Datafusion upstream merge by jdye64 in https://github.com/dask-contrib/dask-sql/pull/576
* Datafusion filter by jdye64 in https://github.com/dask-contrib/dask-sql/pull/581
* Table_scan column projection by ayushdg in https://github.com/dask-contrib/dask-sql/pull/578
* Expose groupby agg configs to drop_duplicates (distinct) egg by ayushdg in https://github.com/dask-contrib/dask-sql/pull/575
* Datafusion year & support for DaskSqlDialect by jdye64 in https://github.com/dask-contrib/dask-sql/pull/585
* Optimization rule to optimize out nulls for inner joins by jdye64 in https://github.com/dask-contrib/dask-sql/pull/588
* Push down null filters into TableScan by andygrove in https://github.com/dask-contrib/dask-sql/pull/595
* Datafusion IndexError - Return fields from the lhs and rhs of a join by jdye64 in https://github.com/dask-contrib/dask-sql/pull/599
* Datafusion uncomment working filter tests by jdye64 in https://github.com/dask-contrib/dask-sql/pull/601
* Search all schemas when attempting to locate index by field name by jdye64 in https://github.com/dask-contrib/dask-sql/pull/602
* Fix join condition eval when joining on 3 or more columns by ayushdg in https://github.com/dask-contrib/dask-sql/pull/603
* Add inList support by ayushdg in https://github.com/dask-contrib/dask-sql/pull/604
* Enable Datafusion user defined functions UDFs by jdye64 in https://github.com/dask-contrib/dask-sql/pull/605
* Datafusion empty relation by jdye64 in https://github.com/dask-contrib/dask-sql/pull/611
* Datafusion NOT LIKE Clause support by jdye64 in https://github.com/dask-contrib/dask-sql/pull/615
* Uncomment passing pytests by jdye64 in https://github.com/dask-contrib/dask-sql/pull/616
* Fix bug when filtering on specific scalars. by ayushdg in https://github.com/dask-contrib/dask-sql/pull/609
* Datafusion NULL & NOT NULL literals by jdye64 in https://github.com/dask-contrib/dask-sql/pull/618
* Fix the results from a subquery alias operation with optimizations enabled by ayushdg in https://github.com/dask-contrib/dask-sql/pull/613
* Initial version of contributing guide by jdye64 in https://github.com/dask-contrib/dask-sql/pull/600
* Add helper function for converting expression lists to Python by andygrove in https://github.com/dask-contrib/dask-sql/pull/631
* Plugins support multiply types by jdye64 in https://github.com/dask-contrib/dask-sql/pull/636
* Consolidate limit/offset logic in partition func by charlesbluca in https://github.com/dask-contrib/dask-sql/pull/598
* Datafusion version bump by jdye64 in https://github.com/dask-contrib/dask-sql/pull/628
* Expand getOperands support to cover all currently available Expr type… by jdye64 in https://github.com/dask-contrib/dask-sql/pull/642
* Introduce Inverse Rex Operation by jdye64 in https://github.com/dask-contrib/dask-sql/pull/643
* Remove code segment that was causing double the amount of columns to … by jdye64 in https://github.com/dask-contrib/dask-sql/pull/644
* Include Columns in Empty DataFrame by jdye64 in https://github.com/dask-contrib/dask-sql/pull/645
* Bump setuptools-rust from 1.1.1 -> 1.4.1 by jdye64 in https://github.com/dask-contrib/dask-sql/pull/646
* Merge `main` into `datafusion-sql-planner` by charlesbluca in https://github.com/dask-contrib/dask-sql/pull/654
* Port window logic to datafusion by ayushdg in https://github.com/dask-contrib/dask-sql/pull/545
* `COT` function by sarahyurick in https://github.com/dask-contrib/dask-sql/pull/657
* Math functions by sarahyurick in https://github.com/dask-contrib/dask-sql/pull/660
* Use `PyErrs` for all Python-facing methods in `dask_planner` by charlesbluca in https://github.com/dask-contrib/dask-sql/pull/662
* Invalid crossjoin in plan by jdye64 in https://github.com/dask-contrib/dask-sql/pull/653
* [DF] Add support for `CREATE TABLE | VIEW AS` statements by charlesbluca in https://github.com/dask-contrib/dask-sql/pull/656
* sync: main to datafusion-sql-planner by github-actions in https://github.com/dask-contrib/dask-sql/pull/669
* Datafusion expand scalarvalue catchall by jdye64 in https://github.com/dask-contrib/dask-sql/pull/638
* sync: main to datafusion-sql-planner by github-actions in https://github.com/dask-contrib/dask-sql/pull/670
* [DF] Add support for `DROP TABLE` statements by charlesbluca in https://github.com/dask-contrib/dask-sql/pull/658
* Remove un-necessary sqlparser dependency and duplicate Dialect defini… by jdye64 in https://github.com/dask-contrib/dask-sql/pull/671
* [DF] Resolve UDF test failures by charlesbluca in https://github.com/dask-contrib/dask-sql/pull/672
* Uncomment skipped rex pytests by ayushdg in https://github.com/dask-contrib/dask-sql/pull/661
* Merge "Bump arrow version to 6.0.0 (674)" by charlesbluca in https://github.com/dask-contrib/dask-sql/pull/677
* sync: main to datafusion-sql-planner by github-actions in https://github.com/dask-contrib/dask-sql/pull/676
* [DF] Fix most of the clippy warnings by andygrove in https://github.com/dask-contrib/dask-sql/pull/679
* [DF] use datafusion 9956f80f197550051db7debae15d5c706afc22a3 by andygrove in https://github.com/dask-contrib/dask-sql/pull/667
* sync: main to datafusion-sql-planner by github-actions in https://github.com/dask-contrib/dask-sql/pull/685
* Configure `clippy` to error on warnings by charlesbluca in https://github.com/dask-contrib/dask-sql/pull/692
* Unpin dask/distibuted post-release by charlesbluca in https://github.com/dask-contrib/dask-sql/pull/694
* sync: main to datafusion-sql-planner by github-actions in https://github.com/dask-contrib/dask-sql/pull/691
* [DF] Add optimizer rules to translate subqueries to joins by andygrove in https://github.com/dask-contrib/dask-sql/pull/680
* [DF] Upgrade DataFusion to rev `c0b4ba` by andygrove in https://github.com/dask-contrib/dask-sql/pull/689
* Add STDDEV, STDDEV_SAMP, and STDDEV_POP by ChrisJar in https://github.com/dask-contrib/dask-sql/pull/629
* Rust parsing support for CREATE MODEL statements by jdye64 in https://github.com/dask-contrib/dask-sql/pull/693
* Support for DROP MODEL parsing in Rust by jdye64 in https://github.com/dask-contrib/dask-sql/pull/695
* Support for parsing [or replace] with create [or replace] model by ayushdg in https://github.com/dask-contrib/dask-sql/pull/700
* Parsing logic for SHOW SCHEMAS by jdye64 in https://github.com/dask-contrib/dask-sql/pull/697
* Support for parsing SHOW TABLES FROM grammar by jdye64 in https://github.com/dask-contrib/dask-sql/pull/699
* Don't check order for filtered groupby test by charlesbluca in https://github.com/dask-contrib/dask-sql/pull/702
* sync: main to datafusion-sql-planner by github-actions in https://github.com/dask-contrib/dask-sql/pull/708
* Enable passing pytests by jdye64 in https://github.com/dask-contrib/dask-sql/pull/709
* Relax `test_groupby_split_every` key check by charlesbluca in https://github.com/dask-contrib/dask-sql/pull/710
* Introduce 'schema' to the DaskTable instance and modify context.fqn t… by jdye64 in https://github.com/dask-contrib/dask-sql/pull/713
* sync: main to datafusion-sql-planner by github-actions in https://github.com/dask-contrib/dask-sql/pull/711
* Use `compiler` function in nightly recipe, pin to Rust 1.62.1 by charlesbluca in https://github.com/dask-contrib/dask-sql/pull/687
* Add test queries to gpuCI checks by charlesbluca in https://github.com/dask-contrib/dask-sql/pull/650
* Support for DISTRIBUTE BY by jdye64 in https://github.com/dask-contrib/dask-sql/pull/715
* Datafusion create table with by jdye64 in https://github.com/dask-contrib/dask-sql/pull/714
* [DF] Bump DataFusion to rev 076b42 by andygrove in https://github.com/dask-contrib/dask-sql/pull/720
* [DF] Add support for `CREATE [OR REPLACE] TABLE [IF NOT EXISTS] WITH` by charlesbluca in https://github.com/dask-contrib/dask-sql/pull/718
* Stop overwriting aggregations on same column by ChrisJar in https://github.com/dask-contrib/dask-sql/pull/675
* [DF] Add `TypeCoercion` optimizer rule by andygrove in https://github.com/dask-contrib/dask-sql/pull/723
* Support for SHOW COLUMNS syntax by ayushdg in https://github.com/dask-contrib/dask-sql/pull/721
* Implment PREDICT parsing and python wiring by jdye64 in https://github.com/dask-contrib/dask-sql/pull/722
* Support all boolean operations by sarahyurick in https://github.com/dask-contrib/dask-sql/pull/719
* Resolve issue that crept in during code merge and caused build issues by jdye64 in https://github.com/dask-contrib/dask-sql/pull/724
* [DF] Add handling for overloaded UDFs by charlesbluca in https://github.com/dask-contrib/dask-sql/pull/682
* [DF] Minor quality of life updates to test_queries.py by charlesbluca in https://github.com/dask-contrib/dask-sql/pull/730
* [DF] Fix `PyExpr.index` bug where it returns `Ok(0)` instead of an `Err` if no match is found by andygrove in https://github.com/dask-contrib/dask-sql/pull/732
* [DF] Add Cargo.lock and bump DataFusion rev by andygrove in https://github.com/dask-contrib/dask-sql/pull/734
* Update gpuCI environment file, updating workflow by charlesbluca in https://github.com/dask-contrib/dask-sql/pull/731
* Bump gpuCI test environment to use python 3.9 by charlesbluca in https://github.com/dask-contrib/dask-sql/pull/736
* [DF] Implement `ANALYZE TABLE` by charlesbluca in https://github.com/dask-contrib/dask-sql/pull/733
* sync: main to datafusion-sql-planner by github-actions in https://github.com/dask-contrib/dask-sql/pull/735
* [DF] Switch out gpuCI Java dependencies for Rust by charlesbluca in https://github.com/dask-contrib/dask-sql/pull/737
* {CREATE | USE | DROP} Schema support by jdye64 in https://github.com/dask-contrib/dask-sql/pull/727
* Test function `test_aggregate_function` by sarahyurick in https://github.com/dask-contrib/dask-sql/pull/738
* Uncomment more test_model pytests by ChrisJar in https://github.com/dask-contrib/dask-sql/pull/728
* Unskip passing postgres test by jdye64 in https://github.com/dask-contrib/dask-sql/pull/739
* [DF] Publish nightlies under `dev_datafusion` label by charlesbluca in https://github.com/dask-contrib/dask-sql/pull/729
* [DF] DataFusion upgrade by andygrove in https://github.com/dask-contrib/dask-sql/pull/742
* [DF] Resolve `test_aggregations` and `test_group_by_all` by charlesbluca in https://github.com/dask-contrib/dask-sql/pull/743
* Refactor LIMIT computation to always use `head` when possible by charlesbluca in https://github.com/dask-contrib/dask-sql/pull/696
* sync: main to datafusion-sql-planner by github-actions in https://github.com/dask-contrib/dask-sql/pull/745
* Upgrade to latest DataFusion by andygrove in https://github.com/dask-contrib/dask-sql/pull/744
* Uncomment passing pytests by ayushdg in https://github.com/dask-contrib/dask-sql/pull/750
* [DF] Update DataFusion to pick up SQL support for LIKE, ILIKE, SIMILAR TO with escape char by andygrove in https://github.com/dask-contrib/dask-sql/pull/751
* Set pytest to fail on xpassing tests by charlesbluca in https://github.com/dask-contrib/dask-sql/pull/756
* Upgrade to Datafusion 12.0.0 RC1 by andygrove in https://github.com/dask-contrib/dask-sql/pull/755
* [DF] Optimize away `COUNT DISTINCT` aggregate operations - eliminate_agg_distinct by andygrove in https://github.com/dask-contrib/dask-sql/pull/748
* sync: main to datafusion-sql-planner by github-actions in https://github.com/dask-contrib/dask-sql/pull/757
* [DF] Upgrade pyo and change some signatures to use `&str` instead of `String` by andygrove in https://github.com/dask-contrib/dask-sql/pull/762
* Fix upstream failures in `test_groupby_split_out` by charlesbluca in https://github.com/dask-contrib/dask-sql/pull/763
* sync: main to datafusion-sql-planner by github-actions in https://github.com/dask-contrib/dask-sql/pull/764
* [DF] Switch back to architectured builds by charlesbluca in https://github.com/dask-contrib/dask-sql/pull/765
* [DF] Remove python constraint from nightly recipe by charlesbluca in https://github.com/dask-contrib/dask-sql/pull/766
* [DF] Generalize `CREATE | PREDICT MODEL` to accept non-native `SELECT` statements by charlesbluca in https://github.com/dask-contrib/dask-sql/pull/747
* [DF] Use Datafusion 12.0.0 by andygrove in https://github.com/dask-contrib/dask-sql/pull/767
* [DF] Use correct schema in TableProvider by andygrove in https://github.com/dask-contrib/dask-sql/pull/769
* Update docs by sarahyurick in https://github.com/dask-contrib/dask-sql/pull/768
* [DF] Add support for switching schema in DaskSqlContext by andygrove in https://github.com/dask-contrib/dask-sql/pull/770
* Add step argument to get_window_bounds for pandas>=1.5 by ayushdg in https://github.com/dask-contrib/dask-sql/pull/774
* sync: main to datafusion-sql-planner by github-actions in https://github.com/dask-contrib/dask-sql/pull/775
* c.ipython_magic fix for Jupyter Lab by sarahyurick in https://github.com/dask-contrib/dask-sql/pull/772
* [DF] Remove PyPI release workflow by charlesbluca in https://github.com/dask-contrib/dask-sql/pull/776
* Remove PyPI release workflow by charlesbluca in https://github.com/dask-contrib/dask-sql/pull/777
* sync: main to datafusion-sql-planner by github-actions in https://github.com/dask-contrib/dask-sql/pull/778
New Contributors
* andygrove made their first contribution in https://github.com/dask-contrib/dask-sql/pull/494
* galipremsagar made their first contribution in https://github.com/dask-contrib/dask-sql/pull/542
* ChrisJar made their first contribution in https://github.com/dask-contrib/dask-sql/pull/629
**Full Changelog**: https://github.com/dask-contrib/dask-sql/compare/2022.8.0...2022.9.0.rc0