Hacker Newsnew | past | comments | ask | show | jobs | submitlogin

There are about 17 of these "SQL but better if we start with the FROM statement at the top" languages.

The language-integrated query (Linq) feature of .NET works the same away:

    var studentsGroupByStandard = from s in studentList
                                  group s by s.StandardID into sg
                                  orderby sg.Key 
                                  select new { sg.Key, sg };
Another example is Microsoft's Kusto Query Language, which they use in Azure Log Analytics:

    StormEvents
    | where State == 'TEXAS' and EventType == 'Flood'
    | top 5 by DamageProperty desc
    | extend Duration = EndTime - StartTime


So did QUEL, as implemented in Ingres circa 1976. Perhaps this is what happens when you go back to basics and take a good long look at Codd's relational calculus (or, equivalently, relational algebra), to which SQL bears only a passing resemblance.


back in my day, i thought a WHERE clause on the "RANGE OF alias IS RELATION" would be useful. nowadays, a session level VIEW is the way to go.




Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact

Search: