Glorp is not ready to do that, but it is not far from being able to do it. At least in the reverse order.
I already asked foor a jOOQ like tool for Pharo before. Now we're two the persons interested on it. By the time we're five somebody will have to build it. :) Regards, Esteban A. Maringolo 2016-10-07 18:37 GMT-03:00 p...@highoctane.be <p...@highoctane.be>: > http://www.jooq.org/ > > e.g. > > SELECT AUTHOR.FIRST_NAME, AUTHOR.LAST_NAME, COUNT(*) > FROM AUTHOR > JOIN BOOK ON AUTHOR.ID = BOOK.AUTHOR_ID > WHERE BOOK.LANGUAGE = 'DE' > AND BOOK.PUBLISHED > DATE '2008-01-01' > GROUP BY AUTHOR.FIRST_NAME, AUTHOR.LAST_NAME > HAVING COUNT(*) > 5 > ORDER BY AUTHOR.LAST_NAME ASC NULLS FIRST > LIMIT 2 > OFFSET 1 > > gives (Java): > > create.select(AUTHOR.FIRST_NAME, AUTHOR.LAST_NAME, count()) > .from(AUTHOR) > .join(BOOK).on(AUTHOR.ID.equal(BOOK.AUTHOR_ID)) > .where(BOOK.LANGUAGE.eq("DE")) > .and(BOOK.PUBLISHED.gt(date("2008-01-01"))) > .groupBy(AUTHOR.FIRST_NAME, AUTHOR.LAST_NAME) > .having(count().gt(5)) > .orderBy(AUTHOR.LAST_NAME.asc().nullsFirst()) > .limit(2) > .offset(1) > > I know that we have GLORP but this is not the same thing. > > Phil
