How to pass dynamic named parameters to rusqlite query/execute through params_from_iter function?

[ethever]

How to pass dynamic named parameters to rusqlite query/execute through params_from_iter function?
I saw the Sealed trait has been implemented to Params trait, but there is not such bind_parameters_named method for ParamsFromIter structure.

[ethever]

How to make the bind_parameters_named function to able to accept a Iterator?

pub(crate) fn bind_parameters_named<'a, T: 'a + ?Sized, I>(&mut self, params: I) -> Result<()>
    where
        T: ToSql,
        I: IntoIterator<Item = (&'a str, &'a T)>,

[gwenn]

There is no NamedParamsFromIter for named parameters.
As a workaround, you can use raw_bind_parameter

[bwo]

are there any plans to introduce such functionality? It would be very useful.

[thomcc]

You can just pass &[(&str, &dyn ToSql)]: https://docs.rs/rusqlite/latest/rusqlite/trait.Params.html#impl-Params-for-%26%5B(%26str,+%26dyn+ToSql)%5D

[bwo]

that doesn't mean that a more convenient API wouldn't be appreciated, and in fact I was stymied trying to do just that (I kept getting errors that the size of my slice wasn't known at compile time—obviously, if I knew that, I wouldn't need anything dynamic in the first place).

[thomcc]

If you get errors that the size of your slice isn't known at compile time, it usually means you just need to pass it behind a reference.

[thomcc]

Or perhaps collect into a vec and use vec.as_slice().

[bwo]

Regardless—granted that there are workarounds, the question whether a simple API will be offered is reasonable. Indeed, the docs say:

As a slice of &[(&str, &dyn ToSql)]. This is what essentially all of these boil down to in the end, conceptually at least. In theory you can pass this as stmt.

But while "all of these" boil down to that in the end, that isn't the sole API provided. Other, more convenient ones are, too. I take it from your replies that the answer to my question (will a more convenient way to do this be introduced) is "no".

[thomcc]

Yeah, I don't really have strong feelings.