Skip to content

feat!: Support SQLAlchemy 2.0, backwards compatibility for 1.4.16+ #920

New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom
Closed
wants to merge 47 commits into from
Closed

feat!: Support SQLAlchemy 2.0, backwards compatibility for 1.4.16+ #920

wants to merge 47 commits into from

Conversation

sharoonthomas
Copy link
Contributor

@sharoonthomas sharoonthomas commented Oct 31, 2023 •
edited by kiraksi
Loading

This patch makes this library backward incompatible for versions of SQLAlchemy < 1.4.16.

Fixes #510

@sharoonthomas sharoonthomas requested review from a team as code owners October 31, 2023 18:45
@product-auto-label product-auto-label bot added size: l Pull request size is large. api: bigquery Issues related to the googleapis/python-bigquery-sqlalchemy API. labels Oct 31, 2023
@sharoonthomas sharoonthomas mentioned this pull request Oct 31, 2023
Closed
@nayaknishant nayaknishant requested review from nayaknishant and removed request for GaoleMeng October 31, 2023 18:46
@Linchin Linchin added the kokoro:force-run Add this label to force Kokoro to re-run the tests. label Nov 1, 2023
@yoshi-kokoro yoshi-kokoro removed the kokoro:force-run Add this label to force Kokoro to re-run the tests. label Nov 1, 2023
@nayaknishant nayaknishant added kokoro:force-run Add this label to force Kokoro to re-run the tests. owlbot:run Add this label to trigger the Owlbot post processor. labels Nov 2, 2023
@gcf-owl-bot gcf-owl-bot bot removed the owlbot:run Add this label to trigger the Owlbot post processor. label Nov 2, 2023
@yoshi-kokoro yoshi-kokoro removed the kokoro:force-run Add this label to force Kokoro to re-run the tests. label Nov 2, 2023
@nayaknishant nayaknishant added the kokoro:force-run Add this label to force Kokoro to re-run the tests. label Nov 6, 2023
@yoshi-kokoro yoshi-kokoro removed the kokoro:force-run Add this label to force Kokoro to re-run the tests. label Nov 6, 2023
@nayaknishant nayaknishant added the kokoro:force-run Add this label to force Kokoro to re-run the tests. label Nov 7, 2023
@yoshi-kokoro yoshi-kokoro removed the kokoro:force-run Add this label to force Kokoro to re-run the tests. label Nov 7, 2023
@sharoonthomas
feat!: Support SQLAlchemy 2.0, drop support for 1.x
ffc491f 
This patch makes this library backward incompatible for
versions of SQLAlchemy < 2.0.

Fixes googleapis#510
@sharoonthomas
Copy link
Contributor Author

Included another bugfix related to unnest which seems to be not looking at arg.type.impl

@nayaknishant nayaknishant added the kokoro:force-run Add this label to force Kokoro to re-run the tests. label Nov 7, 2023
@yoshi-kokoro yoshi-kokoro removed the kokoro:force-run Add this label to force Kokoro to re-run the tests. label Nov 7, 2023
@chalmerlowe chalmerlowe added owlbot:run Add this label to trigger the Owlbot post processor. and removed owlbot:ignore instruct owl-bot to ignore a PR labels Jan 16, 2024
@gcf-owl-bot gcf-owl-bot bot removed the owlbot:run Add this label to trigger the Owlbot post processor. label Jan 16, 2024
@tswast tswast added the kokoro:run Add this label to force Kokoro to re-run the tests. label Jan 16, 2024
@yoshi-kokoro yoshi-kokoro removed the kokoro:run Add this label to force Kokoro to re-run the tests. label Jan 16, 2024
@kiraksi kiraksi added kokoro:run Add this label to force Kokoro to re-run the tests. owlbot:run Add this label to trigger the Owlbot post processor. labels Jan 17, 2024
@gcf-owl-bot gcf-owl-bot bot removed the owlbot:run Add this label to trigger the Owlbot post processor. label Jan 17, 2024
@yoshi-kokoro yoshi-kokoro removed the kokoro:run Add this label to force Kokoro to re-run the tests. label Jan 17, 2024
@kiraksi kiraksi added kokoro:force-run Add this label to force Kokoro to re-run the tests. owlbot:run Add this label to trigger the Owlbot post processor. labels Jan 17, 2024
@gcf-owl-bot gcf-owl-bot bot removed the owlbot:run Add this label to trigger the Owlbot post processor. label Jan 17, 2024
@yoshi-kokoro yoshi-kokoro removed the kokoro:force-run Add this label to force Kokoro to re-run the tests. label Jan 17, 2024
@kiraksi kiraksi added kokoro:force-run Add this label to force Kokoro to re-run the tests. owlbot:run Add this label to trigger the Owlbot post processor. labels Jan 17, 2024
@gcf-owl-bot gcf-owl-bot bot removed the owlbot:run Add this label to trigger the Owlbot post processor. label Jan 17, 2024
@yoshi-kokoro yoshi-kokoro removed the kokoro:force-run Add this label to force Kokoro to re-run the tests. label Jan 17, 2024
@chalmerlowe
Copy link
Collaborator

A pre-release version of python-bigquery-sqlalchemy has been released with coverage for 1.4 AND 2.0. based in part on the code in this PR.

Gonna close this PR as complete.

As feedback on the pre-release rolls in, we will update the above branch and ultimately merge with main when ready.

@kiraksi kiraksi reopened this Jan 25, 2024
@kiraksi
Copy link
Contributor

kiraksi commented Jan 25, 2024 •
edited by chalmerlowe
Loading

This PR is now a part of prerelease v1.11.0.dev0. Closing this again

@kiraksi kiraksi closed this Jan 25, 2024
@sharoonthomas
Copy link
Contributor Author

Thanks @kiraksi

Really appreciate your team's commitment to maintaining the SQLA dialect.

@tswast tswast mentioned this pull request Apr 3, 2024
Merged
@release-please release-please bot mentioned this pull request Apr 3, 2024
Merged
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Reviewers

@chalmerlowe chalmerlowe chalmerlowe requested changes

@nayaknishant nayaknishant nayaknishant left review comments

@kiraksi kiraksi kiraksi left review comments

@tswast tswast tswast approved these changes

@rutpoule rutpoule rutpoule approved these changes

Assignees

@kiraksi kiraksi

Labels
api: bigquery Issues related to the googleapis/python-bigquery-sqlalchemy API. size: xl Pull request size is extra large.
Projects
None yet
Milestone
No milestone
Development

Successfully merging this pull request may close these issues.

SQLAlchemy 2.0 support
9 participants
@sharoonthomas @nayaknishant @chalmerlowe @yoavrosen @kiraksi @tswast @rutpoule @Linchin @yoshi-kokoro