在duckdb里正常，写在marimo的sql cell后报错

[WalkCharlie]

SELECT
date(unnest_dates) AS stat_day,
s.*
FROM unnest(
generate_series('{date_range.value[0]}'::DATE, '{date_range.value[1]}'::DATE, INTERVAL 1 DAY)
) AS t(unnest_dates)
CROSS join LATERAL(
summarize select * from pp
where not isnan("NOx真值") and day = unnest_dates
) AS s
order by all
This cell wasn't run because it has errors
Traceback (most recent call last):
File "C:\firefly\MarimoLab.venv\Lib\site-packages\marimo_runtime\runtime.py", line 843, in _try_compiling_cell
cell = compile_cell(
^^^^^^^^^^^^^
File "C:\firefly\MarimoLab.venv\Lib\site-packages\marimo_ast\compiler.py", line 288, in compile_cell
v.visit(module)
File "C:\Users\firef\AppData\Local\Programs\Python\Python312\Lib\ast.py", line 407, in visit
return visitor(node)
^^^^^^^^^^^^^
File "C:\firefly\MarimoLab.venv\Lib\site-packages\marimo_ast\visitor.py", line 493, in generic_visit
super().generic_visit(node)
File "C:\Users\firef\AppData\Local\Programs\Python\Python312\Lib\ast.py", line 415, in generic_visit
self.visit(item)
File "C:\Users\firef\AppData\Local\Programs\Python\Python312\Lib\ast.py", line 407, in visit
return visitor(node)
^^^^^^^^^^^^^
File "C:\firefly\MarimoLab.venv\Lib\site-packages\marimo_ast\visitor.py", line 821, in visit_Assign
self.visit(node.value)
File "C:\Users\firef\AppData\Local\Programs\Python\Python312\Lib\ast.py", line 407, in visit
return visitor(node)
^^^^^^^^^^^^^
File "C:\firefly\MarimoLab.venv\Lib\site-packages\marimo_ast\visitor.py", line 762, in visit_Call
sql_refs = find_sql_refs_cached(statement_sql)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "C:\firefly\MarimoLab.venv\Lib\site-packages\marimo_ast\visitor.py", line 177, in find_sql_refs_cached
return find_sql_refs(sql_statement)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "C:\firefly\MarimoLab.venv\Lib\site-packages\marimo_ast\sql_visitor.py", line 567, in find_sql_refs
for scope in root.traverse(): # type: ignore
^^^^^^^^^^^^^^^
File "C:\firefly\MarimoLab.venv\Lib\site-packages\sqlglot\optimizer\scope.py", line 533, in traverse
scope.cte_scopes,
^^^^^^^^^^^^^^^^
AttributeError: 'NoneType' object has no attribute 'cte_scopes'

[WalkCharlie]

就是对数据按天分组使用summarize，谢谢

[WalkCharlie]

我这样也可以解决，只是SQL一句多简单
@app.cell
def _(conn, period, period_rel, stats_relations):
if stats_relations.value == "period_rel":
summa = {
f"{d.date()}": mo.sql(
f"""
summarize select * from period_rel
where not ISNAN(columns('真值')) and day = '{d}'
""",
engine=conn,
)
.df()
.assign(date=d.date())
for d in period.df().squeeze()
}

    summary = pd.concat(_summa.values())
    mo.output.replace(mo.ui.tabs(_summa))

else:
    summary = mo.sql(
        f"""
        SUMMARIZE
        from {stats_relations.value} where not ISNAN(columns('真值'))
        """,
        engine=conn,
    )
return (summary,)