Comment by clubhi

You should look at proper SQL. It looks horrible.

One benefit a layer can add is the ability to optimize post compilation. Most of the fancy pants Hadoop libraries are doing this one way or another.