Skip to content

Instantly share code, notes, and snippets.

@Hritik14
Created September 9, 2025 15:31
Show Gist options
  • Save Hritik14/8d5fb9212a4ace4cba9708d1c4de6b16 to your computer and use it in GitHub Desktop.
Save Hritik14/8d5fb9212a4ace4cba9708d1c4de6b16 to your computer and use it in GitHub Desktop.
ScanCodeIO SBOM query for npm debug, chalk and packages owned by Josh
SELECT * FROM public.scanpipe_discoveredpackage sd WHERE sd.name ILIKE '%duckdb%' AND sd.VERSION ILIKE '%1.3.3%'
UNION SELECT * FROM public.scanpipe_discoveredpackage sd WHERE sd.name ILIKE '%duckdb%' AND sd.VERSION ILIKE '%1.29.2%'
UNION SELECT * FROM public.scanpipe_discoveredpackage sd WHERE sd.name ILIKE '%node-api%' AND sd.VERSION ILIKE '%1.3.3%'
UNION SELECT * FROM public.scanpipe_discoveredpackage sd WHERE sd.name ILIKE '%node-bindings%' AND sd.VERSION ILIKE '%1.3.3%'
UNION SELECT * FROM public.scanpipe_discoveredpackage sd WHERE sd.name ILIKE '%prebid%' AND sd.VERSION ILIKE '%10.9.1%'
UNION SELECT * FROM public.scanpipe_discoveredpackage sd WHERE sd.name ILIKE '%prebid%' AND sd.VERSION ILIKE '%1.9.2%'
UNION SELECT * FROM public.scanpipe_discoveredpackage sd WHERE sd.name ILIKE '%abi%' AND sd.VERSION ILIKE '%2.0.1%'
UNION SELECT * FROM public.scanpipe_discoveredpackage sd WHERE sd.name ILIKE '%backslash%' AND sd.VERSION ILIKE '%0.2.1%'
UNION SELECT * FROM public.scanpipe_discoveredpackage sd WHERE sd.name ILIKE '%chalk-template%' AND sd.VERSION ILIKE '%1.1.1%'
UNION SELECT * FROM public.scanpipe_discoveredpackage sd WHERE sd.name ILIKE '%supports-hyperlinks%' AND sd.VERSION ILIKE '%4.1.1%'
UNION SELECT * FROM public.scanpipe_discoveredpackage sd WHERE sd.name ILIKE '%has-ansi%' AND sd.VERSION ILIKE '%6.0.1%'
UNION SELECT * FROM public.scanpipe_discoveredpackage sd WHERE sd.name ILIKE '%simple-swizzle%' AND sd.VERSION ILIKE '%0.2.3%'
UNION SELECT * FROM public.scanpipe_discoveredpackage sd WHERE sd.name ILIKE '%color-string%' AND sd.VERSION ILIKE '%2.1.1%'
UNION SELECT * FROM public.scanpipe_discoveredpackage sd WHERE sd.name ILIKE '%error-ex%' AND sd.VERSION ILIKE '%1.3.3%'
UNION SELECT * FROM public.scanpipe_discoveredpackage sd WHERE sd.name ILIKE '%color-name%' AND sd.VERSION ILIKE '%2.0.1%'
UNION SELECT * FROM public.scanpipe_discoveredpackage sd WHERE sd.name ILIKE '%is-arrayish%' AND sd.VERSION ILIKE '%0.3.3%'
UNION SELECT * FROM public.scanpipe_discoveredpackage sd WHERE sd.name ILIKE '%slice-ansi%' AND sd.VERSION ILIKE '%7.1.1%'
UNION SELECT * FROM public.scanpipe_discoveredpackage sd WHERE sd.name ILIKE '%color-convert%' AND sd.VERSION ILIKE '%3.1.1%'
UNION SELECT * FROM public.scanpipe_discoveredpackage sd WHERE sd.name ILIKE '%wrap-ansi%' AND sd.VERSION ILIKE '%9.0.1%'
UNION SELECT * FROM public.scanpipe_discoveredpackage sd WHERE sd.name ILIKE '%supports-color%' AND sd.VERSION ILIKE '%10.2.1%'
UNION SELECT * FROM public.scanpipe_discoveredpackage sd WHERE sd.name ILIKE '%strip-ansi%' AND sd.VERSION ILIKE '%7.1.1%'
UNION SELECT * FROM public.scanpipe_discoveredpackage sd WHERE sd.name ILIKE '%chalk%' AND sd.VERSION ILIKE '%5.6.1%'
UNION SELECT * FROM public.scanpipe_discoveredpackage sd WHERE sd.name ILIKE '%debug%' AND sd.VERSION ILIKE '%4.4.2%'
UNION SELECT * FROM public.scanpipe_discoveredpackage sd WHERE sd.name ILIKE '%strip-ansi%' AND sd.VERSION ILIKE '%7.1.1%'
UNION SELECT * FROM public.scanpipe_discoveredpackage sd WHERE sd.name ILIKE '%ansi-styles%' AND sd.VERSION ILIKE '%6.2.2%'
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment