Where clause dependent on with relation
So I want to add to this query where tweets.length > 0. But I don't know how to anchor on to this tweets relation
const news = await ctx.db.query.newsTable.findMany({
limit: 20,
offset: 20 * input.page,
orderBy: (newsTable, { desc }) => [desc(newsTable.createdAt)],
with: {
tweets: {
with: { pundit: true },
},
},
});