[Feature] Update dependency requirements for importlib-metadata

[jsnb-devoted]

Is this your first time submitting a feature request?

• I have read the expectations for open source contributors
• I have searched the existing issues, and I could not find an existing issue for this feature
• I am requesting a straightforward change to existing dbt-semantic-interfaces functionality, rather than a Big Idea better suited to a discussion

Describe the feature

I have no idea if the restriction on importlib-metadata<7 has any impact on this package but it being there is causing a dependency conflict between dbt-core and airflow 3:

Because apache-airflow==3.0.2 depends on apache-airflow-core==3.0.2 and apache-airflow-core==3.0.2 depends on importlib-metadata>=7.0, we can conclude that                         
      apache-airflow[amazon]==3.0.2 depends on importlib-metadata>=7.0.                                                                                                                   
      And because only the following versions of importlib-metadata are available:                                                                                                        
          importlib-metadata<=7.0.0                                                                                                                                                       
          importlib-metadata==7.0.1                                                                                                                                                       
          importlib-metadata==7.0.2                                                                                                                                                       
          importlib-metadata==7.1.0                                                                                                                                                       
          importlib-metadata==7.2.0                                                                                                                                                       
          importlib-metadata==7.2.1                                                                                                                                                       
          importlib-metadata==8.0.0                                                                                                                                                       
          importlib-metadata==8.1.0                                                                                                                                                       
          importlib-metadata==8.2.0                                                                                                                                                       
          importlib-metadata==8.3.0                                                                                                                                                       
          importlib-metadata==8.4.0                                                                                                                                                       
          importlib-metadata==8.5.0                                                                                                                                                       
          importlib-metadata==8.6.0                                                                                                                                                       
          importlib-metadata==8.6.1
          importlib-metadata==8.7.0
      and dbt-semantic-interfaces==0.7.4 depends on importlib-metadata>=6.0,<7, we can conclude that dbt-semantic-interfaces==0.7.4 and apache-airflow[amazon]==3.0.2 are incompatible.

Describe alternatives you've considered

I don't think I have any alternatives. This package is installed in dbt-core as a direct dependency and not an extra so I think I need this updated (and I need to update dbt-core) in order to upgrade our airflow instance.

Who will this benefit?

Anyone hoping to upgrade to airflow 3

Are you interested in contributing this feature?

Sure but I think this package is a little outside the typical code path so I might need someone to verify that upgrading it doesn't break anything

Anything else?

I have no idea if this is ok. It passes the tests.
#376