Query: project_license_table

select
  full_path as "Project",
  license_key as "License",
  license as "License Name",
  case
    when (
      license_key in (
        'lgpl-3.0',
        'lgpl-2.1',
        'mpl-2.0',
        'epl-2.0',
        'osl-3.0',
        'eupl-1.2'
      )
    ) then 'weak copyleft'
    when (
      license_key in (
        'gpl-3.0',
        'gpl-2.0',
        'agpl-3.0',
        'agpl-2.0',
        'cc-by-sa-4.0',
        'apsl'
      )
    ) then 'popular copyleft'
    when (
      license_key in (
        'apache-2.0',
        'mit',
        'bsd-3',
        'bsd-2',
        'bsd-3-clause',
        'bsd2-clause',
        'cc-by-4.0',
        'wtfpl',
        'ms-pl',
        'unlicensed'
      )
    ) then 'permissive'
    when (license_key is null) then null
    else 'other'
  end as "License Type",
  web_url,
  license_url
from
  gitlab_my_project;