请问这个UserWarning是怎么回事？我昨天更新了marimo，然后有吧duckdb安装回1.4.4

[WalkCharlie]

C:\firefly\MarimoLab.venv\Lib\site-packages\sqlglot\tokens.py:20: UserWarning: sqlglot[rs] is deprecated and no longer compatible with sqlglot. Please use sqlglotc instead for faster parsing: pip install sqlglot[c]

[WalkCharlie]

PS C:\firefly\MarimoLab> uv pip show sqlglot
Name: sqlglot
Version: 30.0.1
Location: C:\firefly\MarimoLab.venv\Lib\site-packages
Requires:
Required-by: ibis-framework, jupysql
PS C:\firefly\MarimoLab> uv add --upgrade sqlglot[c]
Resolved 93 packages in 10.62s
Prepared 5 packages in 4.37s
Uninstalled 5 packages in 296ms
Installed 5 packages in 276ms

• openai==2.28.0

• openai==2.29.0

• polars==1.39.0

• polars==1.39.2

• polars-runtime-32==1.39.0

• polars-runtime-32==1.39.2

• pydantic-ai-slim==1.69.0

• pydantic-ai-slim==1.70.0

• pydantic-graph==1.69.0

• pydantic-graph==1.70.0
  不知道会有什么后果,依旧报UserWarning

[WalkCharlie]

我uv pip uninstall sqlglotrs后，还是报
[W 260318 13:52:44 sql_visitor:570] Cannot traverse scope PIVOT trx ON transaction_type USING COALESCE(CAST(MAX(transaction_type = transaction_type) AS INT), 0) AS onehot GROUP BY transaction_type with type '<class 'sqlglot.expressions.query.Pivot'>'
[W 260318 13:52:44 sql_visitor:570] Cannot traverse scope PIVOT trx ON payment_channel USING COALESCE(CAST(MAX(payment_channel = payment_channel) AS INT), 0) AS onehot GROUP BY payment_channel with type '<class 'sqlglot.expressions.query.Pivot'>'
[W 260318 13:52:47 sql_visitor:570] Cannot traverse scope PIVOT trx ON transaction_type USING COALESCE(CAST(MAX(transaction_type = transaction_type) AS INT), 0) AS onehot GROUP BY transaction_type with type '<class 'sqlglot.expressions.query.Pivot'>'
[W 260318 13:52:47 sql_visitor:570] Cannot traverse scope PIVOT trx ON payment_channel USING COALESCE(CAST(MAX(payment_channel = payment_channel) AS INT), 0) AS onehot GROUP BY payment_channel with type '<class 'sqlglot.expressions.query.Pivot'>'
[W 260318 13:54:08 sql_visitor:570] Cannot traverse scope PIVOT trx ON transaction_type USING COALESCE(CAST(MAX(transaction_type = transaction_type) AS INT), 0) AS onehot GROUP BY transaction_type with type '<class 'sqlglot.expressions.query.Pivot'>'
[W 260318 13:54:08 sql_visitor:570] Cannot traverse scope PIVOT trx ON payment_channel USING COALESCE(CAST(MAX(payment_channel = payment_channel) AS INT), 0) AS onehot GROUP BY payment_channel with type '<class 'sqlglot.expressions.query.Pivot'>'

[dmadisetti]

I think this is likely a sqlglot issue. Are you still having the problem?

[WalkCharlie]

Thank you.Sorry, I forget how to raise the problem again. Please forget it