Question about dynamic fields and tables

[Minitour]

Hi,

I am trying to build an adapter over MongoDB.
I was wondering it is possible to allow for dynamic fields (columns).

MongoDB, being a NoSQL document database, there is no "DESCRIBE TABLE" statement. I need to sample some documents for a collection and determine the schema based on the sample.

My question is, would it be possible to perform a SELECT x FROM myCollection without having to have x be registered as a column. After all I know what are the names of the requested fields in get_data.

However with my current setup, the SQLite backend simply denies the request with the error being "unknown column".

[betodealmeida]

@Minitour the schema is needed in order to register the virtual table with SQLite. Many adapters have the same problem, they need to sample rows in order to figure out the schema. Take a look at the CSV adapter or the generic JSON adapter, they use the shillelagh.lib.analyze function to determine the schema, order, and number of rows.