on-run-end hook (or post-hook) to create "redirects" for latest_version of versioned models

create_latest_version_views.sql

{% macro create_latest_version_views() %}

  {% for res in results %}
  
    {% set node = res.node %}
    {% if node.is_versioned and node.version == node.latest_version %}
        
        {% set versioned_relation = api.Relation.create(
            database = node.database,
            schema = node.schema,
            identifier = node.identifier
        ) %}
        
        {% set new_relation = api.Relation.create(
            database = node.database,
            schema = node.schema,
            identifier = node.name
        ) %}
      
        {#-- future: this could be a "pointer view" OR a "table clone" depending on the DWH + relation type --#}
        {#-- inspiration: https://github.com/dbt-labs/dbt-core/pull/7258/files#diff-073e6ed96ac92033f0b921e061b47226b87d4f358350a1ed94fc94165f247b7aR16-R36 --#}
        
        {% set create_view_sql -%}
            create or replace view {{ new_relation }} as select * from {{ versioned_relation }}
        {%- endset %}

        {{ log(create_view_sql, info = true) }}
        
        {% do run_query(create_view_sql) %}
        
    {% endif %}
  
  {% endfor %}

{% endmacro %}

dbt_project.yml

name: my_dbt_project

on-run-end:
  - "{{ create_latest_version_views() }}"

Alternative would be a post-hook version:

{% macro create_latest_version_view() %}

    {% if model.get('version') and model.get('version') == model.get('latest_version') %}

        {% set new_relation = api.Relation.create(
            database = this.database,
            schema = this.schema,
            identifier = model['name']
        ) %}
      
        {#-- future: this could be a "pointer view" OR a "table clone" depending on the DWH + relation type --#}
        {#-- inspiration: https://github.com/dbt-labs/dbt-core/pull/7258/files#diff-073e6ed96ac92033f0b921e061b47226b87d4f358350a1ed94fc94165f247b7aR16-R36 --#}
        
        {% set create_view_sql -%}
            create or replace view {{ new_relation }} as select * from {{ this }}
        {%- endset %}
        
        {{ log(create_view_sql, info = true) }}
        
        {% do run_query(create_view_sql) %}
        
    {% endif %}

{% endmacro %}

# dbt_project.yml
models:
  post-hook: "{{ create_latest_version_view() }}"