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...
A blog about all things data and data processing issues and interests. SQL, NoSQL, flexible schema, scale-up, scale-out, transactions, high availability.