Bug with failing double conversion

[samansmink]

First of all, amazing work here @archiewood! Being able to just SELECT * FROM '<gsheets urls>' is really amazing! Also the OAuth works super smoothly.

Minor snag I hit:

Invalid Error: stod: no conversion

for a sheet containing:

col a	col b	col c
1	value1	blabla1
2	value2	blabla2
3	value3	blabla3
	value4	blabla4

Perhaps it makes sense to look into DuckDB's casting functionality instead of using stod? DuckDB has Value::TryCastAs which should allow you to do this a bit more safely.

[archiewood]

Thanks for reporting.
Types and type conversion are very rudimentary at this stage. Will investigate Value::TryCastAs

[archiewood]

Reproduced