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)

Life finds a way, I suppose:-)