Preprocessing converts in lists to or clauses, so this query:
select title_id, price
from titles
where title_id in ("PS1372", "PS2091","PS2106")
becomes:
select title_id, price
from titles
where title_id = "PS1372"
or title_id = "PS2091"
or title_id = "PS2106"