[FEATURE] Allow filter by "execution_type_desc" on Query Store screen

[ClaudioESSilva]

Which component(s) does this affect?

• Desktop App
• CLI Tool
• SSMS Extension
• Plan Analysis Rules
• Documentation

Problem Statement

When using sp_QuickieStore, I often use the filter @execution_type_desc.

I would like to have that possibility here too.

Proposed Solution

1. Add a new option Execution Type to the Search By drop-down
2. Show a new drop-down ExecutionTypeBox with the three options: regular, aborted and exception, default to regular
3. This will apply an AND rs.execution_type_desc = @executionTypeDesc
4. If the user selects a different Search By option, the ExecutionTypeBox is hidden and the SearchValueBox text box is shown.
5. Add a column named "Execution Type" in both grids "QueryStoreGridControl" and "QueryStoreHistoryWindow".

Use Case

Being able to filter Query Store entries related to execution type: Aborted or Exception.

Alternatives Considered

Manually run sp_QuickieStore.

[erikdarlingdata]

Implemented in #321 and merged to dev. CLI/MCP exposure followed in #325.