Unhelpful error with take -10

[vanillajonathan]

What happened?

I get an unhelpful error message.

Error:
    ╭─[std.prql:23:61]
    │
 23 │ let sub = left right -> <int || float || timestamp || date> internal std.sub
    │                                                             ────────┬───────
    │                                                                     ╰───────── expected a pipeline that resolves to a table, but found `internal std.sub`
    │
    │ Help: are you missing `from` statement?
────╯

PRQL input

from pets | take -10

SQL output

-- None

Expected SQL output

No response

MVCE confirmation

• Minimal example
• New issue

Anything else?

Earlier there was now resolved issue #1396.

[max-sixty]

Thanks! 

Could we add this to bad_error_messages.rs? Quoting from there on why that's a better way of managing these than GH issues:

prql/prqlc/prqlc/tests/integration/bad_error_messages.rs

Lines 13 to 16 in 85d911c

	//! Adding bad error messages here is also a welcome contribution. Probably
	//! one-issue-per-error-message is not a good way of managing them — there would
	//! be a huge number of issues, and it would be difficult to see what's current.
	//! So instead, add the error message as a test here.

[aljazerzen]

The problem here is that your query is parsed as:

from pets | (take - 10)

This is obviously wrong, you cannot substract a number from a function.

Long-term solution is to provide a type error. Short term solution is to make a special case somewhere.