0.17.0

Canner/WrenAI0.17.0Mar 20, 2025by wwwy3y3

AI Summary

A major performance update switching to a Rust-based semantic engine to improve processing speed. The release also adds visibility into the SQL generation stages.

Key Highlights

  • Switch to Rust-based semantic engine for better performance
  • Visibility into SQL generation stages (retrieval, reasoning, formulation)
  • Enhanced Question-SQL Pairs accuracy

Breaking Changes

  • Switch to Rust-based semantic engine (with fallback mechanism)

New Features

  • Visibility into SQL generation process
  • Enhanced Question-SQL Pairs feature
  • SQL Functions Support in Query Generation Pipeline

Full Release Notes

## ⚠️ Breaking Changes
- Switch to Rust-based semantic engine for better performance. A fallback mechanism is in place to maintain compatibility with existing SQL queries, but this fallback may be removed in future releases.

## Features
- Add visibility into SQL generation process, showing different stages including retrieval, reasoning, and query formulation by @cyyeh, @wwwy3y3, @andreashimin in #1407, #1388, #1414
- Enhance Question-SQL Pairs feature to improve SQL generation accuracy by @paopa, @fredalai, @cyyeh in #1376, #1418, #1422, #1423, #1424
- Add SQL Functions Support in Query Generation Pipeline by @paopa in #1410
- Use rephrased questions at "save to knowledge" by @fredalai in #1424

## Fixes and Chores
- Add Bird dataset support and enhance configuration documentation by @paopa in #1427
- Update SqlExpansionRequest to support multiple histories by @paopa in #1436
- Fix project ID reference in AI service by @cyyeh in #1437
- Add margin to tag in retrieving UI component by @andreashimin in #1443
- Add ON DELETE action on SQL-pair foreign key constraint by @onlyjackfrost in #1442
- Improve SQL generation instructions and follow-up reasoning by @cyyeh, @paopa in #1407, #1415, #1425, #1432, #1439
- Add GitHub workflow PR tagger for better release management by @onlyjackfrost in #1402
- Add GitHub action to raise release candidate PRs by @onlyjackfrost in #1429, #1441

## Wren Engine Updates
- Fix: Enforcing MySQL utf8mb4 charset in connections by @douenergy in [#1091](https://github.com/Canner/wren-engine/pull/1091)
- Feature: Pushdown the limit of query requests into SQL for improved performance by @goldmedal in [#1082](https://github.com/Canner/wren-engine/pull/1082)


**Full Changelog**: https://github.com/Canner/WrenAI/compare/0.16.0...0.17.0