OFFICIAL JEV4PG PROJECT GUIDE

JEV meaning.
PostgreSQL structure.

jev4pg is an open-source query framework built around JEV and PostgreSQL. This is its official project guide. It combines natural language to SQL with typed JEV operators for text filtering, extraction, ranking and verification. PostgreSQL handles joins, calculations and transactions; JEV evaluates questions about meaning.

By the jev4pg project · Updated 4 October 2026 · Apache 2.0

Three capabilities, different jobs.

CapabilityWhat you provideWhat you inspect
Natural language to SQLA question and the authorized data catalog.A generated SQL query, its interpretation and result. Review or correct the plan before execution.
Semantic SQLRows of text and explicit semantic questions, alongside ordinary SQL filters.Typed decisions, source evidence and execution status. Exact joins and arithmetic stay in SQL.
Probability embeddings (native preview)A fixed basis of named questions and answer categories, used consistently across records.All answer distributions, a flattened vector and compatible local distance comparisons.

Independent semantic work runs concurrently within configured limits. Questions sharing context can be batched. Compatible observations can be reused when decision thresholds change, without treating skipped work as a false answer.

Implementation: natural-language queries · operator reference · native stage plans

A question you can reproduce.

“For each supplier, show the total quantity delivered, largest total first.” The project's deliveries tutorial records this generated query:

SELECT
  SUM("r0"."quantity") AS "result_1",
  "r0"."supplier" AS "result_2"
FROM "deliveries" AS "r0"
GROUP BY "r0"."supplier"
ORDER BY SUM("r0"."quantity") DESC NULLS LAST;

The tutorial data returns Birch: 36, Aster: 30, Cedar: 8. These totals come from SQL aggregation. They are an example result, not a claim that arbitrary natural-language requests are always interpreted correctly.

Run the tutorial and inspect its data · See recorded queries and results

A native PostgreSQL framework, centered on JEV.

The native development preview places Rust semantic operators inside PostgreSQL 17. Independent JEV stages can run in parallel, while dependent stages wait for their required evidence. PostgreSQL performs relational joins and aggregation; the model evaluates the semantic questions.

The framework retains compatible answer probabilities for reuse when decision thresholds change. Its explainable embeddings use named questions and answer distributions, so each coordinate has a defined meaning. The stable workspace and native preview have separate deployment paths.

Native installation · Parallel native plans · Explainable embeddings

Every coordinate has a named meaning.

The development function jev_native.embed evaluates a fixed question basis for each record. A question can have false/true answers, named categories or rubric levels. Every answer is retained, so one record becomes a question-by-answer probability matrix and a flattened vector.

Illustrative distributions for one support message
QuestionAnswer distribution
Requests action?False 0.20 · True 0.80
Reports resolution?False 0.70 · True 0.30

The resulting vector is [0.20, 0.80, 0.70, 0.30]. These numbers illustrate the representation; they are not measured model confidence. A basis can contain 1–32 independent questions. Missing evaluations remain null with NOT_EVALUATED, rather than becoming zero probability.

jev_native.embedding_distance compares complete embeddings with the same basis, axes and evaluator identity. It uses root mean squared Hellinger distance across questions and performs no model calls. Retrieval quality depends on your question basis and provider; the project does not claim a universal advantage over dense-vector retrieval.

Embedding contract and limitations · Runnable embedding SQL

Combine several kinds of evidence.

These are illustrative application designs, not claims of deployed customer systems. Use schema relationships, domain definitions and explicit review policies for your own data.

Support operations

Evaluate requested action, customer impact and topic independently. Join decisions to account and ticket data, calculate workload in SQL, and retain uncertain cases for review.

Supplier review

Filter delivery dates and quantities exactly, then evaluate incident descriptions against a documented rubric. Aggregate by supplier while retaining the source text behind each judgment.

Incident investigation

Extract typed entities from reports, join them to authorized event records and evaluate separate questions about urgency and affected scope. Merge only after required evidence is available.

Application integration · Text extraction and review · Dependencies and parallel stages

Before you choose jev4pg.

Is jev4pg the JEV model?

No. jev4pg is the PostgreSQL application and operator layer. It uses a configured JEV provider; it does not ship model weights. The provider interface supports TypeSafe, compatible HTTP services and local Python adapters. Hybrid planning also uses an LLM provider. Provider setup.

Does self-hosting keep all inference local?

Only if you configure a suitable local provider. Hosted inference sends the selected context fields to that provider. Attaching PostgreSQL data avoids a bulk copy into another database, but does not by itself make model processing local.

What does “self-developing” mean?

Useful definitions, evidence and corrections can become reviewed, reusable database features. New definitions require review before promotion. It does not mean the database silently rewrites its own application code. Capability boundaries.

What changed with the name?

jev4pg was previously published as JevSDSQL and jevsd-pg. The current website is jev4pg.com and the repository is Sheltercosmo/jev4pg. Legacy commands and database identifiers remain where needed for existing installations.

Related research: semantic queries and AI data systems.

These papers provide context for combining language models with relational queries. They describe separate systems; their results are not jev4pg benchmark results.

jev4pg's documented focus is typed JEV decisions, reusable evidence, and a PostgreSQL-native development path. Follow its operator reference and native plan documentation for implemented behavior.

Explore the JEV and PostgreSQL ecosystem.

These independently maintained projects offer other ways to work with typed decisions and PostgreSQL:

jev4pg combines a natural-language query workspace with semantic operators, reusable evidence and a native development preview. Choose according to where you want decisions to run, your deployment requirements and the evidence you need to inspect.

Choose a deployment.

Stable v0.6.0: web workspace, HTTP API, Python semantic runtime and asynchronous SQL jobs. Development main: the Rust native preview, including probability embeddings, for PostgreSQL 17 on Linux. Native semantic functions can run without the Python service; native maintained features and semantic write review remain on the roadmap.

Start with a release tag for a fixed deployment. For native development, read the compatibility and provider requirements before building.