"can't specify target table for update in FROM clause" is an annoying limitation in MySQL, for which jOOQ automatically implements a workaround.| Java, SQL and jOOQ.