Determine the source of a macOS application
Can the source or method of installation of a macOS be determined? Of course, many apps from the AppStore, but also from dmgs (downloaded from a website) and via HomeBrew. An example is Postgres.app which can be installed via HomeBrew and dmg, and no doubt other ways.
System Information>Software>Installations only shows "Apple" and "3rd Party." Which seems to only include apps installed by default and the App Store. And does not list apps installed from dmg or HomeBrew.
I don't see anything in Get Info that helps.
Can I get a list of all apps and their installation method/source?
PS: the Software Information includes all installation, nice if it could be filtered to only the latest version or current version in use.