Is there built in functionality or a guide on how to use queries with count, coalesce etc?

[Designer023]

Is there an existing issue for this?

• I have searched the existing issues

Code of Conduct

• I agree to follow this project's Code of Conduct

Question

I have a more complex query which currently is like this:


.grab$({
   ...// the other fields
   count: [
      `count(*[_type== "article" && references(^._id) && coalesce(language, 'en') == 'en'])`,
       q.number()
   ]
})

Is there any built in way, or suggestions on how I can optimize the query so I'm not writing long strings of filters (i.e. the old way).

I'm looking for something like:

q.count(q.("*").filterByType("article").filter(q.coalesce("language", 'en')))
// or 
q.("*").filterByType("article").count()

I guess I could use select to replace the coalesce, but a built in function would be nice to have where possible:

select(
    language => language,
    "en"
)