dependabot[bot] opened a new pull request, #46073: URL: https://github.com/apache/superset/pull/46073
Updates the requirements on [sqlalchemy-d1](https://github.com/sqlalchemy-cf-d1/sqlalchemy-d1) to permit the latest version. <details> <summary>Release notes</summary> <p><em>Sourced from <a href="https://github.com/sqlalchemy-cf-d1/sqlalchemy-d1/releases">sqlalchemy-d1's releases</a>.</em></p> <blockquote> <h2>sqlalchemy-d1 0.2.2</h2> <h3>Changed</h3> <ul> <li>Requires <code>sqlalchemy-cloudflare-d1</code> 0.4.1 or newer. It was 0.3.11.</li> <li>Reworked the README layout, with badges, a compatibility table and a contributing section. The content is unchanged.</li> <li>"Known limits" in the README no longer lists the two limits fixed below.</li> </ul> <h3>Fixed</h3> <ul> <li>Columns with the same name each get their own value. They all got the value of the last one before. Fixed in <code>sqlalchemy-cloudflare-d1</code> 0.4.1 (<a href="https://redirect.github.com/CollierKing/sqlalchemy-cloudflare-d1/pull/34">#34</a>).</li> <li>Statements that start with a comment, <code>EXPLAIN</code> or <code>VALUES</code> come back with column names, so SQLAlchemy returns their rows. Fixed in <code>sqlalchemy-cloudflare-d1</code> 0.4.1 (<a href="https://redirect.github.com/CollierKing/sqlalchemy-cloudflare-d1/pull/33">#33</a>).</li> </ul> <p>On PyPI: <a href="https://pypi.org/project/sqlalchemy-d1/0.2.2/">sqlalchemy-d1 0.2.2</a></p> </blockquote> </details> <details> <summary>Changelog</summary> <p><em>Sourced from <a href="https://github.com/sqlalchemy-cf-d1/sqlalchemy-d1/blob/main/CHANGELOG.md">sqlalchemy-d1's changelog</a>.</em></p> <blockquote> <h2>[0.2.2] - 2026-10-04</h2> <h3>Changed</h3> <ul> <li>Requires <code>sqlalchemy-cloudflare-d1</code> 0.4.1 or newer. It was 0.3.11.</li> <li>Reworked the README layout, with badges, a compatibility table and a contributing section. The content is unchanged.</li> <li>"Known limits" in the README no longer lists the two limits fixed below.</li> </ul> <h3>Fixed</h3> <ul> <li>Columns with the same name each get their own value. They all got the value of the last one before. Fixed in <code>sqlalchemy-cloudflare-d1</code> 0.4.1 (<a href="https://redirect.github.com/CollierKing/sqlalchemy-cloudflare-d1/pull/34">#34</a>).</li> <li>Statements that start with a comment, <code>EXPLAIN</code> or <code>VALUES</code> come back with column names, so SQLAlchemy returns their rows. Fixed in <code>sqlalchemy-cloudflare-d1</code> 0.4.1 (<a href="https://redirect.github.com/CollierKing/sqlalchemy-cloudflare-d1/pull/33">#33</a>).</li> </ul> <h2>[0.2.1] - 2026-09-29</h2> <p>Docs only. No code changes.</p> <h3>Changed</h3> <ul> <li>The README says that Superset's <code>d1</code> extra installs this package alone since <a href="https://redirect.github.com/apache/superset/pull/44505">apache/superset#44505</a>.</li> <li>"Known limits" in the README lists three limits that come from <code>sqlalchemy-cloudflare-d1</code>: columns with the same name, statements that come back without column names, and date and time values written with a <code>T</code>.</li> </ul> <h2>[0.2.0] - 2026-09-21</h2> <h3>Changed</h3> <ul> <li>Rewrote <code>D1Dialect</code> as a subclass of <code>CloudflareD1Dialect</code> from <code>sqlalchemy-cloudflare-d1</code>. The <code>d1://</code> connection string and the <code>d1</code> entry point are unchanged.</li> <li>Requires <strong>SQLAlchemy 2.0</strong> (<code>>=2.0,<2.1</code>). Version 0.1.0 stays available for SQLAlchemy 1.4.</li> <li>Lifted the Python cap. Python 3.11 or newer is supported.</li> <li>Reflection errors are no longer wrapped in <code>RuntimeError</code>. SQLAlchemy errors reach the caller unchanged.</li> <li><code>get_view_definition</code> returns the SQL of the view and raises <code>NoSuchTableError</code> for a missing view. It returned <code>None</code> before. <code>get_table_comment</code> returns <code>{"text": None}</code> instead of an empty string.</li> <li><code>has_table</code> is also true for a view, which is what SQLAlchemy 2.0 expects.</li> </ul> <h3>Added</h3> <ul> <li>Reflection of columns declared as <code>DATETIME</code>, <code>TIMESTAMP</code>, <code>DATE</code>, <code>TIME</code>, <code>BOOLEAN</code> or <code>BOOL</code>. They are reflected as the new types in <code>sqlalchemy_d1.types</code>, which keep the declared name on the <code>d1</code> dialect, so Apache Superset marks those columns as dates and booleans. On other dialects they compile like the generic types. Generic types compile the same as upstream, so tables created through SQLAlchemy are still declared as <code>TEXT</code> and <code>INTEGER</code>.</li> <li><code>autoincrement</code> on reflected columns. It is true only for a single primary key column declared as <code>INTEGER</code>, in a table that is not <code>WITHOUT ROWID</code>.</li> <li><code>get_view_names</code>, <code>get_view_definition</code>, and <code>get_schema_names</code> returning <code>main</code>. Upstream has none of these.</li> <li>Tables and views that start with <code>_cf_</code> are hidden from the table and view lists.</li> <li><code>LICENSE</code> file and license metadata. The package is licensed under <strong>Apache License 2.0</strong>.</li> <li>Unit tests that run offline, integration tests against a real D1 database, and a CI workflow.</li> </ul> <h3>Fixed</h3> <ul> <li>A composite primary key is reflected in the order of the key. Version 0.1.0 returned it in column order.</li> </ul> <h3>Removed</h3> <ul> <li>The dependency on <code>dbapi-d1</code>. The driver built into <code>sqlalchemy-cloudflare-d1</code> replaces it.</li> <li>The original reflection code and the empty <code>compiler.py</code> module.</li> </ul> <!-- raw HTML omitted --> </blockquote> <p>... (truncated)</p> </details> <details> <summary>Commits</summary> <ul> <li><a href="https://github.com/sqlalchemy-cf-d1/sqlalchemy-d1/commit/8c36b39a92d3d00b23bbece28fba90d1c230e17f"><code>8c36b39</code></a> fix: required sqlalchemy-cloudflare-d1 0.4.1 (0.2.2) (<a href="https://redirect.github.com/sqlalchemy-cf-d1/sqlalchemy-d1/issues/6">#6</a>)</li> <li><a href="https://github.com/sqlalchemy-cf-d1/sqlalchemy-d1/commit/0477186c5f03c31cf3cdec6d76b64680c24fdf60"><code>0477186</code></a> docs: reworked README layout (<a href="https://redirect.github.com/sqlalchemy-cf-d1/sqlalchemy-d1/issues/5">#5</a>)</li> <li><a href="https://github.com/sqlalchemy-cf-d1/sqlalchemy-d1/commit/5c952a8cfdfe24807aafbb9edbe3a92b96ebeff4"><code>5c952a8</code></a> chore: bumped version to 0.2.1 (<a href="https://redirect.github.com/sqlalchemy-cf-d1/sqlalchemy-d1/issues/4">#4</a>)</li> <li><a href="https://github.com/sqlalchemy-cf-d1/sqlalchemy-d1/commit/730966b515d2872f158f34a6badf7872ed277650"><code>730966b</code></a> ci: bumped checkout and setup-python to v7 (<a href="https://redirect.github.com/sqlalchemy-cf-d1/sqlalchemy-d1/issues/3">#3</a>)</li> <li><a href="https://github.com/sqlalchemy-cf-d1/sqlalchemy-d1/commit/7486481dc33b1d4ba08898b2e63b2dc31ddc5b91"><code>7486481</code></a> docs: updated README after the Superset merge and dated 0.2.0 (<a href="https://redirect.github.com/sqlalchemy-cf-d1/sqlalchemy-d1/issues/2">#2</a>)</li> <li>See full diff in <a href="https://github.com/sqlalchemy-cf-d1/sqlalchemy-d1/compare/v0.2.0...v0.2.2">compare view</a></li> </ul> </details> <br /> 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]
