Iterate across two DataFrames using Query.jl

A related follow on… Not sure if it’s a bug or by design, but it would appear new column names can’t be exactly the same as range variables.

df_new = @from i in df_one begin
        @join j in df_two on i.name equals j.name into k
        @let count = length(k)
        @select {i.name, count=count}
        @collect DataFrame                               
        end
   
println(df_new)

#output

3×2 DataFrames.DataFrame
│ Row │ name    │ _2_ │
├─────┼─────────┼─────┤
│ 1   │ "John"  │ 2   │
│ 2   │ "Sally" │ 4   │
│ 3   │ "Kirk"  │ 3   │

I did expect that new column to be called “count” not “2”. Anything to the left of an “=” in a @select statement to be considered a column name?