Mael

The generated SQL is this ``` WITH table_0 AS ( SELECT bms_id, GREATEST(value.temperature_mosfet, value.temperature_ic) AS _expr_0, GREATEST(value.temperature_front, value.temperature_back) AS _expr_1, LEAST(value.temperature_front, value.temperature_back) AS _expr_2 FROM "recent_cse(4)" ) SELECT bms_id, MIN(_expr_2)...

I verified that if I run the same query without the quotes, eg not `"cse"` but directly `cse` it works eg ``` WITH table_0 AS ( SELECT bms_id, GREATEST(value.temperature_mosfet, value.temperature_ic)...

And if I try ``` from s"recent_cse(4)" derive { min_temp_cells = s"LEAST(value.temperature_front, value.temperature_back)", max_temp_cells = s"GREATEST(value.temperature_front, value.temperature_back)", max_temp_bms = s"GREATEST(value.temperature_mosfet, value.temperature_ic)", } filter min_temp_cells < -10 || max_temp_cells > 40...

would be interesting if we could have something like this! Or allow macros and duckdb functions in PRQL or something

BTW is it possible to do a multi-line PRQL function (this does not seem to be shown in the documentation) I'm trying to do a helper function, then call it...

Would be helpful to have a better help message indeed! I thought the issue was something else yes the boilerplate can work I agree, so not a big priority. It's...

Sorry to use this issue to ask questions but I find that the documentation doesn't show all the power of PRQL yet, for instance: is there a way to do...

Thanks! Last question (and small "bug report") when I use this it works fine ``` let check_temperatures = numWeeks minCellTemp maxCellTemp maxBMSTemp -> ( from (recent_cse numWeeks) derive { min_temp_cells...

ah indeed you're right, but the error message is confusing, @max-sixty would there be a way to show the "correct" error in those cases?

I have the same issue... on latest 1.24.0