Re:I hate queries
by Locke1689 on Saturday September 25, 2010 @04:58PM
(#1727830)
Here is why SQL exists: http://en.wikipedia.org/wiki/Relational_algebra. Most criticisms of SQL are wrong because the people who write them never bother to read the mathematics or theory behind their construction.
Any language with similar power will be just as complex.
If you just have a limited use case that you want optimized, that's what most ORMs try to do.
Re:I hate queries
by ratsbane on Saturday September 25, 2010 @05:24PM
(#1727911)
Well said. Here's another way of looking at it: if you select an element from a hash (or dictionary or associative array) you're doing the same thing as a simple query. A query is like a higher-order version of a key lookup.
Any language with similar power will be just as complex.
If you just have a limited use case that you want optimized, that's what most ORMs try to do.