shillelagh
shillelagh copied to clipboard
betodealmeida
Making it easy to query APIs via SQL
**Is your feature request related to a problem? Please describe.** Adapters could benefit from knowing which columns were requested, so they can fetch less data. **Describe the solution you'd like**...
Implement adapters: - [x] WeatherAPI - [x] CSV files - [x] Google Sheets - [x] Socrata - [x] Pandas - [x] Datasette - [x] Github repositories - [x] [XML](https://github.com/betodealmeida/shillelagh/issues/389) -...
For some adapters like Pandas it would be more efficient to return a buffer that points to the data, instead of an iterator.
SQLAlchemy 1.4 now supports Python asyncio. In order to take advantage of this, the [dialect must be "asyncio-compatible"](https://docs.sqlalchemy.org/en/14/orm/extensions/asyncio.html#asynchronous-i-o-asyncio). It would be great to have a version of the base `Dialect`...
In this sheet (https://docs.google.com/spreadsheets/d/1_rN3lm0R_bU3NemO0s9pbFkY5LQPcuy1pscv8ZXPtg8/edit#gid=1648320094) the column `timeofday` is returned as having type `datetime` (instead of `timeofday`), even though it's formatted as "Time". I hardcoded a solution in https://github.com/betodealmeida/shillelagh/pull/159 to fix...
It would be nice to support at least 2 backends. For Postgres we can use https://multicorn.org/.
WeatherAPI also has an API for forecasts, we could extend the current adapter or create a new one to support it.
See [release notes](https://github.com/rogerbinns/apsw/releases/tag/3.41.0.0), specifically: - [x] https://github.com/rogerbinns/apsw/issues/278 - [ ] https://github.com/rogerbinns/apsw/issues/188 - [ ] https://github.com/rogerbinns/apsw/issues/332 **Is your feature request related to a problem? Please describe.** A clear and concise description...
# Summary New adapter proposal to support CVE, CPES and CWEs from NVD as a datasource. Will consume 2 REST API endpoints from NVD, more details here: https://nvd.nist.gov/developers for the...
