Is there a way to specify custom query for relationship?

[stereobooster]

here are typical relationships in RDMS, like hasOne, belongsToOne, hasMany, hasManyThrough... but what to do if I want to spcify custom query?

Here is my current code

export default class Node extends BaseModel {
  @column({ isPrimary: true })
  public id: number

  public async loadParentTaxonomies() {
    const sql = `
      WITH RECURSIVE traverse(id, to_node_id, from_node_id, type) AS (
        SELECT id, to_node_id, from_node_id, type
        FROM edges 
        WHERE to_node_id = :id AND type = :type
        UNION
        SELECT edges.id, edges.to_node_id, edges.from_node_id, edges.type
        FROM edges JOIN traverse ON edges.to_node_id = traverse.from_node_id
      )

      SELECT id FROM traverse;
    `

    const conn = this.$options?.connection || Env.get('DB_CONNECTION')
    const client = Database.connection(conn)
    const ids = (
      await client.rawQuery<{ id: number }[]>(sql, { id: this.id, type: EdgeType.taxonomy })
    ).map((x) => x.id)

    this.parentTaxonomies = await Edge.query().whereIn('id', ids).preload('from')
  }

  @computed()
  public parentTaxonomies: Edge[]
}

Is there a more elegant way to specify this?