Implement a Rule to evaluate aggregation over constant Values

[raunaqmorarka]

E.g. In the below plan evaluating the aggregation should allow simplification of this plan to just a scan with a static filter

Output[columnNames = [my_partition]]
                │   Layout: [my_partition:varchar]
                └─ Aggregate[type = FINAL, keys = [my_partition]]
                   │   Layout: [my_partition:varchar]
                   └─ LocalExchange[partitioning = HASH, arguments = [my_partition::varchar]]
                      │   Layout: [my_partition:varchar]
                      └─ RemoteExchange[type = REPARTITION]
                         │   Layout: [my_partition:varchar]
                         └─ Aggregate[type = PARTIAL, keys = [my_partition]]
                            │   Layout: [my_partition:varchar]
                            └─ InnerJoin[criteria = (my_partition = max), distribution = REPLICATED]
                               │   Layout: [my_partition:varchar]
                               │   Distribution: REPLICATED
                               │   maySkipOutputDuplicates = true
                               │   dynamicFilterAssignments = {max -> #df_472}
                               ├─ ScanFilter[table = dice:rtblogs.no_bids$data@4508291383134783039, dynamicFilters = {my_partition = #df_472}]
                               │      Layout: [my_partition:varchar]
                               │      my_partition := 9:my_partition:varchar
                               └─ LocalExchange[partitioning = HASH, arguments = [max::varchar]]
                                  │   Layout: [max:varchar]
                                  └─ RemoteExchange[type = REPLICATE]
                                     │   Layout: [max:varchar]
                                     └─ Aggregate[]
                                        │   Layout: [max:varchar]
                                        │   max := max(my_partition_8)
                                        └─ Values[]
                                               Layout: [my_partition_8:varchar]
                                               (varchar '2024-10-12T09:00:00Z')
                                               (varchar '2024-10-12T09:00:00Z')
                                               (varchar '2024-10-12T09:00:00Z')
                                               (varchar '2024-10-12T09:00:00Z')
                                               (varchar '2024-10-12T09:00:00Z')
                                               (varchar '2024-10-12T09:00:00Z')
                                               (varchar '2024-10-12T09:00:00Z')
                                               (varchar '2024-10-12T09:00:00Z')
                                               (varchar '2024-10-12T09:00:00Z')
                                               (varchar '2024-10-12T09:00:00Z')
                                               (... 1112124 more rows ...)

cc: @martint @kasiafi