[FEATURE]: Support for Selecting Users from Multiple IDs

[ArdiraFarizPasha]

Describe what you want

Hello,
I want to select a user from multiple IDs, but I can't find the select option for multiple IDs in the Drizzle documentation (https://orm.drizzle.team/docs/select). So, for example, if I want to request user data from IDs 10, 15, and 20, the return is going to be an array of 3 user data with IDs 10, 15, and 20. Is it possible to implement this feature, or am I missing something?

Thank you Drizzle Team

[zackperdue]

db.select().from(table).where(inArray(table.column, [1, 2, 3, 4]));

[ArdiraFarizPasha]

db.select().from(table).where(inArray(table.column, [1, 2, 3, 4]));

Dude, thank you so much! I've been struggling for like 3 days trying to solve this lol

[ArdiraFarizPasha]

db.select().from(table).where(inArray(table.column, [1, 2, 3, 4]));

For everyone wondering where "inArray" is coming from, it's from Drizzle.
You can import it like this:
import { inArray } from 'drizzle-orm';

And in my case, you can use it like this:
const Users = await db.select().from(users).where(inArray(users.id, [41, 42, 43]));