Can I use raw query only in select? Like this https://sequelize.org/master/class/lib/sequelize.js~Sequelize.html#static-method-literal

Hey @DimasDhimek 👋 I didn’t quite get this one. Could you provide an example if possible?

In sequelize i can add raw query in attributes and combine it with built in function. I wanna do raw query operation like IF, CONCAT, and number operation. How can i do that?

Unfortunately this isn’t possible when you directly use the Prisma API like

findMany

. So as a workaround, you would need to use raw queries directly. I also would suggest creating a feature request for the same here so that we can look into this 🙂

Oke, thanks for the answer. 😊