Still for fun, yet another one, via the [JSON1 extension](https://sqlite.org/json1.html#jeach),
whose benefit is that one writes the p.id array only once
(albeit as a string, requiring parsing):
```
sqlite> select p.* from p join json_each('[3,2,4]') a on p.id = a.value order by a.key;
id other
---------- ----------
3 three
2 two
4 four
```