OriginChainDB docs
reference · feature releases

Feature releases by surface.

One place per query surface to see what the engine supports today, what is in preview, and what changed. The support lists are read from the engine rather than written by hand, and the date they were read is recorded below.

How to read this page.

Two sources feed it, and they answer different questions. They are kept apart on every section below.

  • Current state comes from the engine's own capability endpoint, which publishes a support list per capability family. Several of those lists are generated from the same check the engine runs when it accepts or refuses a configuration, and the engine's tests hold others to what the query surface actually does, failing in both directions: a variant that is advertised but refused fails the build, and so does a variant left on the roadmap that the engine in fact serves. The endpoint carries no dates.
  • History comes from the changelog, which is the only dated record. Each item below links to its entry. Where the changelog has no dated entry for something, it is not listed rather than given an approximate date.

The three columns in each table use the engine's own definitions: supported is implemented and generally available; preview is shipped but deliberately narrow and not yet generally available; roadmap is accepted by the schema but refused by the engine at configuration time, so it is not usable today. A dash means the arm is empty.

how current this is

Support lists were read from the engine's capability endpoint on 2026-09-06. The endpoint publishes 25 capability families; 21 of them describe a query surface and are listed below. The rest describe the deployment - the instruction set of the host CPU, the write topology, the replication mode, and row-level concurrency control - and are not properties of any one surface, so they are not shown here.

Elasticsearch.

A search API shaped like the Elasticsearch REST and Query DSL surface, answered by the same engine as everything else. Elasticsearch overview .

no machine-checked matrix for this surface

The engine's capability endpoint publishes no family for Elasticsearch, so there is no support list here that the engine's tests hold to account. Rather than write one by hand, this section carries only the dated history below and points you at the reference pages, which document the surface as it is built.

What changed, and when.

The changelog records no dated entry for Elasticsearch. Until one exists there is no date to quote, so none is given here. The elasticsearch overview documents what the surface does today.

SQL.

The /sql endpoint and the wire protocols that ride it. This is the surface the capability endpoint covers in most detail. SQL reference .

Capability family Supported today In preview On the roadmap
Joins sql_joins
  • inner_equi
  • outer
  • expression_projection
  • expression_aggregate_argument
  • computed_group_key
  • cross
  • natural · v1.x
  • cross_composed_shapes · v1.x
  • non_equi_on · v1.x
  • disjunctive_on · v1.x
  • having_over_grouped_join · v1.x
  • distinct_aggregate_over_join · v1.x
  • window_with_join · v1.x
  • order_by_qualified_over_grouped_join · v1.x
Common table expressions sql_cte
  • plain
  • recursive
  • chained_recursive · v1.x
  • recursive_union_distinct · v1.x
  • recursive_aggregate_projection · v1.x
  • cte_column_list · v1.x
Window functions sql_window_functions
  • ranking
  • offset
  • aggregates_over
  • frame_clauses
  • named_windows
  • distribution
  • range_value_offsets · v1.x
  • composed_shapes · v1.x
Constraints sql_constraint_kinds
  • primary_key
  • unique
  • foreign_key
  • check
  • foreign_key_cascade · v1.x
  • foreign_key_set_default · v1.x
INSERT ... ON CONFLICT sql_insert_on_conflict
  • values_pk_or_unique_target
Materialized view refresh sql_materialized_view_refresh_modes
  • on_demand
  • incremental_filter
  • incremental_aggregate
  • incremental_aggregate_default_on · v1.x
Isolation levels sql_isolation_levels
  • read_committed (default)
  • snapshot_isolation · preview
  • serializable · preview
Triggers sql_trigger_kinds
  • before_after
  • instead_of · v1.x Phase C
Stored procedure languages sql_procedure_languages
  • sql_only
  • plpgsql_lite
  • wasm · v1.x Phase C 4-6 months
User-defined function languages sql_udf_languages
  • sql
  • wasm · v1.x Phase C 4-6 months
PostgreSQL wire compatibility postgres_wire
  • wire_protocol
  • isolation
  • auth
  • tls
  • types
  • error_mapping
  • binary_bind_params · v1.x
  • copy_protocol · v1.x
  • jsonb_column_type · v1.x
  • multi_dimensional_arrays · v1.x
MySQL wire compatibility mysql_wire_dialect
  • ast_translator
  • protocol
  • prepared_statement_projection_typing · v1.x
TDS wire compatibility mssql_tds_dialect
  • tsql_ast_translator
  • isolation
  • tls
  • commercial_driver_interop_verification · v1.x

What changed, and when.

  • v1.2 2026-06-08

    Materialized views with on-demand refresh. Foreign-key and CHECK constraints, with NoAction, Restrict and SetNull as the on-delete actions. The join cap moved from 5 tables to 32.

  • v1.0 2026-05-02

    GROUP BY with COUNT, SUM, AVG, MIN and MAX; INNER and LEFT, RIGHT and FULL OUTER joins; HAVING filters.

