Optional exports within saved queries

[FishtownBuildBot]

At a minimum, update body to include a link to the page on docs.getdbt.com requiring updates and what part(s) of the page you would like to see updated.

Issue / PR

dbt-labs/dbt-core#8892 / dbt-labs/dbt-core#8950

Example

Example from here:

saved_queries:
  - name: test_saved_query
    description: "{{ doc('saved_query_description') }}"
    label: Test Saved Query
    query_params:
        metrics:
            - simple_metric
        group_by:
            - "Dimension('user__ds')"
        where:
            - "{{ Dimension('user__ds', 'DAY') }} <= now()"
            - "{{ Dimension('user__ds', 'DAY') }} >= '2023-01-01'"
    exports:
        - name: my_export
          config:
            alias: my_export_alias
            export_as: table
            schema: my_export_schema_name

[matthewshaver]

Closing for now as this is just the foundation. Will address again when an issue is opened as the functionality goes live in the product.