Hello, I am new to Prisma, and I have a Postgres RAW query which is nested Inner Queries, I wanted to know that how I can write that using Prisma? below is my RAW Query..

SELECT * FROM tableName WHERE id NOT IN (SELECT columnName FROM tableName WHERE (startDateInputFromUser between startDate and endDate) or (endDateInputFromUser between startDate and endDate))

here in WHERE clauses the

startDateInputFromUser

&

endDateInputFromUser

it's from the User Input & other

startDate

&

endDate

is the Table Column Name... can anyone help me how I can write this query in the Prisma ORM?

Hey Dhaval 👋 As your query contains nested select, you can use queryRaw to execute this request. Using queryRaw would be the most straightforward way in this case.