Feature request - Add aggregate "LAST" to GroupedTableAppenderResponse

[zikato]

My use case is that I want to capture a change in plans on readable secondaries. Currently, Query Store doesn't work there (otherwise, I would use it).

I would use one of the several XE events to capture the actual query plan (for example query_plan_profile

and group the same plans by query_plan_hash_signed action. Since I already detect differences in a plan via the query_plan_hash_signed, I don't need to compare the actual XML file (not even sure XML comparison is permitted) and just want to save its last value.

[spaghettidba]

That's an interesting feature. I'll see what I can do. Currently, aggregates are calculated using DataTable.Compute, which doesn't support LAST. It doesn't look like an impossible deal though. Let me have a look