I can relate to the feeling of angst one gets when he encounters an unfamiliar dsl in lisp code(or any language that uses them a lot), but its the same kind of angst i feel when i encounter anything unfamiliar, its perfectly normal. But such irrational fears are, well, irrational. I need better reasoning against lisp(or any other powerful non mainstream language) than "it looks scary", or "it isn't intuitive".
I think he started out well, pointing out that SQL is a DSL for database queries. But the mapping between Cascalog and SQL wasn't clear, without further explanation it seems to be different for the sake of being different.
I would have appreciated a DSL which could obviously be used as a way to query an SQL database more than the examples in the article.