Graph.

Relationship traversal and graph embeddings. The capability endpoint publishes families for the embedding side only. Graph reference .

Capability family Supported today In preview On the roadmap
Embedding algorithms graph_embedding_algos
  • node2vec
  • graphsage
Embedding aggregators graph_embedding_aggregators
  • mean
  • max_pool
  • lstm
  • trained_aggregators · v1.x

What changed, and when.

  • v1.2 2026-06-08

    GraphSAGE attribute-aware node embeddings, with Mean, MaxPool and LSTM aggregators. Cypher v3 closed CALL subqueries, nested FOREACH, list comprehensions, MERGE, DELETE, CREATE relation and multi-hop undirected matches.

  • v1.0 2026-05-02

    Forward and reverse one-hop neighbours, breadth-first search to a configurable maximum depth, path reachability, and weighted shortest path by Dijkstra with a caller-supplied weight function.

Vector.

Approximate nearest-neighbour search: which index kinds exist, how vectors are compressed, and where an index lives. Vector reference .

Capability family Supported today In preview On the roadmap
Index kinds index_kinds
  • hnsw
  • ivf
  • ivf_pq
Quantization quantization
  • none
  • scalar
  • binary
  • pq
Index residency index_residency
  • ram
  • disk
  • hybrid · Q4 2026

What changed, and when.

  • v1.2 2026-06-08

    IVF and IVF-PQ indexes landed end to end. Binary quantization and PQ quantization attach to HNSW or IVF as separate index kinds, so the recall and memory trade-off is chosen per collection.

  • v1.0 2026-05-02

    HNSW with cosine, dot and L2 metrics, filtered topk by metadata equality, and f32 SIMD distance kernels.

Natural language.

The /ask endpoint, which compiles a natural-language question into a query plan. Ask reference .

no machine-checked matrix for this surface

The engine's capability endpoint publishes no family for Natural language, so there is no support list here that the engine's tests hold to account. Rather than write one by hand, this section carries only the dated history below and points you at the reference pages, which document the surface as it is built.

What changed, and when.

  • v0.10 2026-04-22

    Every /ask call compiles in the same region as the tenant's instance, with credentials scoped per instance and a scope locked to a single model identifier. Repeated calls over the same catalog pay the cached-read rate on the schema prompt.

  • v0.7 2026-02-12

    The plan cache spills to disk, so a cold start reloads hot plans instead of recompiling them.

  • v0.5 2025-12-18

    The natural-language to query-plan compiler shipped in the first release, alongside HTTP ingress and the row-keyed store.

Full-text.

Ranked text search. The capability endpoint publishes the per-field analysis knobs: tokenizer, lemmatizer and geospatial index kind. Full-text reference .

Capability family Supported today In preview On the roadmap
Tokenizers fts_tokenizer_kinds
  • uax29
  • icu
Lemmatizers fts_lemmatizers
  • none
  • dictionary_english
  • dictionary_spanish
  • dictionary_french
  • dictionary_german
  • dictionary_italian
  • dictionary_portuguese
  • dictionary_russian
  • dictionary_dutch
  • dictionary_swedish
Geospatial index kinds geo_index_kinds
  • none
  • r_tree
  • s2 · Q1 2027

What changed, and when.

  • v1.2 2026-06-08

    Lemmatization for nine languages - English, Spanish, French, German, Italian, Portuguese, Russian, Dutch and Swedish - reducing inflected forms to a dictionary-backed lemma. ICU and geo tokenizers shipped alongside.

  • v1.0 2026-05-02

    BM25 ranking at the Lucene defaults, phrase queries by position-list intersection, the UAX #29 Unicode tokenizer, and Snowball stemming for 18 languages.

What this page does not cover.

The gaps are worth stating, because an absence here means an absence in the sources, not a judgement about the surface.

  • Graph traversal and graph algorithms. The capability endpoint publishes families for graph embeddings only. Traversal, path finding and the algorithm set are documented on the graph reference, and the dated entries above cover what the changelog recorded for them.
  • Query-side full-text features. The endpoint publishes the per-field analysis knobs - tokenizer, lemmatizer, geospatial index kind - not the query operators. Those are on the full-text reference.
  • Per-family detail. Each family carries engineering notes and stated limitations that this page does not reproduce, because a paraphrase of them here is exactly the hand-maintained text this page exists to replace. Read the capability endpoint on your own instance for the full text.
  • Anything undated. A capability can appear as supported above with no entry under "what changed" - that means the changelog has no dated record of it, not that it landed recently.

PostgreSQL, MySQL, Elasticsearch and other product names are trademarks of their respective owners. Naming them here describes wire-protocol and API compatibility only, and implies no affiliation with or endorsement by those projects.