Is there a way to return a typesafe individual row as opposed to an array?

[paulwongx]

For example the output of the below command is still User[].

const user = await db.select().from(users).limit(1); // User[]

Is it possible to simply have user be of type User?

Writing the statement below loses the typing for user and makes it type any

const user = await db.select().from(users).limit(1)?.[0] // any

[paulwongx]

I guess this explains it.
https://twitter.com/bloberenober/status/1644798759002357762?t=STLfv9ggkuIegcoy9dA51w&s=19

tldr; drizzle is lower level and closer to sql so doesn't have this feature like prisma