Maximilian Roos

To confirm, are you saying that while the SQL above is equivalent in this specific case, it won't be in the general case? Or that the SQL above isn't equivalent?...

Great, agree. We could try and discriminate between where it matters vs. doesn't, but seems extremely low priority

> This implies that the following two queries may also produce different row ordering results: > > ``` > from employees > sort salary > filter salary > 0 >...

> This bug means we can have PRQL query that should return an ordered relation, but result in unordered relation when compiled to SQL and executed by an RDMS. I...

> I'd suggest to call out `group` in addition of `join` as well. Done > from x | sort a | group b () # is not ordered Right, an...

Tbc, I think we agree! > @max-sixty Are you talking about preserving the order _within_ the group or order of all rows in the table? If it's the latter, I...

Ah, great example @felixge , this is resonating with me now. (I'm not sure what the correct answer is — I can see people saying "I didn't want to do...

(edited the title since we now have some docs)

Agree with both @aljazerzen & @felixge ...

Thanks @JettChenT ! Great first PR! Re accepting the snapshots — the lines that @aljazerzen wrote are the closest way. There are also some pre-written tasks if you want to...