Is there a way to include template string inside raw query

prisma.$queryRaw` 

// template string used in the raw sql query
 `

Hey Hussam 👋 You can pass template literal in queryRaw which would allow you to insert variables. Here’s an example:

const email = '<mailto:emelie@prisma.io|emelie@prisma.io>'
const result = await prisma.$queryRaw`SELECT * FROM User WHERE email = ${email}`

Yes I did see this in the docs. My goal is not to pass dynamic variables(eg shown as harcoded here). I like to use template strings inside template strings (i.e inside sql.$rawquery``) Eg placing of ``count(total users)`` Inside of sqlrawquery

I am not exactly able to understand. Can you please share the exact queryRaw string that you are trying to execute?

Sure , check out the last query in the link. This is the rawquery I wanted to execute in prisma https://dbfiddle.uk/?rdbms=mysql_8.0&fiddle=201d21d3eb37758b9a5f4f7c0c34823b

Oh I see what you mean by using template strings inside template strings, I think you should be able to use it, you would just need to escape them through backslash (\)

Perfect !! Sorry, this was not related to Prisma at all.