.deini
.deini
PostsComments
DTDrizzle Team
Created by .deini on 7/4/2023 in #help
sql escaping on where
Now using: 
sql`unaccent(${users.fullName}) ILIKE unaccent('%${sql.raw(input.query)}%')`
sql`unaccent(${users.fullName}) ILIKE unaccent('%${sql.raw(input.query)}%')`
4 replies
DTDrizzle Team
Created by .deini on 7/4/2023 in #help
sql escaping on where
I "solved" it by using: 
where: sql.raw(`unaccent(full_name) ILIKE unaccent('%${input.query}%')`)
where: sql.raw(`unaccent(full_name) ILIKE unaccent('%${input.query}%')`)
A bit worried about using raw
4 replies