sql/opt: MVP of plan management

[DingDLu]

Provide the ability to pin/lock a specific query plan

Jira issue: CRDB-37290

Epic: CRDB-33855

[dikshant]

As part of this we should also consider how we can detect when a query plan has changed and provide adequate alerting through logs, metrics.