SeaQL/sea-query
Sea Query
Sea-query is a database abstraction library for Rust that provides a fluent builder pattern for constructing type-safe SQL queries. It functions as a framework for defining and managing database schemas and queries through code, allowing developers to generate syntactically valid statements for multiple database engines without relying on manual string concatenation.
The library distinguishes itself by using an abstract syntax tree to model queries, which enables engine-agnostic transformations and compilation into specific SQL dialects. This architecture supports cross-database portability, allowing a single source of query logic to be compiled for different storage backends while maintaining consistent application behavior.
Beyond query construction, the library includes tools for programmatic schema definition, mapping, and synchronization. It manages database interactions through automated parameter binding to mitigate injection vulnerabilities and provides utilities for transaction control, including support for connection pooling and nested operations.
Features
- Database Engine Abstractions - Acts as a database abstraction layer that decouples application logic from specific SQL engines to enable cross-database portability.
- Fluent Query Builders - Provides a chainable interface for constructing complex query objects incrementally.
- Schema Definition Tools - Provides a programmatic, type-safe framework for defining database table structures and managing schema migrations through code.
- SQL Query Builders - Enables the construction of type-safe and dynamic SQL queries using a fluent builder pattern for multiple database engines.
- SQL Query Building - Provides utilities for constructing complex SQL queries including filtering, joining, sorting, and pagination.
- Multi-Database Support - Compiles a single source of query logic into syntax compatible with multiple database backends.
- Type-Safe Query Builders - Generates type-safe queries using a builder pattern that prevents syntax errors across multiple engines.
- Parameter Bindings - Separates query structures from data values using indexed placeholders to prevent SQL injection vulnerabilities.
- Database-Level Query Parameter Bindings - Manages query parameter bindings by injecting values into expressions automatically to prevent manual indexing errors.
- Cross-Source Querying - Enables writing a single source of query logic that compiles into compatible syntax for multiple database engines.
- Type-Safe Schema Mappings - Uses strongly-typed definitions to ensure consistent naming and reliable references during query construction.
- Schema Definitions - Defines database schemas as abstract syntax trees to manage table structures and relationships programmatically.
- ORM Schema Synchronization - Synchronizes database schemas by generating code entities or applying defined entity models to the database.
- Database Schema Managers - Constructs and serializes database table structures as abstract syntax trees to manage schema definitions programmatically.
- Database Transaction Management - Manages database transactions with support for connection pooling and nested operations using savepoints.
- Fluent Query Construction - Enables programmatic construction of dynamic SQL queries using a fluent interface that handles conditional logic.
- Dialect-Specific SQL Generation - Translates abstract query trees into valid syntax for different database engines at runtime.
- SQL Abstract Syntax Trees - Models queries as structured trees to enable engine-agnostic transformations and compilation into specific SQL dialects.
