anyone ever tried to write a query with pivot for nql?