If a Prisma query returns many rows it returns an object ```

Question

If a Prisma query returns many rows it returns an object ``` 0 1 2 etc ``` Has there been discussion about returning an array instead An array would be more useful than an object whose keys are just the position in an array anyway We can get the array with Object values I know but still it seems like an unnecessary step

ksuh · Answer

If you are referring to `findMany` it does not return an object It is an array <https www prisma io docs reference api reference prisma client reference findmany>

Fergus Meiklejohn · Answer

If there is a join query like in this thread my comment has many replies they are returned as an object

ksuh · Answer

perhaps you could provide a code snippet of your query using prisma

Fergus Meiklejohn · Answer

yeah sure ```await db chatRoom findUnique where id 123456789 include comments select insertedAt true id true commentText true user true replies select insertedAt true id true commentText true user true replies true ```

Fergus Meiklejohn · Answer

Same issue when I use a join table for eg users and organisations The prisma schema shows an array the prisma query for user with organisation returns an object 0 ` I m having to go through my query responses to clean them up I wanted to discuss this here first I m thinking perhaps this should be an issue on the repo

nikolasburk · Answer

Hey Fergus wave thanks for raising this Something seems fishy here thinking face Prisma should certainly return arrays in these situations Can you maybe <https github com prisma prisma issues new choose|open up a new GitHub issue> and ideally provide a standalone reproduction of the issue so that our Engineering team can look into this