3 ms·
Yes. I wish SQL select-statements put the select-clause last: from people where name = 'Joe' select upper(name) as bigname 1. It would mirror the oth
by combatentropy 9y ago
Yes. I wish SQL select-statements put the select-clause last:
from people
where name = 'Joe'
select upper(name) as bigname
1. It would mirror the other clauses (insert, update, and delete) which all begin with the table name.
2. It would be easier on my head. I skip the select-clause anyway when reading SQL, then come back up to it at the end, when I know the columns' source.
3. It would show that using column aliases in the where-clause would fail (unless the database did some kind of two-pass processing).
- Volrath89 9y agoYou just described LINQ