only allows one parameter for '?'.
This means querying for 'Paris' and 'London' can't be executed in one step with this prepared statement.
Current workarounds are:
- either execute the prepared query 2 times with 'Paris' then 'London'
- or prepare a new query select * from Town where key in (?, ?) and bind the 2 parameters
Having a support for variadic parameters list with in clause could improve performance:
- single hop to get the data
- // fetching server side