What did you try? It's no different. JSON strings use double-quotes:
```
sqlite> create unique index p_other_unique on p(other);
sqlite> select p.* from p join json_each('["three","two","four"]') a on p.other = a.value order by a.key;
id other
---------- ----------
3 three
2 two
4 four
```