Is Google Trying to Make SQL Better or Worse?

[aeric]

Google Logica Aims to Make SQL Queries More Reusable and Readable

Logica is a Datalog-like declarative logic programming language for database querying. It supports the creation of reusable abstractions to build complex queries and compiles to SQL, thus making it suitable for wide application.

www.infoq.com

 

[MrKim]

A lot of what they say is true, but I don't think that is what is needed. SQL is sparse for speed. I WOULD like to see an SQL "compiler". So I could do something like "S = Agregate(T1, Sum F2, First F3, Group By F1" and have it build the query for me.
Then
Join(S, T2, S.FirstF3 = T2.F1, T2.*, WITHEDITS)
This would do whatever it takes to build a query that can edit the fields in T2.

The beauty of something like this would be a good compiler could do a much better job of building this query in the most efficient manner.

I realize this is an oversimplification but certainly a lot could (and should) be done to make SQL easier to write.

 

[aeric]

I don't like the idea of LINQ and NoSQL. I still prefer to write plain old SQL. Abstraction is not always a good thing. I prefer more transparency.