Create a custom materialized view where the result is dependent on logic created in the function stack. This can live in the section under Database in main menu as e.g. Materialized Views. You can decide refresh rates and more on them and the data located inside the mat view can be queried in the same way as other queries and used by the function stack in e.g. an API etc. This would allow for a lot more pre-calculation and pre-processing of data for things like statistics, reporting and more.