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
Angelelz15mo ago
You can use sql.raw() to write sql directly without drizzle doing anything to it (including escaping so no sql inyection protection)

Did you find this page helpful?