Adding named parameters support to sql requests - #731

Hey, thanks for jumping in on this one! Getting named params to work inside IN(...) is a really nice addition, and the tests for the key-reset bug in processInStatementSql are great to have.

I kicked off CI and everything passes (including all the existing positional IN(?) tests, which is awesome for backwards compat) except one: testInStatementWithMixedParams1 blows up on every PHP version with SQLSTATE[HY000]: General error: 25 column index out of range (SimplePdo.php:252). Run here.

Looking at it, that test does id > ? but passes 'id' => 0 as a named key, so there's no positional value for the ? to bind to, right? PDO doesn't really let you mix ? and :name in one statement either, so I'm not sure that case can work as written. Would you agree it makes sense to either fix the test so the params line up, or drop the mixed case (maybe throw a clear exception for it instead)?

Thanks again for helping maintain Flight, really appreciate it!

hello,
Thanks for checking !

You're right, PDO cannot really mix params.
We can indeed throw an exception on that one. another option is to transform all named parameters to unamed ones, but may be a bit more complex as it can be shuffled

I don't really know if it's possible to change the PR ?
or if that move need a new one ?