vibesql-executor

SQL query execution engine for VibeSQL database.

Overview

This crate provides the query execution engine that processes SQL statements against the storage layer. It includes query optimization, expression evaluation, and execution of DDL, DML, and query operations.

Features

Query Execution: SELECT with joins, aggregates, window functions, CTEs
DDL Operations: CREATE, ALTER, DROP for all database objects
DML Operations: INSERT, UPDATE, DELETE with constraint validation
Expression Evaluation: Full SQL expression support with type coercion
Query Optimization: Join reordering, predicate pushdown, subquery optimization
Query Plan Cache: LRU cache for compiled query plans
Common Subexpression Elimination: Automatic CSE for repeated expressions
Transaction Support: BEGIN, COMMIT, ROLLBACK, SAVEPOINT
Constraint Validation: PRIMARY KEY, FOREIGN KEY, UNIQUE, CHECK
Triggers: BEFORE/AFTER INSERT/UPDATE/DELETE triggers
Access Control: GRANT/REVOKE privilege checking
Advanced Objects: Functions, procedures, sequences, domains

Usage

Add this to your Cargo.toml:

[dependencies]
vibesql-executor = "0.1"

Basic example:

use vibesql_executor::QueryExecutor;
use vibesql_storage::Database;
use vibesql_catalog::Catalog;

// Create database and executor
let catalog = Catalog::new();
let mut db = Database::new(catalog, Default::default());
let mut executor = QueryExecutor::new(&mut db);

// Execute a query
let result = executor.execute("SELECT * FROM users WHERE age > 18")?;

// Process results
for row in result.rows {
    println!("{:?}", row);
}

Documentation

License

This project is licensed under either of:

Apache License, Version 2.0 (LICENSE-APACHE)
MIT License (LICENSE-MIT)