3 ms·
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 wor
by jiggawatts 3y ago
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
- inopinatus 3y agoSo 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.
- johnthescott 3y agoback 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.