override metapackage with standard dependency

### Description

See https://github.com/fortran-lang/stdlib/pull/715 



### Possible Solution

For all metapackages, allow overriding metapackage spec with a standard dependency requirement

### Additional Information

_No response_