winget upgrade fails with certain MSIs

Brief description of your issue

Using the winget upgrade command on Microsoft.Azd results in errors. This appears to be related to WinGet misidentifying the Microsoft.Azd installer as an exe as opposed to the wix MSI that it is.

2023-10-27 11:00:17.109 [CLI ] Installer [X64,wix,Unknown,en-US] not applicable: Installed package type 'exe' is not compatible with installer type wix

Of note, there are a couple of customizations to the MSI which may differentiate it from the majority of MSIs in WinGet. These include:

• Custom ARP registry key
• Recently: a change to the component GUID resulting from branding

Steps to reproduce

On the command line:

winget install Microsoft.Azd --version 1.4.300
winget upgrade Microsoft.Azd --version 1.4.400 

Expected behavior

The winget upgrade command succeeds

Actual behavior

The winget upgrade command fails with the error message:

The install technology of the newer version specified is different from the current version installed. Please uninstall the package and install the newer version.

Environment

Windows Package Manager v1.6.2771
Copyright (c) Microsoft Corporation. All rights reserved.

Windows: Windows.Desktop v10.0.22631.2506
System Architecture: X64
Package: Microsoft.DesktopAppInstaller v1.21.2771.0

Winget Directories
-------------------------------------------------------------------------------------------------------------------------------
Logs                               %LOCALAPPDATA%\Packages\Microsoft.DesktopAppInstaller_8wekyb3d8bbwe\LocalState\DiagOutputDir
User Settings                      %LOCALAPPDATA%\Packages\Microsoft.DesktopAppInstaller_8wekyb3d8bbwe\LocalState\settings.json
Portable Links Directory (User)    %LOCALAPPDATA%\Microsoft\WinGet\Links
Portable Links Directory (Machine) C:\Program Files\WinGet\Links
Portable Package Root (User)       %LOCALAPPDATA%\Microsoft\WinGet\Packages
Portable Package Root              C:\Program Files\WinGet\Packages
Portable Package Root (x86)        C:\Program Files (x86)\WinGet\Packages
Installer Downloads                %USERPROFILE%\Downloads

Links
---------------------------------------------------------------------------
Privacy Statement   https://aka.ms/winget-privacy
License Agreement   https://aka.ms/winget-license
Third Party Notices https://aka.ms/winget-3rdPartyNotice
Homepage            https://aka.ms/winget
Windows Store Terms https://www.microsoft.com/en-us/storedocs/terms-of-sale

Admin Setting                             State
--------------------------------------------------
LocalManifestFiles                        Enabled
BypassCertificatePinningForMicrosoftStore Disabled
InstallerHashOverride                     Disabled
LocalArchiveMalwareScanOverride           Disabled

Start by reproducing the issue with the supplied winget install and winget upgrade commands and review the diagnostic message about the installed exe versus newer wix installer. Trace the upgrade path that determines installed package type for Microsoft.Azd; done means the version upgrade succeeds without requiring an uninstall.