[Feature] [BanyanDB] Support customer insert/update trigger

[wu-sheng]

Search before asking

• [X] I had searched in the issues and found no similar feature requirement.

Description

After we have https://github.com/apache/skywalking/issues/8720, we could build a more aggressive mechanism. All downsampling metrics(hour/day) could be calculated inside BanyanDB, because with rows mergeable with custom function, the downsampling just requires the same aggregation function mechanism with timestamp downsampling(minute->hour, minute->day) and a new logic table name.

One NOTICE before begin this, we should know, database kernel level trigger+function aggregation would make more flush write to hour/day metrics(but this is limited).

Use case

No response

Related issues

No response

Are you willing to submit a PR?

• [ ] Yes I am willing to submit a PR!

Code of Conduct

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