What's the most efficient way to implement faceted navigation in SurrealDb?

[alan-strickland-red]

I am looking for a new database platform for a new project I am working on and SurrealDb looks great, and I'm excited to try it out.

One of my requirements however is to implement faceted navigation across any table and I am looking for how efficiently I can implement that.

In the past I would use ElasticSearch Aggregations but it would great if I didn't need to maintain the sync between the database and elasticsearch index to implement faceted nav.