[Feature] Allow metrics in semantic layer filters

[courtneyholcomb]

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 extension of existing dbt functionality, rather than a Big Idea better suited to a discussion

Describe the feature

Allow referencing metrics in filters for metrics, measures, and saved queries. See more detail in the DSI issue here: dbt-labs/dbt-semantic-interfaces#273

Currently, only references to Dimensions are allowed within filters like this:

metrics:
  - name: The metric name
    type: Categorical or Time or Aggregation
    type_params: specific type params 
    filter: |
      {{ Dimension('entity__name') }} > 0 and {{ Dimension(' entity__another_name') }} is not null

Afterwards, references to Metrics are also allowed like this:

metrics:
  - name: The metric name
    type: Categorical or Time or Aggregation
    type_params: specific type params 
    filter: |
      {{ Metric('bookings', ['user']) }}

Describe alternatives you've considered

No response

Who will this benefit?

No response

Are you interested in contributing this feature?

No response

Anything else?

No response