- Relax
requests
dependency - Enable
supports_statement_cache
.
- Fix for GSheets where the first row is not detected as column names
- Do not try to import non-specified adapters
- Fix for querying datetime/date/time via SQLAlchemy
- Add support for using Google Application Default Credentials for Google Sheets
- Make package PEP 561 compatible
- Add
requests
as a dependency - Documentation fixes
- Add an adapter for system resources (CPU usage for now)
- Improve PEP 249 compatibility
- Implement
do_ping
for GSheets dialect - Create a
cookiecutter
template for new adapters - Add a
StringDuration
field - Add GitHub adapter
- Handle arbitrary number formats in Gsheets
- Add pattern parser/formatter for GSheets
- Add optional dependencies for Datasette
- Fix Datasette by always using
LIMIT
withOFFSET
- More operators:
LIKE
,IS NULL
,IS NOT NULL
and!=
- Add cost estimation to all adapters
- Add Datasette adapter
- Remove
csv://
anddatasette+
prefixes to simply URIs - Add
has_table
method to dialects
- Move config to
~/.config/shillelagh/
- Add function
get_available_adapters
to list installed adapters - Developer and user docs added
- Small fixes
- Add integration tests
- Fix couple bugs on GSheets while adding integration tests
- Refactor fields
- Change GSheets to use formatted values
- Fix bug in GSheets DML with datime/date/time
- Return naive objects when no timezone specified
- Fix DML bug in GSheets with a middle nameless column
- Relax
google-auth
dependency
- Fix
SELECT
bug in GSheets with a middle nameless column
- Relax SQLAlchemy dependency
- Add support for DML to the GSheets adapter
- GSheets dialect now return "main" as its schema
- Schema prefix can now be used on table names
- GSheets now supports defining a catalog of spreadsheets
- Improve many small bugs in the type conversion system
- Add
sleep
,version
, andget_metadata
functions - Add REPL command-line utility (
shillelagh
) - Remove
adapter_args
, use onlyadapter_kwargs
now
- Parse bindings in
execute
, allowing native Python types - Allow configuring adapters via kwargs in addition to args
- Handle type conversion via fields
- Fix Socrata, mapping
calendar_date
toDate
- Adapter for Socrata
- Better error handling in the GSheets dialect
- Use GSheets URL parameters on
get_table_names
- Use new GSheets API v4
- Implement
get_table_names
for GSheets dialect - Allow passing parameters to GSheets dialect via URL query
- Import
Literal
fromtyping_extensions
for Python 3.7 compatibility
- Fix for some Google sheets where headers are not picked up
- Make
parse_uri
signature more generic
- Allow adapters to return complex types (eg, datetime)
- Implement
Order.ANY
for columns that can be sorted by the adapter - Add all columns to the weatherapi.com adapter
- Add safe mode through
shillelagh+safe://
- Fix isolation levels for apsw
- Handle conversion of datetime objects (time, date, datetime) natively
- Ignore empty columns in gsheets
- Add DB API 2.0 layer
- Add SQLAlchemy dialect
- Add GSheets adapter
- Add drop-in replacement for
gsheets://
dialect
- Initial release