Pydough

What's Changed
* Added a logger and implemented in execute_df (163) by vineetg3 in https://github.com/bodo-ai/PyDough/pull/233
* Adding more information to PyDough readmes by knassre-bodo in https://github.com/bodo-ai/PyDough/pull/235
* Added support for HOUR, MINUTE, SECOND by vineetg3 in https://github.com/bodo-ai/PyDough/pull/238
* Added implementation for ** operator, POWER and SQRT function by vineetg3 in https://github.com/bodo-ai/PyDough/pull/246
* Update planner tests to store answers in a refsol file by knassre-bodo in https://github.com/bodo-ai/PyDough/pull/243
* Update column name generation in relational conversion by knassre-bodo in https://github.com/bodo-ai/PyDough/pull/244
* Add training folder to store PyDough question/code examples by knassre-bodo in https://github.com/bodo-ai/PyDough/pull/245
* Add pre-commit CI to PyDough by knassre-bodo in https://github.com/bodo-ai/PyDough/pull/252
* Changing SQL conversion to always use pretty=True by knassre-bodo in https://github.com/bodo-ai/PyDough/pull/248
* Improve compatibility for python syntax in AST rewrite by vineetg3 in https://github.com/bodo-ai/PyDough/pull/249
* Moving training folder to private repository by strangeloopcanon in https://github.com/bodo-ai/PyDough/pull/258
* Implemented DATEDIFF function by vineetg3 in https://github.com/bodo-ai/PyDough/pull/262
* Add support for uses of BACK that cause correlated references by knassre-bodo in https://github.com/bodo-ai/PyDough/pull/269
* Support DATETIME function in PyDough by knassre-bodo in https://github.com/bodo-ai/PyDough/pull/267
* Implemented remaining Python builtins by vineetg3 in https://github.com/bodo-ai/PyDough/pull/268
* Overhaul BACK and CALC to use downstreaming of aliases and add CALCULATE method by knassre-bodo in https://github.com/bodo-ai/PyDough/pull/256
* Improved Slicing to support negative indices by vineetg3 in https://github.com/bodo-ai/PyDough/pull/277
* Implement LPAD, RPAD functions by vineetg3 in https://github.com/bodo-ai/PyDough/pull/275
* Splitting up the structure of the PyDough pipeline tests by knassre-bodo in https://github.com/bodo-ai/PyDough/pull/280
* Fixing hybrid conversion bug that caused naming errors by knassre-bodo in https://github.com/bodo-ai/PyDough/pull/283

**Full Changelog**: https://github.com/bodo-ai/PyDough/compare/v1.00.00...v1.00.01

