Hello, How can I rewrite this query cleanly using

prisma.purchaseBill

api and not using a raw query. I read somewhere that we can't compare two column values in prisma as of now ?

@Ahmed Khan 👋 Currently this isn’t supported and we have a feature request for this here.

thanks @Ryan. can i clean it ? like schema name and table name is being hardcoded

You would need to use queryRawUnsafe in that case.

is there anyway i can get the schema name and table name from prisma client for a particualr entity ?

You can get the schema name from the connection string and the table name will be based on what you’re querying for.

thanks