WrenAI 0.16.0 adds StarRocks—and fixes two quiet ways an agent can hit the wrong boundary
The connector is the headline, but project-scoped secrets and comment-safe query wrapping are the changes operators should regression-test first.
WrenAI 0.16.0 adds StarRocks as a first-class data source, expanding the open-source semantic layer’s connector surface. The same release also changes how Wren resolves project secrets and wraps generated SQL before applying limits—two less visible fixes that matter more than a new connector when one service hosts several projects or lets agents execute model-written queries. WrenAI release notes
The selected project now selects the secret
The project-secret fix is unusually concrete. Wren’s new regression test creates two projects with separate .env files and DuckDB databases, then runs both query --mdl and serve mcp --project from three working-directory positions: the other project, the selected project and outside either project. Every path must resolve the selected project’s database and return its value, not the working directory’s. Project-secret commit
That is an isolation boundary, not merely configuration polish. In a shared deployment, an operator may keep several projects with similarly named environment variables under one Wren home. Before upgrading, teams should reproduce the old failure with harmless test databases; after upgrading, they should run queries and MCP startup from inside and outside each project directory and verify the connection target. The upstream test demonstrates the expected invariant: the selected project controls both profile and secret resolution. Project-secret commit
A SQL comment should not swallow the safety wrapper
The release also moves wrapped subqueries onto separate lines. That prevents a generated trailing -- comment from consuming the closing parenthesis and appended LIMIT. The added ClickHouse tests check both ordinary execution with LIMIT 5 and dry-run execution with LIMIT 0; the release notes list a companion semicolon-before-comment cleanup. Comment-wrapping commit WrenAI release notes
For agent workloads, formatting is executable behavior. A syntactically valid query can become invalid—or lose the limit the caller intended—when it is embedded as a subquery. A focused upgrade test should therefore include line comments, trailing semicolons, multiline SQL and dry runs across every connector in use, rather than validating only clean SELECT statements. The upstream commit directly demonstrates the ClickHouse case; the release notes describe the broader fix but do not claim complete coverage for every connector. Comment-wrapping commit WrenAI release notes
StarRocks support will attract the attention, but the operational lesson is narrower: connector count does not define readiness. Upgrade acceptance should prove that project selection controls credentials and that generated SQL survives the wrapper enforcing execution limits.
sources
comments · 0