shillelagh

• Add cost estimation to all adapters

• Add Datasette adapter

• Remove csv:// and datasette+ prefixes to simply URIs

• Add has_table method to dialects

After almost 1 year of development and 4 of planning, I finally released Shillelagh 1.0. The initial release focused on a stable and flexible API, with a solid adapter (Google Sheets). For the next milestone my plan is to focus on adding more adapters and improving performance.

• 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, and get_metadata functions

• Add REPL command-line utility (shillelagh)

• Remove adapter_args, use only adapter_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 to Date

• 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 from typing_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

• 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