pivtot2.sql

-- Load the results of our statement and select the first column
{%- set states = load_result('states')['data'] | map(attribute=0)-%}

select
    *,

    -- Loop over each state
    {% for state in states | list -%}
    
        case
            when state = '{{ state }}' then 1
            else 0
        end as "is_{{ state }}"

        {% if not loop.last %} , {% endif %}
    {% endfor %}

from {{ ref('users') }}