3 ms·
Hmm 'select' before 'filter'. This is one of the things that's clunky in SQL; you have to select what you want before you know what you have.
by continuational 5y ago
Hmm 'select' before 'filter'. This is one of the things that's clunky in SQL; you have to select what you want before you know what you have.
- historyloop 5y agoIt's interesting that you know SELECT being first is clunky, without understanding why. SELECT in SQL is clunky because it comes before FROM and JOIN. Do you see FROM or JOIN anywhere here? No. The collections you're selecting from are literally written before the fields you select. The real WTF for me is this claims to be a relational database and you can't join seemingly.
- 1st1 5y agoI replied to another similar comment here: https://news.ycombinator.com/item?id=27795685 https://news.ycombinator.com/item?id=27795685
- continuational 5y agoThat seems a bit snarky to me? In any case, the collection you're selecting from is presumably the filtered one, not the original one. Or am I misunderstanding the semantics?
- ricardobeat 5y agoYou select the collection here, then specify the fields. The opposite of SQL.