{"library":"shillelagh","type":"library","category":null,"description":"Shillelagh is a Python library and CLI tool that enables users to query various data sources, including APIs, files, and in-memory objects, using standard SQL. It implements the Python DB API 2.0 specification based on SQLite (using the APSW library) and also provides a SQLAlchemy dialect. The library is actively maintained with frequent releases, with the current version being 1.4.4.","language":"python","status":"active","version":"1.4.4","tags":["sql","api","data access","sqlite","virtual tables","db-api-2.0","sqlalchemy"],"install":[{"cmd":"pip install shillelagh","imports":["from shillelagh.backends.apsw.db import connect","from sqlalchemy.engine import create_engine; engine = create_engine('shillelagh://')"]},{"cmd":"pip install 'shillelagh[multicorn]'","imports":[]}],"homepage":null,"github":"https://github.com/betodealmeida/shillelagh","docs":"https://shillelagh.readthedocs.io/","changelog":null,"pypi":"https://pypi.org/project/shillelagh/","npm":null,"openapi_spec":null,"status_page":null,"smithery":null,"compatibility":{"summary":{"python_range":"3.10–3.9","success_rate":100,"avg_install_s":5.4,"avg_import_s":1.57,"wheel_type":"wheel"},"url":"https://checklist.day/v1/registry/shillelagh/compatibility"},"provenance":{"verified_status":"passing","verified_at":"Sun Jun 28","last_verified":"Sun Jun 28","next_check":"Tue Jul 28","install_tag":null}}