Query only one item from Many-To-Many
I would like only to take one stat not all the arrays. Is there a method to replace limit with something which returns only one item.
const res = await ctx.db.query.servers.findMany({
with: {
game: true,
stat: {
limit: 1,
orderBy: (table, { desc }) => [desc(table.statId)],
with: {
stat: true,
},
},
},
});