Exclusions in unsupported dialects should be errors?

[eitsupi]

What happened?

It is not possible to represent the exclusion of unknown columns in dialects that do not support something like EXCLUDE, but it does not seem to be an error.

PRQL input

from tracks
select !{milliseconds,bytes}

SQL output

SELECT
  *
FROM
  tracks

-- Generated by PRQL compiler version:0.9.5 (https://prql-lang.org)

Expected SQL output

(Should be an error)

MVCE confirmation

• Minimal example
• New issue

Anything else?

No response

[max-sixty]

Definitely agree — I started on this in #2342, but it's a bit more complicated than I thought, since we use the exclude function for other things... I definitely think this is a bug atm...

[eitsupi]

Oh, sorry. I forgot about that. Thanks for working that!

Close it as a duplicate of #2292.