#9630 test: Validate that the order of rules in `metadata` is meaningful Pull request opened by edgarrmondragon ## Description ## Related Issues • Closes #XXXX ## Summary by Sourcery Validate that metadata rules are applied in sequence with the last matching rule taking precedence, and update documentation to highlight this behavior Enhancements: • Extend MetadataRule.value type to accept both boolean and string values Documentation: • Update integration guide with examples and an info note emphasizing that metadata rule order matters Tests: • Add tests for MetadataExecutor to confirm that the last matching metadata rule wins at both stream and property levels meltano/meltano