Blendsql

What's Changed
* `unpack_options()`, adding options argument to MapIngredient by parkervg in https://github.com/parkervg/blendsql/pull/28
* With the release of [skrub 0.2.0](https://github.com/skrub-data/skrub/releases/tag/0.2.0), we can now support python 3.9


**Full Changelog**: https://github.com/parkervg/blendsql/compare/v0.0.20...v0.0.21

What's Changed

https://github.com/parkervg/blendsql/pull/27

On queries like `benchmarks/national_parks/q05.sql`:

sql
SELECT {{ImageCaption('parks::Image')}} as "Image Description" FROM parks LIMIT 1


We apply the `LIMIT` clause (and any other surrounding filters) prior to calling the `ImageCaption` ingredient

Benchmark Results:
Before:
| Task | Average Runtime | Unique Queries |
|:---------------|------------------:|-------------------:|
| financials | 0.0402491 | 7 |
| rugby | 0.323255 | 4 |
| national_parks | 2.07314 | 5 |
| 1966_nba_draft | 0.119926 | 2 |

After:
| Task | Average Runtime | Unique Queries |
|:---------------|------------------:|-------------------:|
| financials | 0.040797 | 7 |
| rugby | 0.319473 | 4 |
| national_parks | 0.865904 | 5 |
| 1966_nba_draft | 0.115434 | 2 |

**Full Changelog**: https://github.com/parkervg/blendsql/compare/v0.0.19...v0.0.20

What's Changed
* `mypy` fixes, using `singledispatch` to route model generation behavior by parkervg in https://github.com/parkervg/blendsql/pull/24
* Feature/infer options arg by parkervg in https://github.com/parkervg/blendsql/pull/25
* `TransformersVisionModel`, `ImageCaption` Ingredient, `default_model` behavior by parkervg and zvs08 in https://github.com/parkervg/blendsql/pull/26

Example demonstrating new features:

python
ingredients = {ImageCaption.from_args(model=vision_model), LLMMap}
res = blend(
query="""
SELECT "Name",
{{ImageCaption('parks::Image')}} as "Image Description",
{{
LLMMap(
question='Size in km2?',
context='parks::Area'
)
}} as "Size in km" FROM parks
WHERE "Location" = 'Alaska'
ORDER BY "Size in km" DESC LIMIT 1
""",
db=db,
default_model=text_model,
ingredients=ingredients,
)

**Full Changelog**: https://github.com/parkervg/blendsql/compare/v0.0.18...v0.0.19

What's Changed
* Improve Logging by parkervg in https://github.com/parkervg/blendsql/pull/17
* Joiner heuristic integration by zvs08 in https://github.com/parkervg/blendsql/pull/18
* Adding `LazyTables`, Only Materializing CTEs if we use them by parkervg in https://github.com/parkervg/blendsql/pull/19
* Adding `benchmark/` directory by parkervg in https://github.com/parkervg/blendsql/pull/20
* Adding DuckDB + Pandas Integrations by parkervg in https://github.com/parkervg/blendsql/pull/23

New Contributors
* zvs08 made their first contribution in https://github.com/parkervg/blendsql/pull/18

**Full Changelog**: https://github.com/parkervg/blendsql/compare/v0.0.17...v0.0.18

What's Changed
- Swapped from Guidance to [Outlines](https://github.com/outlines-dev/outlines) for constrained decoding functionality (https://github.com/parkervg/blendsql/pull/15)
- Support for Ollama models! 🎉 (16d0c68da3ddc636d47c4db7a00e85caa9401303)
- Since these aren't directly supported by Outlines, we treat them as a `RemoteModel` (8b16767f59cf41a3fb22bc1b7e07cb1937f0ecb2) and use a helper function `return_ollama_response()` to account for the different inference pattern (40df25580854d57042c3bb19658f969439ab764e)
- Improved documentation (https://github.com/parkervg/blendsql/pull/15)
- Simplified the introductory example in the README (1ead608738a58a3004b93032ea2655bf0605dae5)
- Fixed a weird pattern in `Program` where `model` was being referenced via a class attribute; made this an explicit argument (ccf0ecf6795f19c25e1460898b0e4270c997f230)

Full Changelog: https://github.com/parkervg/blendsql/compare/v0.0.15...v0.0.17

What's Changed
- Support for PostgreSQL! 🎉 (c027388)
- Enabled via `CREATE TEMP TABLE` abstraction and `Database` class built off sqlalchemy (85418e2)
- LlamaCppLLM class (2283526)
- Renamed `blendsql.py` to `blend.py' (670d00e)
- More test cases (9d19579)

Full Changelog: https://github.com/parkervg/blendsql/compare/v0.0.141...v0.0.15