Can anybody help me? I want search with similarity, unaccent and lower, I can do it with this query (postgresql)

SELECT
	*
FROM
	public."City"
WHERE
	word_similarity(LOWER(unaccent(name)), LOWER(unaccent('mexico'))) > 0.3
ORDER BY
	name

how would I do this with prisma? Note: I already have the plugins installed in the migrations

@Juan Raymundo Carrillo Jasso 👋

unaccent

isn’t supported natively by Prisma so the only way to do it is a raw query. It would be great if you could create a feature request for this here so that we can look into this.

thanks