Mysql json field in where clause escaping the field name

can some one help me i am traying to create a eq(sql${schedules.extraFields}->>'user', userId),, to acess a json field but the generated query is invalid its escaping the 'user'
1 Reply
Angelelz
Angelelz12mo ago
You can use sql.raw() to write sql directly without drizzle doing anything to it (including escaping so no sql inyection protection)
Want results from more Discord servers?
Add your server