How can I append a subquery as an array in the main query select?

const subquery = db
  .select({
    id: myTable1.id,
  })
  .from(myTable1)
  .as("subquery");

const query = db
  .select({
    id: myTable2.id,
    table1Ids: sql`array(${subquery})`.as("table1Ids")
    // Error. Syntax error at or near "subquery" 
  })
  .from(myTable2)
  .leftJoin(
    subquery,
    eq(subquery.id, myTable2.table1Id)
  );