SQLQueryBindings for arrays using IN operator

[nicoabie]

What is the problem this feature would solve?

Currently this is the only apparent way to run queries that use IN operator

SELECT d.restrictions FROM diners d WHERE 
-- seems bun does not have a way to do this yet or documentation does not mention it
-- this is dangerous and could be sql injected
d.id IN (${dinerIds})

What is the feature you are proposing to solve the problem?

Accept also Array as binding parameters

What alternatives have you considered?

Tried using TypedArrays and it does not work.

[Jarred-Sumner]

Is this in bun:sqlite?

[nicoabie]

Is this in bun:sqlite?

Yes sir