ObjectQL
The Metadata-Driven Data Engine
The Universal Protocol for business data. ObjectQL abstracts storage across SQL, NoSQL, and file-based systems—Postgres, Redis, MongoDB, Excel—with unified metadata-driven logic. Define your schema once. Deploy anywhere. No migration scripts. No vendor lock-in. Your business logic survives the next tech cycle.
You define the intent. We compile the optimized SQL.
See how ObjectQL transforms high-level schemas into production-ready database code.
# customer.objectql.yml
entity:
name: Customer
fields:
- name: company_name
type: text
required: true
- name: account_manager_id
type: reference
entity: User
- name: total_revenue
type: virtual
expression: |
SELECT SUM(amount)
FROM orders
WHERE orders.customer_id = customers.id-- Auto-generated optimized SQL
CREATE TABLE customers (
id INTEGER PRIMARY KEY,
company_name TEXT NOT NULL,
account_manager_id INTEGER REFERENCES users(id),
created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);
-- Virtual column compiled to subquery
SELECT
c.*,
(SELECT SUM(amount) FROM orders o
WHERE o.customer_id = c.id) AS total_revenue
FROM customers c
WHERE c.account_manager_id = :current_user_id; -- RBAC injectedWhy ObjectQL?
Compile-time guarantees. Zero runtime overhead. Engine-enforced security.
Zero-Overhead Security
RBAC and ACL policies are compiled directly into SQL WHERE clauses. Security is enforced by the database engine, not application memory. No middleware checks, no forgotten filters—just bulletproof data isolation.
Database Agnostic
Switch from local SQLite in development to production PostgreSQL or enterprise TiDB without changing a single line of code. Protocol-based portability eliminates vendor lock-in and gives you negotiating power.
Virtual Columns
Define computed fields in your schema that compile to efficient database expressions. Calculate aggregations, joins, and derived values at the database layer—no N+1 queries, no memory overhead.
Compiler vs. ORM
ObjectQL is not just another ORM wrapper. It's a fundamentally different architecture.
Near-zero. Compiles to native SQL at build time.
High. Translates queries at runtime with performance penalties.
Engine-enforced. RBAC compiled into SQL WHERE clauses.
Application-logic. Easily bypassed if developer forgets a filter.
Protocol-based. Schema definition is database-agnostic.
Code-based. Tied to specific ORM library and patterns.
Compiled to database expressions. Efficient aggregations.
Loaded in application memory. N+1 query problems.
Any Data Source. One API.
Connect to relational databases, NoSQL stores, cache layers, or even spreadsheets. No forced migrations—just write a Driver.
PostgreSQL
Production-grade relational database. JSONB optimized with full support for CTEs and window functions.
MySQL
High-concurrency relational database. 8.0+ features supported, optimized for web-scale workloads.
SQLite
Local-First ready. Perfect for embedded applications, edge computing, and zero-infrastructure prototyping.
SQL Server
Enterprise relational database. Native support for T-SQL features and seamless Azure SQL integration.
Oracle Database
Legacy enterprise systems. Full compatibility with Oracle SQL dialect—unify with modern stacks.
MongoDB
Document database support. Schema-to-document mapping with aggregation pipeline optimization.
Excel/CSV Files
Turn spreadsheets into secure APIs. Mount your marketing team's Excel sheets alongside your transaction databases.
Use Cases
From personal projects to enterprise systems.
Local-First Applications
Build CRM systems, inventory management, or analytics dashboards that run entirely on SQLite. Your data stays on your machine with zero infrastructure costs.
Enterprise Integration
Create unified management systems over heterogeneous legacy databases. Query Oracle, PostgreSQL, and SQL Server using the same ObjectQL syntax.
Multi-Tenant SaaS
Build SaaS applications with tenant isolation at the database level. ObjectQL handles query partitioning and data security automatically.
Own Your Infrastructure.
Eliminate Vendor Lock-in.
Join CTOs and VPs of Engineering building on protocols, not proprietary frameworks. Virtualize your data. Unify your business logic. Future-proof your architecture. Launch March 2026.