Sub query with sql magic operator (for common table expression)

const statement = sql`
    WITH RECURSIVE location_tree AS
      (SELECT *
      FROM locations
      WHERE id = 1
      UNION ALL SELECT l.*
      FROM locations l
      INNER JOIN location_tree lt ON l.parent_id = lt.id)
    SELECT DISTINCT package.*
    FROM PACKAGE
    INNER JOIN packages_locations ON package.id = packages_locations.package_id
    INNER JOIN location_tree ON packages_locations.location_id = location_tree.id;`;

    const result= await db
      .select()
      .from(packages)
      .innerJoin("subQuery (above)", eq("subQuery (above)".packageId, packages.id));