ibis fix(deps): update dependency sqlglot to >=23.4,<25.18

This PR contains the following updates:

Package	Change	Age	Adoption	Passing	Confidence
sqlglot	`>=23.4,<25.17` -> `>=23.4,<25.18`

Release Notes

tobymao/sqlglot (sqlglot)

`v25.17.0`

Compare Source

:boom: BREAKING CHANGES

due to 0a9ba05 - 0 is falsey (commit by @tobymao):

0 is falsey

:bug: Bug Fixes

42b725e - flaky test closes #3961 (commit by @tobymao)
cc29921 - Parse LTRIM/RTRIM functions as positional exp.Trim (PR #3958 by @VaggelisD)
- :arrow_lower_right: fixes issue #3957 opened by @sleshJdev
678e692 - make sample an arg of table, not a wrapper (PR #3963 by @barakalon)
0a9ba05 - 0 is falsey (commit by @tobymao)
c1ac987 - starrocks: exp.Array generation, exp.Unnest alias (PR #3964 by @VaggelisD)
- :arrow_lower_right: fixes issue #3962 opened by @hellozepp

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.

Aug 27 '24 01:08 renovate[bot]

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.

Aug 27 '24 12:08 renovate[bot]

Broken for PySpark until https://github.com/tobymao/sqlglot/issues/3992 is fixed and released.

Not yet sure of a workaround.

Aug 28 '24 15:08 cpcloud

I'll add an xfail for this version so we can get this upper bound into the next ibis release.

Aug 28 '24 15:08 cpcloud

Clouds are good:

cloud in 🌐 falcon in …/ibis on  renovate/sqlglot-25.x is 📦 v9.3.0 via 🐍 v3.10.14 via ❄️   impure (ibis-3.10.14-env) took 28s
❯ pytest -m snowflake -n 8 --dist loadgroup --snapshot-update -q && pytest -m bigquery -n auto --dist loadgroup --snapshot-update -q
bringing up nodes...
.................s.................................................................s...x..s.....................x....x......x..........x.....x.xx..x....xxx..........sx................x.x....x.xx......................x...............................................x....x............................x......x........x........x.................x...x.......x..x............x.x..xx..x...x.x..xx.xx.x.x.x.xxxx.x...x..xx [ 22%]
x.x.xx..xx.xxx.xxxx.x.x...x...xx.xxx..x..x.xx..x..x.x..x..x..x..x.xx..x..x..xxxxxxxxxxxxx.xxxx...................x.....x......xx...................................................x.....xx.......x...x......x...x..x......x.x............................x.....x....x..............x..x.............x..................x....x.x............x....x..........................x....x..........x......x......x.................. [ 44%]
...........x.......x..............................x.x..xx.x.....x....................................x...x..x..................x........................................x...x...............................................................x.................xs...x.......................x.........x......x............x...x...x.x..xx........x...x.x.x....x...xx....x.........x....................xx..x.x................ [ 66%]
...............x....xxxx...x.........x.x.x.x....xx...x.x...........x.....x....x.....................................x...................x.....s...........x......x..................x.......................x............x............................x.......................................................x...................x...................................x.x..xxx.xx....xxxxx..x..x......x..xxx........xx....... [ 88%]
...s.............................s..........s.............................................................................s...........................................................................................                                                                                                                                                                                                        [100%]
1636 passed, 10 skipped, 220 xfailed in 228.37s (0:03:48)
bringing up nodes...
........x..x.....x.....................x..x..x.........x........x..x.................x..........xx.x..................x.......x........xx.................x.......x.........x......................xxxx.xx..xxx...x.....x.xx.xx...x.x..x.....x......................x...x........x.......................x...s..................................x...xx................x.xx..............x..x.........................x.x..... [ 19%]
.x.......x.........x.......x.x...x........x......x..x.x.....x..........ss..........................................................x......s.........xx..x..xx.x.x.x.x.......x..x.ssssssssssss.sssssssss.x...x..x..x....x.....x...x.xx.x..x...........x..x....xx.......x.x...x.....x..x.x.....x..ssssssssssssss.ssssssssssss.ssssssssss.ssssssssssssssssssssssssssssssssssssssssssssssssssx............x...x.................. [ 39%]
x......x..................x.........x.......x...............x..............xx...x...x..x.......x...xx..x......s............x...x..........sx.x.........x.....xxxs............x............x......x.........X...xs....x....x..x..xx.....x.....X...xx..x...x.x...........x...........x..................x.x....x..xx.xx...X.....X..x...x....x....................x..xxx...xx................x.X.....x.xxx..x................... [ 59%]
x....x.............................................x....x................................................x.........x...x...x.x.....................x...x...........x.x..x......x.x.x...x..xx....xxx......x.........x..x.x.x..........x.x.....xxxxxxxx..xx......x..x..xxxx.x.x.....x.xxxx....xxx.xxxxxxx.xxxxx.x.xxx.x.xx.xxxxxx.xxxxxxxxxxxxxx.x.xxx.xx..xx.xx.xxxxxxxxxxxxxxxx.xxx.xxxxx..x.xx...x.xx.x.xx.xxxxxx.x.xxxxxxxx [ 78%]
x.xxxxxxxx...x..............x....x......x..x..xxx.xx.x..................................................................................................................x..........................................................................................................x.........x..............x..............................................................x................................................. [ 98%]
............................                                                                                                                                                                                                                                                                                                                                                                                                  [100%]
1632 passed, 115 skipped, 341 xfailed, 5 xpassed in 259.19s (0:04:19)

Aug 29 '24 14:08 cpcloud