6 ms·
This looks cool. I like SQL but I have to admit it’s often cumbersome. Something that came to mind after looking at some example queries is the mix of parenthe
by epalm 4y ago
This looks cool. I like SQL but I have to admit it’s often cumbersome.
Something that came to mind after looking at some example queries is the mix of parentheses and square brackets. It’s not immediately obvious to me when I’d use which.
Also (and this might just be a personal pet peeve), why do new languages insist on using flashy new keywords when the status quo would do just fine. What’s the point of filter/derive instead of just calling them where/select.
I sometimes notice languages really go out of their way to ‘be different’, I think it’s xslt (or something xml-related) that uses when/otherwise instead of just if/else. Everyone knows if/else, stop trying so hard :P
- xigoi 4y ago“select” implies that you're selecting from some options, not creating new values. “where” is a preposition whereas “filter” is a verb, which fits the pipeline approach better.
- snthpy 4y agoSquare brackets are for lists/list arguments. Parentheses are when a pipeline/transforms need to be supplied, most notably with `group`. More details here: https://prql-lang.org/book/queries/syntax.html https://prql-lang.org/book/queries/syntax.html