toned down the use of column generator on the query