You could use COALESCE to change the NULL values.

select 
       coalesce(path, '') as path
      ,comment 
from  read_csv('${path}')