Subquery in select statement?

const issuancesSq = tx
  .select({
    totalAcreFeetPerShare: sum(issuance.acreFeetPerShare)
      .mapWith(Number)
      .as('totalAcreFeetPerShare'),
  })
  .from(issuance)
  .innerJoin(
    irrigationYear,
    eq(issuance.irrigationYearId, irrigationYear.id)
  )
  .where(eq(irrigationYear.id, input.irrigationYearId))
  .as('issuancesSq');

const irrigationClients = await tx
  .select({
    available:
      sql`((${irrigationYearShares.shares} * ${issuancesSq.totalAcreFeetPerShare}::numeric) + COALESCE(${auxiliaryIssuancesSq.available}, 0)) - COALESCE(${shrinkSq.shrink}, 0)`.mapWith(
        Number
      ),
    firstName: user.firstName,
    irrigationClientId: irrigationClient.id,
    lastName: user.lastName,
    shares: irrigationYearShares.shares,
    unit: irrigationsSq.unit,
    used: irrigationsSq.used,
  })