Build alter table clause from meta data redshift

gistfile1.txt

select 'alter table ' || table_schema || '.' || table_name || ' alter column experiment_assignments type varchar(65535);'
from svv_columns
where table_schema = 'some'
    and column_name = 'some'
    and character_maximum_length = 512;