[FEATURE] Allow Read-only intent (for AG listeners and readable replicas - including Query Store on secondary replicas)

[ClaudioESSilva]

Which component(s) does this affect?

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

Problem Statement

Currently, we can't point to a readable secondary to analyse read-only queries or to connect to the secondary query store.

Proposed Solution

Implement the "Read-only intent" check box

Use Case

Being able to run queries against a secondary replica.
Being able to grab Query Store data from the read replica.

Alternatives Considered

N/A

I will implement this.