select * from homebrew_packages;

select * from apps;

select * from iokit_devicetree;

select * from kernel_extensions;

select * from kernel_extensions;

select * from keychain_items;

select * from launchd;

select key, subkey, value from plist where path = '/Library/Preferences/com.apple.loginwindow.plist';

select key, subkey, value from plist where path = '/Library/Preferences/loginwindow.plist';

select username, key, subkey, value from plist p, (select * from users where directory like '/Users/%') u where p.path = u.directory || '/Library/Preferences/com.apple.loginwindow.plist';