News for hackers. Stuff that matters.
Re:SQL queries don't start with SELECT by munk-a on Thursday October 03, 2019 @05:19PM (#21152346)
I do prefer this structure, but it differing for this one product is more of a cost than I'd like to pay for it. SQL is wonderful because so much of it is platform independent - nearly everything can be expressed in a common SQL manner and, in practice, I tend to avoid dialect specific SQL whenever possible - this just ups the comprehension immensely.

There are a bunch of tech that's tried to reinvent the wheel with SQL like Redis and Splunk... both of those systems are just a pain to interact with - their variants have strengths, sure, but they lose the ease of declaration and universality of SQL. I'd rather see a SQL variant emerge (if it were to) as a logically compatible declarative language that various DB vendors can add support for.

Re:SQL queries don't start with SELECT by nightski on Thursday October 03, 2019 @05:57PM (#21152668)
The thing is that LINQ's purpose is not to reinvent SQL. While EF has an adapter which converts LINQ expressions to SQL, you can use LINQ against objects and other sources for which it is incredibly useful. In fact, it's better suited to those tasks as it doesn't map 1:1 with SQL. But as someone who uses EF and LINQ on a daily basis, it is possible to learn how the mapping is performed and get the results you want consistently even in some pretty advanced scenarios.
Re:SQL queries don't start with SELECT by scarface74 on Friday October 04, 2019 @08:35AM (#21156986)
Side note, I fell in love with the Mongo LINQ driver. There is no impedance mismatch. While I never used LINQ to avoid learning sql, I would create my complex Mongo queries in LINQ first.
Re:SQL queries don't start with SELECT by jessaustin on Thursday October 03, 2019 @07:13PM (#21153259)
Would there be any conceptual barrier to a particular DB engine getting an updated parser that could handle "FROM... SELECT..." as well as "SELECT... FROM..."?
Re:SQL queries don't start with SELECT by nojvek on Thursday October 03, 2019 @08:56PM (#21153893)
There shouldn’t be. Engines don’t run sql directly. They make an AST, make an intermediate representation of instructions and then execute.

So if it results in same AST, the parser should be flexible. Someone should make PRs for mysql, slqlite and Postgres.

If those three have it, other engines will catch up real fast.

Re:SQL queries don't start with SELECT by mariushn on Tuesday October 08, 2019 @03:14AM (#21189575)