sqlc generate failed.
# package 
query.sql:15:7: column reference "id" is ambiguous

CREATE TABLE employee (
 id BIGSERIAL PRIMARY KEY,
 name text NOT NULL,
 parent_id bigint,
 deleted timestamp
);

-- name: GetEmployeeTree :many
WITH RECURSIVE parent_tree AS (
 SELECT d1.id, d1.name, d1.parent_id
 FROM employee d1
 WHERE d1.id = $1
 AND d1.deleted IS NULL
 UNION ALL
 SELECT d2.id, d2.name, d2.parent_id
 FROM employee d2
 INNER JOIN parent_tree pt ON d2.id = pt.parent_id
 WHERE d2.deleted IS NULL
)
SELECT id, name
FROM parent_tree
WHERE id != $1
ORDER BY id DESC;

{
 "version": "2",
 "sql": [{
 "schema": "schema.sql",
 "queries": "query.sql",
 "engine": "postgresql",
 "gen": {
 "go": {
 "out": "db"
 }
 }
 }]
}