How do i specify a type for a new column through a select statement
Yes it is possible:

create view ... as (
    select movie_id, person_id, cast(null as char(1)) as position_name
    from writers
);


I assumed that null (which is part of any type) is what is causing you the problem. Replace null with whatever if that is not the case