Can I use file paths as table names for DuckDB?

[max-sixty]

Discussed in #1493

^{Originally posted by eitsupi January 13, 2023}
DuckDB can accept the path to a Parquet file as the table name.
For example, FROM 'test/*.parquet'.
Is there any way to use this in PRQL?
https://duckdb.org/docs/data/parquet.html

It seems that s-string cannot be used for this purpose.

I think this should™ be possible with:

from `test/*.parquet`

but unfortunately this returns:

Error:
   ╭─[:1:6]
   │
 1 │ from `test/*.parquet`
   ·      ────────┬───────
   ·              ╰───────── Unsupported feature: advanced wildcard column matching
───╯

Maybe we need to give it a namespace, and so we should require:

from X=`test/*.parquet`

(currently this fails with the same error)

---

And it should also be possible with an s-string:

from s"test/*.parquet"

though we currently require SELECT here:

s-strings representing a table must start with `SELECT `

Instead, in from, we can take a table name without a SELECT?

Probably this needs someone who really cares about s-strings to do the work here. (me?)

---

For those who want to use this in the meantime, currently this works:

from s"select * from 'test/*.parquet'"

[max-sixty]

#1516 would (kinda) solve this, and contains the broader tradeoff + suggestion for a broader change

[max-sixty]

Closed by #1516, follow #1535 for the broader issue