8 repositorios
Tools that compile raw SQL queries into strongly-typed application code.
Distinct from SQL Generators: Distinct from general SQL generators: focuses on compile-time type safety and mapping SQL to native language primitives rather than just generating SQL scripts.
Explore 8 awesome GitHub repositories matching data & databases · Type-Safe. Refine with filters or upvote what's useful.
sqlc is a SQL compiler and code generator that creates type-safe database client code from raw SQL queries. It transforms SQL statements into typed definitions and functions, eliminating the need for manual row mapping between database results and application structures. The tool ensures compile-time safety by validating SQL queries against the database schema before the application is run. This workflow integrates the database schema directly into the application code, deriving types from the underlying SQL definitions to prevent runtime errors. The system utilizes AST-based query analysis
Compiles raw SQL queries into strongly-typed application code to eliminate manual data mapping.
sqlc is a code generation tool that compiles raw SQL queries into type-safe application code. By analyzing SQL statements against database schema definitions during the build process, it eliminates the need for manual data mapping and prevents runtime type errors. The project functions as a schema-aware generator that translates database column types into native language primitives. It distinguishes itself through a modular, plugin-based architecture that allows for the extension of the generation pipeline to support diverse programming languages and custom frameworks beyond its default capab
Compiles raw SQL queries into type-safe application code to eliminate manual data mapping and runtime errors.
This project is a comprehensive, curated directory of static analysis, linting, and security scanning utilities. It serves as a central resource for developers to discover, compare, and select tools based on specific programming languages, licensing models, and integration requirements. The directory distinguishes itself by providing deep metadata for each listed utility, including community-driven popularity rankings, maintenance status, and deployment methods. By aggregating these tools into a single searchable index, it enables teams to identify solutions for enforcing coding standards, ma
Validates raw SQL queries and automatically generates corresponding language types to ensure type safety.
Sea-ORM is an asynchronous SQL object-relational mapper and database toolkit for mapping relational tables to strongly typed objects. It provides a relational database mapper for performing CRUD operations across MySQL, PostgreSQL, and SQLite, and includes a programmatic dynamic query builder for constructing complex SQL statements. The project distinguishes itself by providing a GraphQL schema generator that transforms database entities into typed schemas with built-in pagination and filters. It also features a dedicated database migration tool for defining and applying versioned schema chan
Uses traits to define data structures and relationships, ensuring type-safe mapping between tables and columns.
Squirrel is a Go database library and SQL query builder that provides a programmatic interface for constructing and executing SQL statements. It enables the creation of queries using a fluent interface to avoid manual string concatenation. The library functions as a SQL dialect generator, producing queries formatted for specific database engines by adjusting placeholders and syntax to match target requirements. This allows for the generation of SQL compatible with multiple different database environments. Beyond query construction, the project covers the execution of generated statements aga
Provides a programmatic interface for assembling SQL queries that are more maintainable than raw strings.
jOOQ is a type-safe SQL query builder for Java that generates code from live database schemas, enabling compile-time validation of SQL syntax and data types. Its core identity is built around a fluent DSL that mirrors SQL structure, a code generator that maps tables, views, and routines to Java objects, and a multi-dialect engine that translates the same DSL into vendor-specific SQL for over 30 databases. The project also includes a SQL parser and transformer for refactoring or dialect conversion, reactive stream integration for non-blocking query execution, and a JDBC proxy diagnostics tool f
Validates SQL syntax and data types at compile time through a fluent Java API that mirrors SQL structure.
ihp es un framework web con tipado fuerte y orquestador de aplicaciones full-stack diseñado para PostgreSQL. Funciona como un framework de renderizado del lado del servidor y un ORM con tipado fuerte que genera automáticamente tipos de registro a partir de esquemas SQL para garantizar la validación de consultas en tiempo de compilación. La plataforma se distingue por verificar el enrutamiento, las consultas a la base de datos y las plantillas en tiempo de compilación para evitar errores en tiempo de ejecución. Implementa interfaces web en tiempo real utilizando WebSockets para la sincronización instantánea de datos y emplea hipermedia impulsada por el servidor para parches parciales del DOM. El framework cubre una amplia gama de capacidades integradas, incluyendo gestión de identidad de usuario con soporte para passkeys y OAuth, una capa completa de almacenamiento de datos con migraciones automatizadas y un sistema integral de renderizado de UI con plantillas HTML con tipado fuerte. También proporciona herramientas integradas para el desarrollo de API JSON, ejecución de tareas en segundo plano de forma asíncrona e integración financiera para pasarelas de pago. Los entornos de producción se gestionan mediante despliegue declarativo con NixOS para una infraestructura reproducible.
Maps the results of raw SQL statements directly into strongly-typed application records.
Drift is a type-safe SQL persistence library and relational mapper that provides a structured way to map database tables to classes and execute SQL queries with build-time validation. It functions as a type-safe query builder and a wrapper for SQLite and PostgreSQL, eliminating manual result set parsing by binding query outputs to native objects. The project distinguishes itself through a build-time code generation system that produces type-safe APIs and validates raw SQL statements against database versions before execution. It features reactive query streaming, which transforms SQL queries
Constructs SQL filters and calculations using type-safe operators and build-time validation.