SQL And PartiQL - CefasDB Docs

Documentation excerpt

CefasDB includes a SQL parser, planner, and executor for operational queries. It is not intended to be a full relational database. It is a pragmatic query surface over the item model and index system.

SELECT INSERT UPDATE DELETE RETURNING on supported mutations PartiQL-style execution through execute-statement

Predicates can include key conditions, scalar comparisons, boolean composition, and supported functions.

The CLI update path can be translated into CefasDB SQL update behavior. This keeps compatibility with expression-based mutation scripts while letting the engine use one mutation path internally.