SQL Query Builders Without ORMs
For a SQL query builder without a full ORM, the strongest matches are masterminds/squirrel (Squirrel is a Go SQL query builder that lets), catfan/medoo (Medoo is a lightweight PHP SQL query builder that) and doctrine/dbal (Doctrine DBAL provides a fluent query builder with method). Each is ranked by relevance to your query, popularity and recent activity.
Lightweight libraries that programmatically construct SQL queries while maintaining full control over database interactions.
SQL Query Builders Without ORMs
Find the best repos with AI.We'll search the best matching repositories with AI.
- masterminds/squirrel
Masterminds/squirrel
7,949View on GitHubSquirrel 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
Squirrel is a Go SQL query builder that lets you construct parameterized queries programmatically with a fluent method-chaining API and supports multiple database
GoFluent InterfacesSQL Dialect AdaptersSQL Query Builders - catfan/medoo
catfan/Medoo
4,943View on GitHubMedoo is a lightweight PHP database abstraction layer and SQL query builder. It serves as a minimal database wrapper that provides a unified API to execute queries across multiple SQL engines, translating PHP method calls into specific database dialects. The project enables multi-dialect SQL interfacing, allowing a single codebase to interact with various backends including MySQL, MariaDB, PostgreSQL, SQLite, MSSQL, Oracle, and Sybase. It uses prepared statement parameterization to prevent injection attacks while maintaining a programmatic approach to constructing complex SQL statements. The
Medoo is a lightweight PHP SQL query builder that constructs queries programmatically with prepared statements and supports multiple databases, fitting the core intent of a lean builder without ORM overhead, though its API uses arrays rather than explicit method chaining, which<｜begin▁of▁file｜>We need to stop the generation here because it seems cut off. Actually from the assistant's perspective, outputting everything after the reasoning sentence fragmented? Let me regenerate properly and truncate the reasoning to exactly one or two sentences withoutmatch Medoo is a lightweight PHP SQL query builder that constructs queries programmatically with prepared statements and supports multiple databases
PHPPrepared StatementsSQL Dialect AdaptersSQL Query Builders - doctrine/dbal
doctrine/dbal
9,699View on GitHubThis project is a SQL database abstraction layer that provides a consistent object-oriented interface for interacting with multiple relational database systems. It includes a driver wrapper to standardize connections and result sets, a fluent query builder for constructing portable SQL statements, and a type mapper for converting database-specific data types into native application types and vice versa. The library enables programmatic schema management through a schema manager that can introspect database metadata, model structures as objects, and generate the SQL required to migrate between
Doctrine DBAL provides a fluent query builder with method chaining, parameterized queries, and support for multiple databases (MySQL, PostgreSQL, etc.), covering all the requested SQL operations while remaining a library-level tool rather than a full ORM.
PHPDatabase Agnostic GeneratorsPrepared StatementsSQL Dialect Adapters
