I am not the original poster, but some queries can't be moved to stored procedures (depends on SQL software and library abilities). For example:
IN clauses can get tricky if prepared statements don't support arrays / lists of columns.
Adhoc queries get tricky where user could specify a parameter or not.
This answer is more about stored procedures than prepared statements.