CTE solves this problem. I prefer SQL expressions because they're composable. If you want to do things procedurally, you can just bind a result to a dataframe w

CTE solves this problem. I prefer SQL expressions because they're composable. If you want to do things procedurally, you can just bind a result to a dataframe with duckdb.