QP Hou

this is now supported by setting `use_memory_table` to false.

@atomotic i am not able to reproduce this error with a TEXT column in sqlite. It was correctly picked up by roapi as Utf8 type instead of the Blob type...

I think this likely has something to do with the actual inserted data. I am not able to reproduce this with an empty table created using the same schema: ```...

This turned out to be an upstream connectorx issue, likely related to sqlite's dynamic typing semantic. Filed an upstream tracking issue at https://github.com/sfu-db/connector-x/issues/439

@dominikpeter have you tried to manually cast the type using the `to_timestamp` function?

I think so, thanks @jychen7 !

@jychen7 I believe the first error came from `TableSource::parsed_uri`, we need to encode the path before parsing it there. The 2nd error came from object store, it's `Path::from` implementation expects...

Thank you @jychen7 for the deepdive. I think the workarounds you proposed look fine as a quick fix to the problem :+1: So let's get them in. Ideally, we should...

@jychen7 I think the extra overhead here is not too bad since we only need to do it once per table during boot time. The extra encode/decode in the object...

@jychen7 thanks for taking a stab at this, I left my thoughts for the problem you are facing in a comment https://github.com/jychen7/roapi/pull/9/files#r1096807277.