Hacker News Reader

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.

You select the collection here, then specify the fields. The opposite of SQL.

It'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.

That 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?