Create parameterized test which tries each resource type with the `resource_type:` selector

[QMalcolm]

Housekeeping

• [X] I am a maintainer of dbt-core

Short description

Sometimes we add a node and assume a fair amount of the dbt system functionality will come built in. In reality this isn't always the case. Sometimes we under assume, sometimes we over assume what comes by default. We want to build tests which automatically check all "inputs", even as that changes over time.

To that end, in this issue specifically, we want to test that all resource types that are supposed to be usable with the resource_type: selector don't break when used.

Acceptance criteria

• A test exists which tests all acceptable resource types with the resource_type: selector
• If a new resource_type is added, the parametrized test should automatically start testing it

Context

This would have helped catch issues like: https://github.com/dbt-labs/dbt-core/issues/9532

[QMalcolm]

From refinement:

• Maybe GraphNodes can be used
• Maybe define an enum similar to how Retry works
• Maybe add properties to nodes and add helpers to pull what node types should support specific functionality

[QMalcolm]

Source nodes aren't selectable by the --select "resouce_type:<resource_type> syntax. Unsure whether this is intentional or not (documentation)