dependabot[bot] opened a new pull request, #40183: URL: https://github.com/apache/superset/pull/40183
Bumps [sqlalchemy](https://github.com/sqlalchemy/sqlalchemy) from 1.4.54 to 2.0.49. <details> <summary>Release notes</summary> <p><em>Sourced from <a href="https://github.com/sqlalchemy/sqlalchemy/releases";>sqlalchemy's releases</a>.</em></p> <blockquote> <h1>2.0.49</h1> <p>Released: April 3, 2026</p> <h2>orm</h2> <ul> <li> <p><strong>[orm] [bug]</strong> Fixed issue where <code>_orm.Session.get()</code> would bypass the identity map and emit unnecessary SQL when <code>with_for_update=False</code> was passed, rather than treating it equivalently to the default of <code>None</code>. Pull request courtesy of Joshua Swanson.</p> <p>References: <a href="https://www.sqlalchemy.org/trac/ticket/13176";>#13176</a></p> </li> <li> <p><strong>[orm] [bug]</strong> Fixed issue where chained <code>_orm.joinedload()</code> options would not be applied correctly when the final relationship in the chain is declared on a base mapper and accessed through a subclass mapper in a <code>_orm.with_polymorphic()</code> query. The path registry now correctly computes the natural path when a property declared on a base class is accessed through a path containing a subclass mapper, ensuring the loader option can be located during query compilation.</p> <p>References: <a href="https://www.sqlalchemy.org/trac/ticket/13193";>#13193</a></p> </li> <li> <p><strong>[orm] [bug] [inheritance]</strong> Fixed issue where using <code>_orm.Load.options()</code> to apply a chained loader option such as <code>_orm.joinedload()</code> or <code>_orm.selectinload()</code> with <code>_orm.PropComparator.of_type()</code> for a polymorphic relationship would not generate the necessary clauses for the polymorphic subclasses. The polymorphic loading strategy is now correctly propagated when using a call such as <code>joinedload(A.b).options(joinedload(B.c.of_type(poly)))</code> to match the behavior of direct chaining e.g. <code>joinedload(A.b).joinedload(B.c.of_type(poly))</code>.</p> <p>References: <a href="https://www.sqlalchemy.org/trac/ticket/13202";>#13202</a></p> </li> <li> <p><strong>[orm] [bug] [inheritance]</strong> Fixed issue where using chained loader options such as <code>_orm.selectinload()</code> after <code>_orm.joinedload()</code> with <code>_orm.PropComparator.of_type()</code> for a polymorphic relationship would not properly apply the chained loader option. The loader option is now correctly applied when using a call such as <code>joinedload(A.b.of_type(poly)).selectinload(poly.SubClass.c)</code> to eagerly load related objects.</p> <p>References: <a href="https://www.sqlalchemy.org/trac/ticket/13209";>#13209</a></p> </li> </ul> <h2>typing</h2> <ul> <li><strong>[typing] [bug]</strong> Fixed a typing issue where the typed members of :data:<code>.func</code> would return the appropriate class of the same name, however this creates an issue for</li> </ul> <!-- raw HTML omitted --> </blockquote> <p>... (truncated)</p> </details> <details> <summary>Commits</summary> <ul> <li>See full diff in <a href="https://github.com/sqlalchemy/sqlalchemy/commits";>compare view</a></li> </ul> </details> <br /> [](https://docs.github.com/en/github/managing-security-vulnerabilities/about-dependabot-security-updates#about-compatibility-scores) Dependabot will resolve any conflicts with this PR as long as you don't alter it yourself. You can also trigger a rebase manually by commenting `@dependabot rebase`. [//]: # (dependabot-automerge-start) [//]: # (dependabot-automerge-end) --- <details> <summary>Dependabot commands and options</summary> <br /> You can trigger Dependabot actions by commenting on this PR: - `@dependabot rebase` will rebase this PR - `@dependabot recreate` will recreate this PR, overwriting any edits that have been made to it - `@dependabot show <dependency name> ignore conditions` will show all of the ignore conditions of the specified dependency - `@dependabot ignore this major version` will close this PR and stop Dependabot creating any more for this major version (unless you reopen the PR or upgrade to it yourself) - `@dependabot ignore this minor version` will close this PR and stop Dependabot creating any more for this minor version (unless you reopen the PR or upgrade to it yourself) - `@dependabot ignore this dependency` will close this PR and stop Dependabot creating any more for this dependency (unless you reopen the PR or upgrade to it yourself) </details> -- 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]
