fix(deps): update dependency sqlglot to v26

[renovate]

This PR contains the following updates:

Package	Change	Age	Adoption	Passing	Confidence
sqlglot	>=23.4,<25.35 -> >=23.4,<26.1

---

Release Notes

tobymao/sqlglot (sqlglot)

v26.0.0

Compare Source

💥 BREAKING CHANGES

• due to 1d3c9aa - Transpile support for bitor/bit_or snowflake function (PR #​4486 by @​ankur334):

  Transpile support for bitor/bit_or snowflake function (#​4486)

• due to ab10851 - Preserve roundtrips of DATETIME/DATETIME2 (PR #​4491 by @​VaggelisD):

  Preserve roundtrips of DATETIME/DATETIME2 (#​4491)

✨ New Features

• 1d3c9aa - snowflake: Transpile support for bitor/bit_or snowflake function (PR #​4486 by @​ankur334)
• 822aea0 - snowflake: Support for inline FOREIGN KEY (PR #​4493 by @​VaggelisD)
  • ↘️ addresses issue #​4489 opened by @​kylekarpack

🐛 Bug Fixes

• ab10851 - tsql: Preserve roundtrips of DATETIME/DATETIME2 (PR #​4491 by @​VaggelisD)
• 43975e4 - duckdb: Allow escape strings similar to Postgres (PR #​4497 by @​VaggelisD)
  • ↘️ fixes issue #​4496 opened by @​LennartH

v25.34.1

Compare Source

💥 BREAKING CHANGES

• due to f70f124 - transpile MySQL FORMAT to DuckDB (PR #​4488 by @​georgesittas):

  transpile MySQL FORMAT to DuckDB (#​4488)

✨ New Features

• f70f124 - transpile MySQL FORMAT to DuckDB (PR #​4488 by @​georgesittas)
  • ↘️ addresses issue #​4445 opened by @​fanyang01
• 5a276f3 - add parse into tuple (commit by @​tobymao)

🔧 Chores

• ddf7483 - enable python 3.13 in CI (PR #​4483 by @​simon-pactum)

---

Configuration

📅 Schedule: Branch creation - "after 10pm every weekday,every weekend,before 5am every weekday" (UTC), Automerge - At any time (no schedule defined).

🚦 Automerge: Disabled by config. Please merge this manually once you are satisfied.

♻ Rebasing: Whenever PR becomes conflicted, or you tick the rebase/retry checkbox.

🔕 Ignore: Close this PR and you won't be reminded about this update again.

---

• If you want to rebase/retry this PR, check this box

---

This PR was generated by Mend Renovate. View the repository job log.

[IndexSeek]

It seems that the mssql temporal tests are running into trouble after tobymao/sqlglot@ab10851.

The timestamp_col is now an UnknownColumn.

Would the fix for this be to add this mapping

    typecode.DATETIME2: dt.Timestamp,
    typecode.SMALLDATETIME: dt.Timestamp,

to

ibis/ibis/backends/sql/datatypes.py

Line 17 in f26b9e6

_from_sqlglot_types = {

Here are some quick references to those types for MSSQL:

https://learn.microsoft.com/en-us/sql/t-sql/data-types/smalldatetime-transact-sql?view=sql-server-ver16
https://learn.microsoft.com/en-us/sql/t-sql/data-types/datetime2-transact-sql?view=sql-server-ver16

[IndexSeek]

I gave my idea a try. My intention is that this would be compatible with lower versions of SQLGlot.

Happy to adjust this as needed!

[renovate]

Edited/Blocked Notification

Renovate will not automatically rebase this PR, because it does not recognize the last commit author and assumes somebody else may have edited the PR.

You can manually request rebase by checking the rebase/retry box above.

⚠️ Warning: custom changes will be lost.

[cpcloud]

@IndexSeek Excellent work, thank you!