in condition doesn't trigger index in any column type ,whether it is JSON or other column type.
so ,do not use in condition,use exists instead,
If I have a select from table where <column> in (<value1>, <value2> ,,, <value-n>) clause the index if available on the <column> it is indeed used.
Just try it. I thought I was going crazy when I saw your reply.