bito-code-review[bot] commented on code in PR #40830:
URL: https://github.com/apache/superset/pull/40830#discussion_r3449982507


##########
superset-core/pyproject.toml:
##########
@@ -46,7 +46,7 @@ dependencies = [
     "isodate>=0.7.0",
     "pyarrow>=16.0.0",
     "pydantic>=2.8.0",
-    "sqlalchemy>=1.4.0,<2.0",
+    "sqlalchemy>=2.0.50,<3",

Review Comment:
   <!-- Bito Reply -->
   The reviewer's concern regarding the SQLAlchemy 2.0 migration is technically 
accurate, as the transition involves significant breaking changes, including 
the removal of the legacy `session.query()` API. While `session.query()` may 
still function in some contexts due to compatibility shims, relying on it 
during a major version upgrade is generally discouraged in favor of the 
`session.execute(select(...))` pattern to ensure long-term stability and 
compatibility. Addressing the dependency pinning in `pyproject.toml` is a 
necessary first step, but the reviewer's suggestion to audit and migrate the 
codebase's usage of legacy patterns remains a valid and recommended practice 
for a complete migration.



-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]


---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to