feat: Add a new built-in test for taps and targets to verify they can get their own package version correctly

[edgarrmondragon]

Feature scope

Taps (catalog, state, stream maps, tests, etc.)

Description

Sometimes the package name doesn't match the plugin/command name. For example, requiring changes like MeltanoLabs/target-snowflake@755795f to ensure the package version can be retrieved and printed.

It'd be nice if developers could get alerted to this during testing by having a test fail if the version can't be retrieved from package metadata.

--

If this is done, users would appreciate if we

• Make it easy to turn the test off in case they don't care about name normalization
• Instruct them on how to make the test pass by maybe updating package_name