Maximilian Roos

I was originally envisaging that we could pass a single item where we could pass in a list, that those would be interchangeable. Totally agree that they mean different things...

Thanks for the issue! I'm a big fan of Datalog and have followed logica for a while. How would you see this working for simple joins? Do you think it's...

Reflecting on #478, there may be a 4th type — a "Row" type — with multiple columns but only one row. Modifying the example from above: ```sql SELECT name FROM...

Right, very good point. One approach that is a) awkward and b) only covers some cases — is to make a CTE out of the s-string: ```elm from s"SELECT *...

Ah great! Though `ORDER BY` needs the adjustment above (I have been trying to get this to work, but in short bursts again...)

> This would require #376 and a table flag to add the `RECURSIVE` keyword. Possibly we could also have an s-string that doesn't bind to anything; it's just: ```sql s"""...

I think we could add a `table recursive:true` parameter to table. I admittedly haven't ever used `RECURSIVE`, but I can definitely understand the appeal. I probably wouldn't prioritize it that...

Malloy uses `pick` for these: ``` size ? pick 'small' when < 10 pick 'medium' when < 20 else 'large' ``` Tangentially, something nice in Malloy is "[partial comparison](https://looker-open-source.github.io/malloy/documentation/language/expressions.html#partial-comparison)"; the...

Yes, the s-string is the classic escape hatch. But I think this is one of the few areas that's really missing from the language for it to be broadly useful...

@aljazerzen WDYT about the `case` & `match` expression / pipelines? I think they could be good, but they would extend our syntax a bit, and so are worth considering carefully....