Skip to main content

Posts

Showing posts from October, 2026

The English WHERE Clause: Plain-English Filters in Couchbase SQL++ using Jev Model

Originally, SQL was SEQUEL - Structured English Query Language.  Couchbase supports NL2SQL natively , but the WHERE clause is only supports language defined filters - range, semantic  search and text search.  Exploiting Typesafe.ai's Jev models, we now show how you can easily add plain old English filters into SQL++ WHERE clause.  This is a progress towards the original vision of making data processing natural and human. DuckDB showed Jev() functions and DataBricks added ai_decide() functions. For Couchbase, this article will show two function families, jev() and cb_decide(), can be easily added to Couchbase and let a Couchbase query judge documents and return typed answers with the Couchbase Server ! This method will show you how to exploit any model, not just Jev in Couchbase SQL++. This article explains the sample UDFs and SQL++ published in the cb-jev-functions .   In fact, Couchbase users have been doing it since 2018 to interact with external sys...