WITH extensions_flat AS (SELECT * FROM plist WHERE path LIKE '/Applications/%.app/Contents/PlugIns/%SafariAppExtension.appex/Contents/Info.plist')
SELECT 
SPLIT(path, '/', 1) AS extension_parent_app,
MAX(CASE WHEN key = 'CFBundleIdentifier' THEN value END) AS bundle_identifier,
MAX(CASE WHEN key = 'CFBundleDisplayName' THEN value END) AS display_name,
MAX(CASE WHEN key = 'NSHumanReadableDescription' THEN value END) AS description,
MAX(CASE WHEN key = 'CFBundleShortVersionString' THEN value END) AS bundle_short_version,
MAX(CASE WHEN key = 'CFBundleVersion' THEN value END) AS bundle_version,
MAX(CASE WHEN key = 'NSHumanReadableCopyright' THEN value END) AS copyright
FROM extensions_flat
GROUP BY path;

extension_parent_app = 1Password 7.app
   bundle_identifier = com.agilebits.onepassword7.1PasswordSafariAppExtension
        display_name = 1Password
         description = Easy Access to Your Logins, Credit Cards and Identities.
bundle_short_version = 7.5
      bundle_version = 70500002
           copyright = Copyright © 2018 AgileBits Inc. All rights reserved.

extension_parent_app = DuckDuckGo Privacy <http://Essentials.app|Essentials.app>
   bundle_identifier = com.duckduckgo.macos.PrivacyEssentials.SafariAppExtension
        display_name = Privacy Dashboard
         description = DuckDuckGo Privacy Dashboard - track who we caught trying to track you.
bundle_short_version = 1.4.1
      bundle_version = 12
           copyright = Copyright © 2019 Duck Duck Go, Inc. All rights reserved.