Add Support for Source Versioning / Tables from Sources

[bobbyiliev]

Feature request

As per the discussion here: MaterializeInc/materialize#27907 and based on the design doc here: #645 we need to introduce the support for tables from sources on the Terraform provider side as well.

Extra details to be discussed in the design doc pull request, but the main things to keep in mind are:

Initial tasks

Preview Give feedback

1. Deprecated the related table attributes on the source resources, eg. MySQL, Postgres, Loadgens
2. Introduce new resource_source_table_{mysql|postgres|load_generator} resources
3. Add tests including unit tests and acceptance tests
4. Handle source-specific attributes like the MySQL ignore_columns in the resource_table_from_source resource
5. Update all of the related documentation
6. Write a migrations guide for users using the old implementation
7. Add data sources resource_source_table resources
8. Add import and documentation examples
9. Once ready add upstream table name to read query and read funcs + acceptance tests
10. Add integration tests

Kafka Tasks

Preview Give feedback

1. Deprecated the related table attributes on the source resources for the Kafka source resource
2. Introduce a new resource_source_table_kafka resource
3. Add tests including unit tests
4. Update all of the related Kafka source documentation
5. Add import and documentation examples
6. Update the migrations guide for users using the old implementation to include Kafka sources
7. Add acceptance tests
8. Add integration tests
9. Add the envelope, key_format and value_format columns to the read func

Webhook Tasks

Preview Give feedback

1. Deprecated the related table attributes on the source resources for the Webhook source resource
2. Introduce a new resource_source_table_webhook resource
3. Add tests including unit tests, integration tests and acceptance tests
4. Update all of the related Webhook source documentation
5. Add import and documentation examples
6. Update the migrations guide for users using the old implementation to include webhooks sources

Additional Tasks

Preview Give feedback

1. Data source for mz_internal.available_source_references
2. Add unit tests for the source reference data source
3. Add acceptance tests for the source reference data source
4. Add ALTER SOURCE .. REFRESH REFERENCES