0.15.4

Canner/WrenAI0.15.4Mar 4, 2025by wwwy3y3

AI Summary

Adds support for querying BigQuery external tables and introduces LLM-based evaluation metrics. The service layer was also consolidated and refined.

Key Highlights

  • Support querying BigQuery external table
  • LLM-based evaluation metrics for SQL generation
  • Refactored SQL Pairs Service

New Features

  • Querying BigQuery external table
  • LLM-based evaluation metrics for SQL generation

Full Release Notes

## Features
* Support querying BigQuery external table by [@goldmedal](https://github.com/goldmedal) in https://github.com/Canner/wren-engine/pull/1055

## Chores and fixes
* fix(wren-ui): sql server ssl property default value replace with initial value by @andreashimin in https://github.com/Canner/WrenAI/pull/1338
* fix(wren-ui): encode pwd when building connection url  by @onlyjackfrost in https://github.com/Canner/WrenAI/pull/1281
* chore(wren-ai-service): fix qdrant indexing by @cyyeh in https://github.com/Canner/WrenAI/pull/1323
* fix(bigquery): fix nested column grouping logic by [@onlyjackfrost](https://github.com/onlyjackfrost) in https://github.com/Canner/wren-engine/pull/1030
* fix(model): bigquery, avoid fetching duplicated fields when fetching it by [@sebastien-boulle](https://github.com/sebastien-boulle) in https://github.com/Canner/wren-engine/pull/1054
* fix(bigquery): correctly format the scientific notation decimal by [@douenergy](https://github.com/douenergy) in https://github.com/Canner/wren-engine/pull/1068
* fix(wren-ai-service): add BigQuery configuration settings and improve logging by @paopa in https://github.com/Canner/WrenAI/pull/1258
* chore(wren-ai-service): fix config examples by @cyyeh in https://github.com/Canner/WrenAI/pull/1267
* feat(wren-ai-service): Consolidate SQL Pairs Service and Remove Redundant Code by @paopa in https://github.com/Canner/WrenAI/pull/1268
* feat(wren-ai-service): Refactor Semantics Description Pipeline with Output Filtering and Request Model Updates by @paopa in https://github.com/Canner/WrenAI/pull/1272
* chore(wren-ai-service): update litellm version by @cyyeh in https://github.com/Canner/WrenAI/pull/1275
* chore(wren-ai-service): allow adding alias to llm by @cyyeh in https://github.com/Canner/WrenAI/pull/1276
* chore(wren-ai-service): update config.yaml examples by @cyyeh in https://github.com/Canner/WrenAI/pull/1277
* feat(wren-ai-service): change sql through reasoning by @cyyeh in https://github.com/Canner/WrenAI/pull/1273
* chore(wren-ai-service): add readme for config example files by @cyyeh in https://github.com/Canner/WrenAI/pull/1295
* feat(wren-ai-service): Add a few properties in Prediction Result for Evaluation by @paopa in https://github.com/Canner/WrenAI/pull/1297
* chore(wren-ai-service): support deleting sql pairs using project id by @cyyeh in https://github.com/Canner/WrenAI/pull/1307
* chore(wren-ai-service): fix data curation app by @imAsterSun in https://github.com/Canner/WrenAI/pull/1316
* chore(wren-ai-service): allow retrieving sql pairs while retrieving historical questions by @cyyeh in https://github.com/Canner/WrenAI/pull/1318
* chore(wren-ai-service): add bird eval dataset by @cyyeh in https://github.com/Canner/WrenAI/pull/1321
* feat(wren-ai-service): Add LLM-based evaluation metrics for SQL generation by @paopa in https://github.com/Canner/WrenAI/pull/1303
* chore(wren-ai-service): allow regenerate sql using retrieved tables by @cyyeh in https://github.com/Canner/WrenAI/pull/1324
* fix(wren-ai-service): Optimize SQL Data Preprocessing with Progressive Data Reduction by @paopa in https://github.com/Canner/WrenAI/pull/1331
* chore(wren-ui): update release image flow and revert package.json version by @onlyjackfrost in https://github.com/Canner/WrenAI/pull/1350
* chore(wren-ai-service): Exclude 'alias' from model parameters in LLM and Embedder processors by @paopa in https://github.com/Canner/WrenAI/pull/1353

## Security updates
* chore(deps): bump undici from 5.28.4 to 5.28.5 in /wren-ui in the npm_and_yarn group across 1 directory by @dependabot in https://github.com/Canner/WrenAI/pull/1204


**Full Changelog**: https://github.com/Canner/WrenAI/compare/0.15.3...0.15.4