EdgeDB is an open source database that is a sort of hybrid of relational and object-oriented. I find its query language very, very interesting.

From the examples on their home page is this query with an aggregation and filter:

select Movie {
  title,
  actors: {
   name
  },
  rating := math::mean(.reviews.score)
} filter "Zendaya" in .actors.name;