v1.00.20

What's Changed

• Fix Flakey Tests by @hadia206 in #502
• Add support for Oracle databases & dialect in PyDough by @john-sanchez31 in #484
• Update explain to Include Singular, CROSS and User Collections by @hadia206 in #501
• Pyarrow version by @john-sanchez31 in #504

Full Changelog: v1.00.19...v1.00.20

v1.00.19

What's Changed

• Add BodoSQL support by @knassre-bodo in #490

Full Changelog: v1.00.18...v1.00.19

v1.00.18

What's Changed

• Adding support of range collection for all dialects by @john-sanchez31 in #460
• Adding optimizations to unmasking operations and mask server by @knassre-bodo in #471
• Adding tpch custom tests for all dialects by @john-sanchez31 in #461
• Fix SQL query in "why PyDough?" section by @MarcoGorelli in #474
• Skip Masked tests if its environment not set by @hadia206 in #481
• Fix logging issues by @juankx-bodo in #472
• Optimize SEMI joins to INNER joins when HAS is used on singular relationships by @hadia206 in #480
• Adding some normalization to relational expressions by @knassre-bodo in #487
• Support Python 3.13 by @hadia206 in #486
• Fix bug with HASNOT(x)==1 by @knassre-bodo in #488
• Configuration for Division By Zero Behavior by @hadia206 in #470
• CI Option to Run All Dialects with One Commit Message by @hadia206 in #492
• PyDough performance optimizations with multiple COUNT on different filters by @knassre-bodo in #473
• Dataframe Collection (User Collections) by @john-sanchez31 in #469
• Add parse_metadata_from_list to load metadata from a list by @juankx-bodo in #495

New Contributors

• @MarcoGorelli made their first contribution in #474

Full Changelog: v1.00.17...v1.00.18

v1.00.17

What's Changed

• [pre-commit.ci] pre-commit autoupdate by @pre-commit-ci[bot] in #467
• Bump qs and express in /meta_visualizer by @dependabot[bot] in #468
• Adding optimization rewrite pass to utilize server with information about masked columns by @knassre-bodo in #443

New Contributors

• @dependabot[bot] made their first contribution in #468

Full Changelog: v1.00.16...v1.00.17

v1.00.16

What's Changed

• Adding relational optimization for Join-Aggregate transpose by @knassre-bodo in #407
• Delete redundant joins by substitution equi-join keys for their mirror to render one side pruneable by @knassre-bodo in #450
• [pre-commit.ci] pre-commit autoupdate by @pre-commit-ci[bot] in #462
• Fixed infinite cycle in qualification caused by reference equality by @juankx-bodo in #463
• Add optional max_rows keyword argument to to_sql/to_df by @knassre-bodo in #464
• Ensure semantic information is all correctly stored in the metadata by @knassre-bodo in #465

Full Changelog: v1.00.15...v1.00.16

v1.00.15

What's Changed

• Adding defog Restaurants database for testing by @john-sanchez31 in #449
• Adding custom & s3 tests infrastructure by @john-sanchez31 in #457
• Call Expression Alias Patch by @john-sanchez31 in #459

Full Changelog: v1.00.14...v1.00.15

v1.00.14

What's Changed

• MySQL & Postgres image fix by @john-sanchez31 in #446
• [pre-commit.ci] pre-commit autoupdate by @pre-commit-ci[bot] in #455
• Move defog update to its own job by @hadia206 in #456
• Snowflake Integer Range (User Collections) by @hadia206 in #393

Full Changelog: v1.00.13...v1.00.14

v1.00.13

What's Changed

• Validate additional reserved words by @juankx-bodo in #444
• Adding defog Academic database for testing by @john-sanchez31 in #415
• Alias and query optimization error patch by @john-sanchez31 in #441

Full Changelog: v1.00.12...v1.00.13

v1.00.12

What's Changed

• Patch fix to how COUNT(*) calls above joins get split by @knassre-bodo in #437
• Add Reserved Words DB test pipeline for SQLite by @juankx-bodo in #428
• Adding PyDough client & Mock Server by @john-sanchez31 in #431
• Keep track of reverse-cardinality in Joins for optimizations by @knassre-bodo in #413
• Add a session keyword argument to to_sql and to_df by @knassre-bodo in #427
• [pre-commit.ci] pre-commit autoupdate by @pre-commit-ci[bot] in #440
• Add masked table column literal comperison masking rewrite by @knassre-bodo in #418
• Add extra SQL keywords to metadata validation by @juankx-bodo in #439
• FIX #438: name issues with locals() & globals() in AddRootVisitor.visit_Name() by @juankx-bodo in #442

Full Changelog: v1.00.11...v1.00.12

v1.00.11

What's Changed

• Adding defog Derm treatment database data and questions by @john-sanchez31 in #410
• SF Masked Tests by @hadia206 in #430
• Add masked table column relational unprotect rewrite by @knassre-bodo in #417
• Improve metadata error message to identify the error by @juankx-bodo in #424
• Jkx/fix test metadata for type reserved word by @juankx-bodo in #436

Full Changelog: v1.00.10...v1.00.11