feature request: force casting when necessary

[aborruso]

Hi,
I have these two files:

• https://gist.github.com/aborruso/d9ec192b5981d357c20e67d0ae341f7f
• https://gist.github.com/aborruso/0870135acca06966501814874b1bc2c4

If I do a JOIN

COPY (
    SELECT w.*, n.*
    FROM st_read('layer.geojson') w
    LEFT JOIN read_csv_auto('table.csv') n ON w.POSTAL = n."ISO_3166-1"
    ORDER BY POSTAL
) TO 'test_1.geojson' WITH (FORMAT 'GDAL', DRIVER 'GeoJSON')

I have this error

Error: near line 1: Not implemented Error: Unsupported field type

And I have it, because I have a date field in the CSV.
If I remove the field Data_Report, I have no error.

I had to do some testing to figure out what the problem was, and this is an example with a few fields.
It would be optimal to have casting forcing for those fields not compatible with the output. An option that forces the field type to text, for non-compatible fields, without having to list them in hard coding.

I am not able to help with code writing, sorry. I report here simply my user experience.

Thank you

[Maxxen]

Hi! Thanks for reporting this issue.
This is a known problem, not all data types are supported when reading from GDAL yet, most notably dates and timestamps. I will look into fixing it properly.