the trait bound &mut Transaction<'_, sqlx::Postgres>: Executor<'_> is not satisfied

[jsoneaday]

I'm getting this error trying to do a transaction not understanding why.

let mut tx = conn.begin().await.unwrap();

        let result = query_as::<_, EntityId>(
            r"
            insert into job (
                employer_id, title, description, is_remote, primary_lang_id, secondary_lang_id, industry_id, salary_id
            ) values (
                $1, $2, $3, $4, $5, $6, $7, $8
            ) returning id
            ")
            .bind(new_job.employer_id)
            .bind(new_job.title)
            .bind(new_job.description)
            .bind(new_job.is_remote)
            .bind(new_job.primary_lang_id)
            .bind(new_job.secondary_lang_id)
            .bind(new_job.industry_id)
            .bind(new_job.salary_id)
            .fetch_one(&mut tx)
            .await;