@select all columns in Query.jl

In the following code, how can I @select all columns from a dataframe? Do I have to explicitly list all columns I want to @select?

x = @from r in DataFramesIO begin
    @where !isnan(r.SHARES)
    @select all
    @collect DataFrame
end

Just omit the whole line containing the @select statement.

Dropping @select would result in the follow error

LoadError: MethodError: no method matching @from(::LineNumberNode, ::Module, ::Expr)
Closest candidates are:
  @from(::LineNumberNode, ::Module, ::Expr, ::Expr)

You write it as @select r, i.e. the range variable r stands for the entire row, and that is what you want to return.

I would also suggest to consider using the standalone query commands with pipes, that is the primary area where I’m adding new features. The LINQ style queries that you are using will never go away, but I don’t expect it to get many new features.

Yes, I was thinking of the standalone commands and replied too quickly. You want to do @select r here.