sqlserver__get_columns_in_query does not work with CTEs

[robertkosz]

The implementation use the following pattern:
select TOP 0 * from (
{{ select_sql }}
) as __dbt_sbq
where 0 = 1

When select_sql contains CTEs (with) this will fail as TSQL does not support this syntax.
A possible solution would be to use something like this:

{% macro sqlserver__get_columns_in_query(select_sql) %}
{% set get_columns_in_query -%}
SELECT name
FROM
sys.dm_exec_describe_first_result_set
('{{ escape_single_quotes(select_sql) }}', NULL, 0)
{% endset %}

{{ return (run_query(get_columns_in_query).columns[0].values() | list ) }}

{% endmacro %}

It works with any TSQL select statement.