A pretty common request is to lift the FROM up before the select, like the below...

anonymars · 2026-06-05T01:48:01 1780624081

Also helps with autocomplete, which is why LINQ starts with `from`

deepsun · 2026-06-05T07:46:36 1780645596

Linq took that from Hibernate in believe. But in general, I'd say almost all ORM and SQL-gen libraries have FROM first, because it's clearer for programmers.

anonymars · 2026-06-05T12:06:47 1780661207

Hibernate puts SELECT last if requesting only specific properties?

LINQ:

  var query = 
    from e in entities
    where e.property1 == value
    select e.property2;