Add common queries
Including ie dmd query --renovate mostPopular
-- What are the most popular / largest number of dependencies by package manager?
select packageManager, count(*) from packages group by packageManager order by count(*) DESC;
-- Usages of golangci-lint as a source-tracked dependency:
-- select depType, count(depType) from packages where packageName = 'github.com/golangci/golangci-lint' and packageManager = 'gomod' group by depType ;
select platform , organisation , repo , dep_types from renovate where package_name = 'github.com/golangci/golangci-lint' and package_manager = 'gomod';
-- Repos using more-likely-unstable software
select * from packages where currentValue like '0.%' OR currentValue like 'v0.%';
Edited by Jamie Tanna