break: Support the same env var formats as Meltano

[edgarrmondragon]

Currently, a setting of array type can be parsed from an env var with the following format:

MY_ENV_VAR='a,b,c'

However, Meltano expects array settings to be JSON arrays:

MY_ENV_VAR='["a","b","c"]'

This mismatch is surprising to users familiar with Meltano, and to developers using Meltano to test connectors during development. In the latter case, the env vars and .env file are incompatible.

Related:

• https://github.com/meltano/sdk/issues/390
• This mismatch was introduced early in SDK development: https://github.com/meltano/sdk/commit/e66de5d3b90f93288d1e84206eaf91a3116e2823

[edgarrmondragon]

We could do this in a non-breaking way by adding a flag that's present in the cookiecutter templates so new packages support the new format

[stale[bot]]

This has been marked as stale because it is unassigned, and has not had recent activity. It will be closed after 21 days if no further activity occurs. If this should never go stale, please add the evergreen label, or request that it be added.