prql icon indicating copy to clipboard operation
prql copied to clipboard

Slight incompatibility with DuckDB

Open max-sixty opened this issue 2 years ago • 0 comments

Currently, querying files in DuckDB doesn't quite work without an alias, because:

from products.csv
filter supplierID == 1

compiles to:

SELECT
  products.csv.*
FROM
  products.csv
WHERE
  supplierID = 1

And actually products.csv.* isn't valid.

We could get around this with just select * when that's all that's needed. This would be valid in every dialect, I think.

max-sixty avatar Jun 26 '22 05:06 max-sixty