Cannot insert using returned value of CTE with + insert

[kevinlaw91]

I'm testing out the latest CTE with and insert added in version 0.39.0. Couldn't make it work.

// Add email and mark as primary
const newEmail = db
    .$with('new_email')
    .as(
      db
        .insert(tblEmail)
        .values({
          accountId,
          email: email.trim().toLowerCase(),
        })
        .returning({
          id: tblEmail.id,
        }),
    );

  return db
    .with(newEmail)
    .insert(tblEmailPrimary)
    .values({ // TS error 2769
      // I'mm not sure if doing db.select() here is the correct way
      emailId: db.select({ id: newEmail.id }).from(newEmail),

     // This does not work either
      emailId: newEmail.id,
    })
    .returning();

TS report error Type 'PgSelectBase<"new_email", { id: PgColumn<{ ... is not is not assignable to type 'string | SQL<unknown> | Placeholder<string, any>'.

Am I missing something?