Comment by PaulHoule

Some people might think it is crazy but I like wrapping queries like that up in JooQ so I can write

  recursiveQuery(table, linkClause, selectCaluse)