in reply to
META.yml the difference between `name` and `requires`
I think the name is the name of the distribution, while the requires section lists modules (not distributions). This is just me guessing - CPAN::Meta::Spec likely has the gory details.
To get from a module to its distribution is in 02packages.details.txt, but there likely are CPAN modules that handle this mapping for you. I would look at CPAN::SQLite first, but most likely many of the other modules implement (or reuse) the similar logic.