Hey guys, I probably know the answer, but can we write something like this with Prisma

SELECT SUM(IF(COALESCE(nro_factura, -1) != -1, porc_hes, 0)) as sumaPctFacturado FROM ...

I currently have the following with TypeORM and it works fine

select([
    'SUM(porc_hes) as sumaPctPagado',
    'SUM(IF(COALESCE(nro_factura, -1) != -1, porc_hes, 0)) as sumaPctFacturado'
])

@Eric Martinez 👋 You can use raw queries for this 🙂