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"