What's Changed
* Add initial setup for allow building PyDough + some directories by njriasan in https://github.com/bodo-ai/PyDough/pull/1
* Adding initial type definitions by knassre-bodo in https://github.com/bodo-ai/PyDough/pull/4
* Initialize PyDough metadata module by knassre-bodo in https://github.com/bodo-ai/PyDough/pull/6
* Set up PyDough metadata error handling utilities by knassre-bodo in https://github.com/bodo-ai/PyDough/pull/7
* Set up PyDough metadata classes by knassre-bodo in https://github.com/bodo-ai/PyDough/pull/8
* Setup Github Actions by njriasan in https://github.com/bodo-ai/PyDough/pull/9
* Fixing escape character warnings flagged by CI by knassre-bodo in https://github.com/bodo-ai/PyDough/pull/12
* Updating how inherited properties work to contend with nested compound relationships by knassre-bodo in https://github.com/bodo-ai/PyDough/pull/10
* Set up PyDough metadata parsing and testing by knassre-bodo in https://github.com/bodo-ai/PyDough/pull/2
* Add the sqlite database with TPCH data for the demo by njriasan in https://github.com/bodo-ai/PyDough/pull/11
* Reworking import heirarchy of metadata imports by knassre-bodo in https://github.com/bodo-ai/PyDough/pull/18
* Set up PyDough AST module with basic abstract classes and simple type verifiers by knassre-bodo in https://github.com/bodo-ai/PyDough/pull/13
* Set up type deducers in PyDough AST module by knassre-bodo in https://github.com/bodo-ai/PyDough/pull/14
* Set up PyDough expression operators in AST module by knassre-bodo in https://github.com/bodo-ai/PyDough/pull/16
* Adding initial AST expressions and collections by knassre-bodo in https://github.com/bodo-ai/PyDough/pull/26
* Enable connecting to SqLite by njriasan in https://github.com/bodo-ai/PyDough/pull/3
* Adding mypy to PyDough by knassre-bodo in https://github.com/bodo-ai/PyDough/pull/27
* Add PyUpgrade and import cleaning to Ruff by knassre-bodo in https://github.com/bodo-ai/PyDough/pull/28
* Define the abstract base classes for the relational step by njriasan in https://github.com/bodo-ai/PyDough/pull/31
* Add remaining PyDough colleciton nodes by knassre-bodo in https://github.com/bodo-ai/PyDough/pull/48
* Creating the unqualified PyDough module by knassre-bodo in https://github.com/bodo-ai/PyDough/pull/43
* Setting up the unqualified transform step by knassre-bodo in https://github.com/bodo-ai/PyDough/pull/45
* Add support for the Scan relational node by njriasan in https://github.com/bodo-ai/PyDough/pull/36
* Add support for the Project relational node by njriasan in https://github.com/bodo-ai/PyDough/pull/37
* Add support for the Limit relational node by njriasan in https://github.com/bodo-ai/PyDough/pull/38
* Add support for the Aggregate relational node by njriasan in https://github.com/bodo-ai/PyDough/pull/39
* Add support for the Filter relational node by njriasan in https://github.com/bodo-ai/PyDough/pull/40
* Add support for the Root relational node by njriasan in https://github.com/bodo-ai/PyDough/pull/41
* Add support for the Join relational node by njriasan in https://github.com/bodo-ai/PyDough/pull/42
* Refactoring how operands are dealt with in the UnqualifiedNode stage by knassre-bodo in https://github.com/bodo-ai/PyDough/pull/54
* Build a visitor pattern for handling Relational Trees by njriasan in https://github.com/bodo-ai/PyDough/pull/52
* Builds the Relational Expression Visitors by njriasan in https://github.com/bodo-ai/PyDough/pull/53
* Support Converting a Scan to SQLGlot by njriasan in https://github.com/bodo-ai/PyDough/pull/55
* Support for converting a projection to SQLGlot by njriasan in https://github.com/bodo-ai/PyDough/pull/56
* Adding ability to reference a child collection as a collection by knassre-bodo in https://github.com/bodo-ai/PyDough/pull/62
* Support converting functions to SQLGlot by njriasan in https://github.com/bodo-ai/PyDough/pull/57
* Support converting a filter to SQLGlot by njriasan in https://github.com/bodo-ai/PyDough/pull/58
* Support converting a Limit to SQLGlot by njriasan in https://github.com/bodo-ai/PyDough/pull/59
* Adding PyDough translations to remaining TPC-H queries by knassre-bodo in https://github.com/bodo-ai/PyDough/pull/51
* Adding transform from UnqualifiedNodes to PyDough AST by knassre-bodo in https://github.com/bodo-ai/PyDough/pull/49
* Support for converting an Aggregate to SQLGlot by njriasan in https://github.com/bodo-ai/PyDough/pull/60
* Support for converting Join to SQLGlot by njriasan in https://github.com/bodo-ai/PyDough/pull/61
* Support converting the Root to SQLGlot by njriasan in https://github.com/bodo-ai/PyDough/pull/63
* Support for Anti + Semi Join in relational by njriasan in https://github.com/bodo-ai/PyDough/pull/64
* Infrastructure for converting Relational to SQL by njriasan in https://github.com/bodo-ai/PyDough/pull/65
* Add first batch of tests for Relational to SQL Conversion + Fix Bugs by njriasan in https://github.com/bodo-ai/PyDough/pull/67
* Create relational to SQL tests for all node types but join by njriasan in https://github.com/bodo-ai/PyDough/pull/68
* Support Join to SQL by njriasan in https://github.com/bodo-ai/PyDough/pull/69
* Test TPCH Q1 conversion + fix operator precedence by njriasan in https://github.com/bodo-ai/PyDough/pull/70
* Support TPCH Q6 to SQL + add support for AND by njriasan in https://github.com/bodo-ai/PyDough/pull/71
* Move TPCH plans to a separate file by njriasan in https://github.com/bodo-ai/PyDough/pull/72
* Implement PyDough singular/plural checking semantics by knassre-bodo in https://github.com/bodo-ai/PyDough/pull/66
* Add TPCH Q3 to SQL by njriasan in https://github.com/bodo-ai/PyDough/pull/73
* Enable function calls/complex expressions in ordering by njriasan in https://github.com/bodo-ai/PyDough/pull/75
* Enable executing SQL on a database + test TPCH Q6 by njriasan in https://github.com/bodo-ai/PyDough/pull/74
* Convert the Join represent to allow multiple joins by njriasan in https://github.com/bodo-ai/PyDough/pull/79
* Add a RelationalExpressionShuttle and Remove aliases from unique columns in a join by njriasan in https://github.com/bodo-ai/PyDough/pull/80
* Remove subquery aliases if the table has all unique columns by njriasan in https://github.com/bodo-ai/PyDough/pull/81
* Enable fusing compatible limits and orderings by njriasan in https://github.com/bodo-ai/PyDough/pull/82
* Enable column pruning Relational Nodes by njriasan in https://github.com/bodo-ai/PyDough/pull/88
* Replace the execute query API return type with a Pandas DataFrame by njriasan in https://github.com/bodo-ai/PyDough/pull/83
* Fix Python version in the test matrix by njriasan in https://github.com/bodo-ai/PyDough/pull/84
* Add remaining sample TPC-H outputs by njriasan in https://github.com/bodo-ai/PyDough/pull/86
* Adds proper support for Date Literals in SQLGlot conversion by njriasan in https://github.com/bodo-ai/PyDough/pull/87
* Support Startswith, Endswith, and String Contains in SQL conversion by njriasan in https://github.com/bodo-ai/PyDough/pull/89
* Support converting ISIN to SQLGlot by njriasan in https://github.com/bodo-ai/PyDough/pull/90
* Support for IFF in SQLGlot by njriasan in https://github.com/bodo-ai/PyDough/pull/91
* Support for LIKE function in SQLGlot by njriasan in https://github.com/bodo-ai/PyDough/pull/92
* Support for Year in SQLGlot by njriasan in https://github.com/bodo-ai/PyDough/pull/93
* Begin AST->Relational conversion by knassre-bodo in https://github.com/bodo-ai/PyDough/pull/78
* Support basic scalar functions in PyDough by knassre-bodo in https://github.com/bodo-ai/PyDough/pull/94
* Support basic singular child accesses as LEFT joins in AST->Relational conversion by knassre-bodo in https://github.com/bodo-ai/PyDough/pull/95
* Support basic BACK reference expressions in AST->Relational conversion by knassre-bodo in https://github.com/bodo-ai/PyDough/pull/96
* Support basic aggregations in AST->Relational conversion by knassre-bodo in https://github.com/bodo-ai/PyDough/pull/98
* Support calling COUNT on a subcollection in AST->Relational by knassre-bodo in https://github.com/bodo-ai/PyDough/pull/100
* Support for converting WHERE to Relational by njriasan in https://github.com/bodo-ai/PyDough/pull/97
* Fix merge conflict with aggregate by njriasan in https://github.com/bodo-ai/PyDough/pull/104
* Support global calcs and global aggregations in AST->Relational conversion by knassre-bodo in https://github.com/bodo-ai/PyDough/pull/102
* Remove rust dependency by gjdorman in https://github.com/bodo-ai/PyDough/pull/103
* Reformatting AST->Relational conversion tests to use fixtures by knassre-bodo in https://github.com/bodo-ai/PyDough/pull/107
* Support for converting TopK + Order By by njriasan in https://github.com/bodo-ai/PyDough/pull/99
* Add a single step to load SQLite dialect + connection by njriasan in https://github.com/bodo-ai/PyDough/pull/105
* Support PARTITION in AST -> Relational conversion by knassre-bodo in https://github.com/bodo-ai/PyDough/pull/106
* Test AST->Relational conversion for initial batch of TPCH queries by knassre-bodo in https://github.com/bodo-ai/PyDough/pull/110
* Support stepping into a partition child in AST -> Relational conversion by knassre-bodo in https://github.com/bodo-ai/PyDough/pull/111
* Support HAS and HASNOT in PyDough by knassre-bodo in https://github.com/bodo-ai/PyDough/pull/112
* Adds support for defining a PyDough Session by njriasan in https://github.com/bodo-ai/PyDough/pull/108
* Support a PyDough module level active_session by njriasan in https://github.com/bodo-ai/PyDough/pull/109
* Various adjustments to codebase and tests to enable running TPCH queries by knassre-bodo in https://github.com/bodo-ai/PyDough/pull/116
* Enable runtime correctness testing of TPCH queries by knassre-bodo in https://github.com/bodo-ai/PyDough/pull/115
* Update the unqualified decorator to take a graph instead of path info by njriasan in https://github.com/bodo-ai/PyDough/pull/117
* Refactoring qualification and unqualified nodes by knassre-bodo in https://github.com/bodo-ai/PyDough/pull/122
* Add APIs for basic metadata exploration by knassre-bodo in https://github.com/bodo-ai/PyDough/pull/119
* Add an end-to-end API for converting unqualified nodes to SQL + executing them by njriasan in https://github.com/bodo-ai/PyDough/pull/120
* Add jupyter extensions for PyDough by njriasan in https://github.com/bodo-ai/PyDough/pull/118
* Add the first demo notebook by njriasan in https://github.com/bodo-ai/PyDough/pull/121
* Build the jupyter notebook for the demo presentation by njriasan in https://github.com/bodo-ai/PyDough/pull/123
* Change default null position for ASC to FIRST by knassre-bodo in https://github.com/bodo-ai/PyDough/pull/126
* Add notebook for metadata exploration by knassre-bodo in https://github.com/bodo-ai/PyDough/pull/125
* PyDough Operations Notebook by njriasan in https://github.com/bodo-ai/PyDough/pull/124
* Setup Github Codespaces by njriasan in https://github.com/bodo-ai/PyDough/pull/130
* Improve the file opening experience for codespaces by starting with the readme and then navigating to the demos by njriasan in https://github.com/bodo-ai/PyDough/pull/131
* Add a notebook with the TPC-H examples by njriasan in https://github.com/bodo-ai/PyDough/pull/128
* Apply PyDough Demo Feedback by njriasan in https://github.com/bodo-ai/PyDough/pull/129
* Adding details to TPCH notebook by knassre-bodo in https://github.com/bodo-ai/PyDough/pull/132
* Demo notebook suggestions by scott-routledge2 in https://github.com/bodo-ai/PyDough/pull/134
* Move the download to a cached step by njriasan in https://github.com/bodo-ai/PyDough/pull/133
* Applied some of Ehsan's feedback by njriasan in https://github.com/bodo-ai/PyDough/pull/136
* Start adding missing docstrings and readmes by knassre-bodo in https://github.com/bodo-ai/PyDough/pull/127
* Moving operators module out of the AST module by knassre-bodo in https://github.com/bodo-ai/PyDough/pull/135
* Cleanup more introduction language by njriasan in https://github.com/bodo-ai/PyDough/pull/137
* Renaming the AST nodes to QDAG by knassre-bodo in https://github.com/bodo-ai/PyDough/pull/138
* Cleanup TPC-H notebook by njriasan in https://github.com/bodo-ai/PyDough/pull/142
* Simplify language in the metadata notebook by njriasan in https://github.com/bodo-ai/PyDough/pull/144
* Fix IIF bug due to older versions of SQLite on Codespaces. by njriasan in https://github.com/bodo-ai/PyDough/pull/146
* Final basic example updates by njriasan in https://github.com/bodo-ai/PyDough/pull/147
* Fill out many of the remaining README files for each module & sub-module of PyDough by knassre-bodo in https://github.com/bodo-ai/PyDough/pull/166
* Refactor how PyDough operators are converted to SQLGlot expressions with a binding infrastructure by knassre-bodo in https://github.com/bodo-ai/PyDough/pull/165
* Tag Github Issues for Relational + SQLGlot Modules by njriasan in https://github.com/bodo-ai/PyDough/pull/176
* Add Apache 2.0 License by njriasan in https://github.com/bodo-ai/PyDough/pull/177
* Update License Copyright by njriasan in https://github.com/bodo-ai/PyDough/pull/178
* Filling out remaining README files to PyDough by knassre-bodo in https://github.com/bodo-ai/PyDough/pull/168
* Added Contributing.md by njriasan in https://github.com/bodo-ai/PyDough/pull/179
* Add UV installation to codespaces by njriasan in https://github.com/bodo-ai/PyDough/pull/180
* Move IPython Extension to submodule by njriasan in https://github.com/bodo-ai/PyDough/pull/181
* Fixing cache bug caused by bad equality checks by knassre-bodo in https://github.com/bodo-ai/PyDough/pull/184
* Implement precursor changes to implementing the BEST operator by knassre-bodo in https://github.com/bodo-ai/PyDough/pull/189
* Update the project.toml in preparation for pip package by njriasan in https://github.com/bodo-ai/PyDough/pull/185
* Add a workflow step for pip release by njriasan in https://github.com/bodo-ai/PyDough/pull/186
* Implement RANKING function by knassre-bodo in https://github.com/bodo-ai/PyDough/pull/190
* Added graphs for defog.ai schemas by knassre-bodo in https://github.com/bodo-ai/PyDough/pull/192
* Implement PERCENTILE function by knassre-bodo in https://github.com/bodo-ai/PyDough/pull/191
* Fix COUNT(*) bug when no input columns are used by knassre-bodo in https://github.com/bodo-ai/PyDough/pull/195
* Setting up empty spec/documentation files for PyDough users by knassre-bodo in https://github.com/bodo-ai/PyDough/pull/201
* Add `sort-all` pre-commit hook by knassre-bodo in https://github.com/bodo-ai/PyDough/pull/203
* Add additional functions to PyDough by knassre-bodo in https://github.com/bodo-ai/PyDough/pull/197
* Refactor our basic example notebook based on what if feedback by njriasan in https://github.com/bodo-ai/PyDough/pull/214
* Adding function list documentation by knassre-bodo in https://github.com/bodo-ai/PyDough/pull/210
* Adding PyDough metadata specification by knassre-bodo in https://github.com/bodo-ai/PyDough/pull/215
* Fix a typo in the what_if notebook by njriasan in https://github.com/bodo-ai/PyDough/pull/216
* Adding PyDough usage docs by knassre-bodo in https://github.com/bodo-ai/PyDough/pull/217
* Adding PyDough DSL documentation by knassre-bodo in https://github.com/bodo-ai/PyDough/pull/211
* Fix hybrid conversion so it does not produce unnecessary duplicate subtrees that get joined by knassre-bodo in https://github.com/bodo-ai/PyDough/pull/231


**Full Changelog**: https://github.com/bodo-ai/PyDough/commits/v1.00.00