Query deeply nested self relations

[Tezi-app]

Whats the best way to query deeply nested self relations?

here is the sql query that LLM generated. want to understand how to best acheive this in orchid.
https://www.getmerlin.in/chat/share/8f348e47-edc1-44ad-908d-c1024d51ff2a

Specific Example

export class TeamMemberTable extends BaseTable {
  readonly table = "team_members";

  columns = this.setColumns(
    (t) => ({
      id: t.string().primaryKey(),
      designation: t.string().nullable(),
      name: t.string().nullable(),
      reportsTo: t.string().nullable().foreignKey(() => TeamMemberTable, "id")
    }),

[Tezi-app]

Found this in docs for this exact use case. Super!!! https://orchid-orm.netlify.app/guide/advanced-queries.html#withrecursive

Here are some alternatives for anybody who lands here looking for this
https://www.getmerlin.in/chat/share/32ba1265-272d-4b60-8845-4fcc1059739c