insights: logic for ability to aggregate by capture group

Created by: leonore

closes #40418 (closed)

reuses PatternReplacer added to find if a query contains capture groups

Test plan

Added unit tests, please review and suggest any missing cases