Fixes for updating winget from winget (1.12) (#5978)

CP of #5972 onto 1.12
###### Microsoft Reviewers: [Open in
CodeFlow](https://microsoft.github.io/open-pr/?codeflow=https://github.com/microsoft/winget-cli/pull/5978)

Fixes for updating winget from winget (1.12) (#5978)

CP of #5972 onto 1.12
###### Microsoft Reviewers: [Open in
CodeFlow](https://microsoft.github.io/open-pr/?codeflow=https://github.com/microsoft/winget-cli/pull/5978)

Details output option for `list` (#5939)

## Change
The new experimental feature `listDetails` enables a new option for the
`list` command, `--details`. When supplied, the output is no longer a
table view of the results but is instead a series of `show` like outputs
drawing data from the installed item.

An example output for a single installed package is:
```PowerShell
> wingetdev list Microsoft.VisualStudio.2022.Enterprise --details
Visual Studio Enterprise 2022 [Microsoft.VisualStudio.2022.Enterprise]
Version: 17.14.21 (November 2025)
Publisher: Microsoft Corporation
Local Identifier: ARP\Machine\X86\875fed29
Product Code: 875fed29
Installer Category: exe
Installed Scope: Machine
Installed Location: C:\Program Files\Microsoft Visual Studio\2022\Enterprise
Available Upgrades:
  winget [17.14.23]
```

When there are multiple results, the identity line is prefixed with the
standard `(N/M)` format string used in multi-package operations
elsewhere.

If sixels are enabled and supported by the terminal, an icon for the
installed package will be shown. This currently models the mechanism
used by winget-pkgs to extract the icons and by the `show` command to
select the appropriate one to display. It is using the same code in the
same manner and should be representative of what would be shown to the
user if it were doing the full round trip through the
repository/cache/`show` command.

Update release notes for v1.28 (#5957)

Adding what I put in
https://github.com/microsoft/winget-cli/releases/tag/v1.28.90-preview
###### Microsoft Reviewers: [Open in
CodeFlow](https://microsoft.github.io/open-pr/?codeflow=https://github.com/microsoft/winget-cli/pull/5957)

Enable source reference to get thread globals for off-thread logging (#…

…5780)

## Change
Allow `ISourceReference` and `Source` to have `ThreadGlobals` provided
so that they can use them for other-thread logging. Enable this for the
thread async REST source so that our certificate pinning callback can
log results.

Support associating export units with packages in subdirectories (1.1…

…2) (#5866)

CP of #5859

## Change
The primary motivation is to support directories below the install
location to contain configuration units that we will associate with the
package. This is achieved by refactoring the association logic from a
Package x Unit loop into a tree structure that is colored by package
install locations. This also has the benefit of making a O(N^2)
algorithm into an O(N).

Units are first inserted into the tree based on their file path. Then
the install location of each package is recorded onto that tree as well.
Finally, during the export of each package, all resources at the install
location and any that are descended from it but not under another
package are included.

Support associating export units with packages in subdirectories (1.1…

…2) (#5866)

CP of #5859

## Change
The primary motivation is to support directories below the install
location to contain configuration units that we will associate with the
package. This is achieved by refactoring the association logic from a
Package x Unit loop into a tree structure that is colored by package
install locations. This also has the benefit of making a O(N^2)
algorithm into an O(N).

Units are first inserted into the tree based on their file path. Then
the install location of each package is recorded onto that tree as well.
Finally, during the export of each package, all resources at the install
location and any that are descended from it but not under another
package are included.

Move to latest 7.4 PS SDK (1.12) (#5812)

CP of  #5811

## Change
Update to the latest 7.4 PowerShell SDK. Updates the SqlClient version
as well since it is a required dependency.

Move to latest 7.4 PS SDK (1.12) (#5812)

CP of  #5811

## Change
Update to the latest 7.4 PowerShell SDK. Updates the SqlClient version
as well since it is a required dependency.

MS Store cert pinning updates (1.11) (#5735)

Cherry-pick #5732 to 1.11

## Change
New certificate pinning guidelines/PKI allow us to pin only a trusted
intermediate. This means less churn due to renewals with the Store.

Adds functionality to the pinning validation to allow partial chain
definitions. This is leveraged to allow chains containing two new
intermediate certificates

The existing chains are left as is since they continue to be the current
in-operation values.

## Validation
Adds new tests covering partial chain definitions, etc.
Adds a new test to warn about the remaining lifetime of pinning
certificates.