Hacker News new | past | comments | ask | show | jobs | submit login

> Moreover, SELECT should be at the end not the beginning. Query comprehensions and LINQ did this right.

I'd one-up this and argue that all SQL statements should be in order of execution (within reason). Moving SELECT to the end is definitely a good start.




Mixing execution concerns and the language seems like a bad idea.

It's pretty much impossible to decide what an optimised query should look like on a different databases with different data.

Slow network? Fast disks? GPU optimised joins? No way to know what execution order should be, and that's a strength of the relational model.




Consider applying for YC's Spring batch! Applications are open till Feb 11.

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

Search: