coalesce

            const sq = tx.select({
                paymentId: settlementTransaction.paymentId,
                alreadyReleased: sum(settlementTransaction.amount).as('alreadyReleased')
            })
                .from(settlementTransaction)
                .groupBy(settlementTransaction.paymentId)
                .as('sq');
                

            let r = await tx
                .select()
                .from(payment)
                .leftJoin(sq, eq(sq.paymentId, payment.id))
                .where(and(eq(payment.fromCustomerId, s.fromCustomerId), eq(payment.type, 'PREPAID')))