Skip to content

This release adds 1 notable feature for engineering teams evaluating rollout.

✓ No known CVEs patched
Read the diff → Tool health → What is this tool? →

✓ No known CVEs patched in this version

Topics

semantic-layer

Summary

AI summary

Fixed undefined column errors on case‑folding databases and improved psql ‘\d’ support in the Postgres facade.

Full changelog

SLayer 0.9.4

A bug-fix release for people running SLayer against case-folding databases and browsing the Postgres facade from psql.

Valid SQL on Postgres, Snowflake, and other case-folding databases

Some queries that ran fine on SQLite failed on Postgres and Snowflake with an "undefined column" error, because SLayer only compiled the SQL without executing it and the defect stayed hidden until the query actually ran.

Two causes are fixed. Mixed-case column and table names are now quoted, so databases that fold unquoted names (Postgres and Redshift fold to lowercase, Snowflake and Oracle to uppercase) no longer look for a name that does not exist. And sorting by a column you did not project (for example ordering by a renamed or joined column) now emits a reference the database can resolve. When an ORDER BY column genuinely cannot be resolved in scope - such as ordering by a joined column that was not projected - you now get a clear error explaining the problem instead of SQL that fails at the database.

Better psql support in the Postgres facade

If you connect to the Postgres facade with psql, \d <table> now works. The facade answers the additional catalog lookups psql issues when describing a table, so you can inspect columns and structure interactively as you would against a real Postgres server.

Weekly OSS security release digest.

The CVE patches and breaking changes that affected production tools this week. One email, every Sunday.

No spam, unsubscribe anytime.

Share this release

Track SLayer, a semantic layer maintained by your agent

Get notified when new releases ship.

Sign up free

About SLayer, a semantic layer maintained by your agent

All releases →

Related context

Earlier breaking changes

  • v0.7.1 Changes `search()` response to a single flat `results` list capped by `max_results`, removing separate `memories`, `example_queries`, and `entities` buckets.
  • v0.7.1 Changes `search()` to return a single flat `results` list, removing per‑bucket caps.
  • v0.6.3 Datasource names now reject dots, slashes, nulls, empty/whitespace; existing names containing '.' will fail validation on upgrade.
  • v0.6.0 recall_memories surface entirely removed with no deprecation shim.
  • v0.5.1 Two-mode reference semantics enforced: SQL mode accepts arbitrary SQL; DSL mode strictly resolves identifiers.

Beta — feedback welcome: [email protected]