Hey, I am trying to do a raw query but it does not seem to work. If I run this:

const amountMale = await this._prismaService.$queryRaw`
	SELECT 
		COUNT(profile) as count
	FROM "public"."User" AS user, "public"."Profile" AS profile
	WHERE user.profileId = profile.id
	WHERE profile.gender = MALE
`

I get the following error:

Raw query failed. Code: `42601`. Message: `db error: ERROR: syntax error at or near "user"`

It is solved by removing the

AS user

and

AS profile

parts, but then it gives an error on

WHERE User.profileId = Profile.id

saying the

.

is an invalid character. Is there any way to solve this? Prisma version is 3.13, using Postgresql

try put the table name in

"

:

WHERE "User".profileId = "Profile".id

Can you also try wrapping the column name with the quotes

"

?

const amountMale = await this._prismaService.$queryRaw`
	SELECT 
		COUNT(profile) as count
	FROM "public"."User" AS user, "public"."Profile" AS profile
	WHERE "user"."profileId" = profile.id
	WHERE "profile"."gender" = MALE

I solved it by using

u

as name instead of

user

, I think it might have been related to that? But not sure