Why can't I create a PreparedStatement that does select * from tab where id in (?, ?, ?, ...)?

The problem is that the RDBMS does not support bind parameters for the elements in the IN clause. This is a limitation of the database, not the driver.