Generate hexagons with filtered results

[dvd3v]

Hi,

I'm looking to implement a function that dynamically generates hexagons based on the count of filtered point geometries from a table. The intended workflow is:

1. Apply a filter (such as date, bounding box, or property using cql2) to a table of point geometries.
2. Generate hexagons dynamically, using the count from the filtered point geometries as a basis and add the count as a property.

I'm unsure about the order of operations in the current TiPG implementation—specifically, whether filters can only be applied after functions have been executed. Could someone clarify if it's possible to use a database function as a layer to accomplish this workflow?

Thanks! 🙏