3 replies

sql escaping on where

Trying to do the following:

where: sql`unaccent(${users.fullName}) ILIKE unaccent('%${input.query}%')`,

where: sql`unaccent(${users.fullName}) ILIKE unaccent('%${input.query}%')`,

But it breaks on the secon unaccent with

could not determine data type of parameter $1

could not determine data type of parameter $1

. What am I missing?

sql escaping on where - Drizzle Team