If you haven't seen anything, did you actually look around?
Common SQL : http://www.lispworks.com/documentation/sql-tutorial/index.ht...
(loop for columns being the records of
[select [*] :from [SpeciesList]
:where aardvark]
do (print columns))
For all the ease with which one can create macros in LISP, I haven't seen anything comparable to LINQ yet.
And while I've seen useful macros here and there, I haven't seen anything groundbreaking ... macros are mostly used when you need laziness.
Powerful? Yes. Easy to use? No.