malloydata / malloy

Malloy is an experimental language for describing data relationships and transformations.
http://www.malloydata.dev
MIT License
1.91k stars 75 forks source link

Document `select *` in `SQL to Malloy` #1730

Open abhillman opened 2 months ago

abhillman commented 2 months ago

What happens?

run: duckdb.table('output.parquet') -> {
  select: *
}

is not highlighted as incorrect by the IDE.

Bigger opportunity imo: https://docs.malloydata.dev/documentation/language/sql_to_malloy does not explain what the equivalent of select * is in malloy or (if it is not supported) whether there is some help in terms of automatically creating a field list for me. After all, malloy has access to my database, and it would make sense for there to be a code action to fill in a field list.

To Reproduce

run: duckdb.table(<whatever>) -> {
  select: *
}

OS:

does not matter

Malloy Client:

does not matter

Malloy Client Version:

v0.2.1712075074

Database Connection:

duckdb

mtoy-googly-moogly commented 1 month ago

This works ...

image

I think you are saying that you know that { select: * ) is illegal and it should be flagged as such, which is odd because it is legal and it works. If I mis-understood you I apologize.