I have a similar thing. These ‘strapi-isms’ as we call them at work now are so annoying.
I am doing the same query and getting the error:
update "public"."ticket_purchases" set "status" = $1 where ("t2"."id" in ($2)) - missing FROM-clause entry for table "t2"
error: update "public"."ticket_purchases" set "status" = $1 where ("t2"."id" in ($2)) - missing FROM-clause entry for table "t2"