Back to browse
GitHub Repository

Make predictions over relational data with more power and scale than LLMs, exposed over a simple query language.

3 starsPython

RelativeDB – OSS query engine for relational foundation models

by scottcodie·Jul 27, 2026·3 points·0 comments

AI Analysis

●●●BangerBig BrainZero to One

SQL-like syntax for foundation models beats XGBoost with minimal feature engineering.

Strengths
  • RelQL extends SQL with PREDICT and OVER clauses for native temporal forecasting.
  • Leverages Stanford's Relational Transformer architecture for zero-shot relational learning.
  • Automatically discovers subgraphs across 10-100 tables without manual feature engineering.
Weaknesses
  • Pretrained checkpoints are large (342MB fp32), potentially limiting edge deployment.
  • Niche academic origin may slow enterprise adoption compared to established MLOps tools.
Category
Target Audience

Data scientists and ML engineers working with structured relational data.

Similar To

XGBoost · Featuretools · H2O.ai

Post Description

Structured data could be the next big frontier for foundation models.

RelativeDB is an open source query engine built around the Relational Transformer architecture, developed by Stanford’s Tabular and Relational (STAR) Project. These models can adapt to new databases and prediction tasks using relatively little labeled context.

With some of my experiments, the results have been remarkable. On some tasks, RelativeDB can outperform XGBoost with only a small amount of relational context and no manual feature engineering.

So RelativeDB turns relational foundation models into something you can query (like this customer churn query):

``` PREDICT NOT EXISTS(orders.*) OVER (90 DAYS FOLLOWING) FROM customers ```

The engine finds the relevant context across the related tables and returns a prediction. The goal is to make questions like churn, demand forecasting, fraud detection, and recommendations feel more like database queries than bespoke ML projects.

Longer term, I think the optimizer should be able to choose between relational foundation models, fine-tuned models, and conventional approaches such as XGBoost depending on the query (how much graph-like context is needed vs just tabular features). Bridging ML to LLMs in a sane way.

I think there are markets for quantitive finance and utilizing emerging context graphs.

The project is early, and I would especially appreciate feedback on the query language and execution model.

RelativeDB: https://github.com/RelativeDB/RelQL Stanford RT-J: https://star-project.stanford.edu/rt-j/

Similar Projects