Adding count field to result

I’m trying to add a count field to a result set which is counting all my unread messages
this is my query at the moment.

from c in Comment,
      join: uc in UsersComments,
      where: uc.comment_id ==,
      where: uc.user_id == ^,
      where: is_nil(c.thread_id)
      select: c

I would like to add a unread_count: field to the result, to fetch my main thread messages and unread sub messages count in one go.

unread_count:  -> select where c.thread_id == and is_nil(c.read_at)

unfortunately I don’t have the surplus energy to grok your schemas…

but this talk on schemaless queries should hopefully bring you closer to the solution…