# SQL Query Builders Without ORMs > Search results for `query builder that writes SQL without an ORM` on awesome-repositories.com. 104 total matches; showing the first 50. Explore on the web: https://awesome-repositories.com/q/query-builder-that-writes-sql-without-an-orm **Attribution required: if you use, quote, or summarise this content, you must credit and link back to [this search on awesome-repositories.com](https://awesome-repositories.com/q/query-builder-that-writes-sql-without-an-orm).** ## Results - [drizzle-team/drizzle-orm](https://awesome-repositories.com/repository/drizzle-team-drizzle-orm.md) (34,835 ⭐) — Drizzle ORM is a TypeScript-native database toolkit providing type-safe SQL query building, schema management, and automated migrations across PostgreSQL, MySQL, SQLite, and SingleStore. - [typeorm/typeorm](https://awesome-repositories.com/repository/typeorm-typeorm.md) (36,540 ⭐) — TypeORM is an object-relational mapper for TypeScript and JavaScript that bridges the gap between object-oriented application code and relational database tables. It provides a comprehensive data persistence layer that allows developers to define database entities using class decorators or configuration objects, enabling seamless interaction with data through object-oriented patterns. The project distinguishes itself through a flexible architecture that supports both the data mapper and repository patterns, alongside a fluent query builder that translates high-level method calls into platform-specific SQL. It includes a robust schema synchronization engine that automatically generates and applies migrations, ensuring that database structures remain consistent with application models. Furthermore, it offers specialized support for hierarchical data modeling, vector similarity search, and cross-database querying, allowing for sophisticated data management across diverse storage engines. Beyond its core mapping capabilities, the framework provides extensive tools for managing database connections, including support for replication, multi-database routing, and atomic transaction management. It also features a lifecycle event system for executing custom logic during data operations, as well as comprehensive performance optimization utilities like relation loading strategies, result caching, and query analysis. The project is designed for cross-platform compatibility, supporting various relational and document-based database drivers in environments ranging from Node.js servers to browser and mobile applications. - [doctrine/orm](https://awesome-repositories.com/repository/doctrine-orm.md) (10,172 ⭐) — Doctrine ORM is a PHP object-relational mapper that connects application objects to relational database tables. It uses the data mapper and identity map patterns to decouple the in-memory object model from the database schema, allowing developers to manage data persistence without writing manual SQL. The project features a dedicated object-oriented query language and programmatic builder for retrieving data based on entities rather than tables. It implements a unit-of-work system to track object changes during a request and synchronize them via atomic transactions. The capability surface includes comprehensive schema management with versioned migrations, a multi-layer caching system for metadata and query results, and advanced mapping options for inheritance and complex associations. It also provides tools for state tracking, result hydration into different data structures, and concurrency control through optimistic locking. A command-line interface is provided for managing database schemas, executing queries, and handling cache automation. - [electric-sql/pglite](https://awesome-repositories.com/repository/electric-sql-pglite.md) (14,707 ⭐) — Pglite is a client-side relational database engine that runs a full-featured PostgreSQL instance directly within browser and Node.js environments. By leveraging WebAssembly, it provides a persistent SQL storage solution that enables complex data management and querying without requiring an external database server. The project distinguishes itself through a reactive SQL data layer that automatically synchronizes user interface components with live query results. It manages database operations using worker threads to prevent main-thread blocking and coordinates access across multiple browser tabs to ensure consistent data views. For performance, it supports binary-snapshot-based initialization, allowing applications to load pre-built database states instantly. The platform includes a comprehensive suite of tools for local-first development, such as virtual file system persistence, transaction management, and support for custom engine extensions. It also provides developer-focused utilities including an interactive SQL terminal, schema inspection, and automated database lifecycle management for testing and development workflows. The project integrates with modern build tools to resolve binary dependencies and provides type-safe query builders and ORM support to bridge application logic with the database. - [sqlalchemy/sqlalchemy](https://awesome-repositories.com/repository/sqlalchemy-sqlalchemy.md) (11,612 ⭐) — SQLAlchemy is a comprehensive Python SQL toolkit and object-relational mapper that provides a full suite of tools for interacting with relational databases. It serves as a foundational layer for database connectivity, offering both a high-level object-oriented interface for data persistence and a programmatic SQL expression language for constructing complex, dialect-agnostic queries. The project distinguishes itself through its sophisticated unit of work persistence, which coordinates atomic transactions and tracks object state changes to minimize redundant database operations. It provides a unified interface for database communication by abstracting vendor-specific behaviors into modular drivers, while simultaneously supporting non-blocking concurrency through an asynchronous execution bridge that integrates seamlessly with modern event-loop-based application environments. Beyond its core mapping and query capabilities, the library includes extensive infrastructure for schema management, including automated generation and runtime reflection of database structures. It also offers robust observability features, such as lifecycle event hooking and connection pool monitoring, which allow developers to intercept operations for logging, caching, or cross-cutting logic. The toolkit supports a wide range of advanced database patterns, including complex inheritance mapping, horizontal data sharding, and fine-grained transaction isolation control. It is designed to be highly extensible, allowing for custom data type definitions, dialect-specific SQL constructs, and specialized function registration to meet diverse application requirements. - [doctrine/dbal](https://awesome-repositories.com/repository/doctrine-dbal.md) (9,699 ⭐) — This 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 different schema versions. It also supports a middleware-based execution pipeline, allowing the interception of database operations for logging or profiling. The system covers a broad range of database capabilities, including portable SQL generation for various dialects, transaction management with support for savepoints and isolation levels, and security primitives such as prepared statements and parameter binding to prevent SQL injection. It also provides utilities for result set normalization and CRUD operation helpers. The project includes a command-line interface for executing raw SQL statements directly against database connections. - [seaql/sea-orm](https://awesome-repositories.com/repository/seaql-sea-orm.md) (9,410 ⭐) — 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 changes. The toolkit covers broad capability areas including relational data modeling and schema management, where it supports the automatic generation of entities from existing database schemas. It further provides advanced query building features such as aggregate value computation, partial model projection, and linked entity fetching, all executed within non-blocking asynchronous runtimes. The project includes a command-line interface for database entity generation and GraphQL server bootstrapping. - [go-gorm/gorm](https://awesome-repositories.com/repository/go-gorm-gorm.md) (39,798 ⭐) — GORM is a developer-focused object-relational mapping library for Go that provides a comprehensive data persistence framework. It serves as a database access layer, allowing developers to map application structures to database tables and perform CRUD operations using a fluent, type-safe query builder instead of writing raw SQL. The library distinguishes itself through its association-aware persistence, which automatically tracks and synchronizes complex entity relationships during database operations. It utilizes a driver-agnostic interface to maintain consistent behavior across various storage engines and employs a reflection-based system to map programming language types to database schemas. Developers can further customize behavior using a callback-based hook system that executes logic at specific points in the operation lifecycle. Beyond core mapping, the project provides robust support for transaction management, connection pooling, and automated schema migrations. It handles complex relational modeling, including one-to-one, one-to-many, and many-to-many associations, while offering advanced features like eager loading, soft deletes, and conflict resolution strategies for upsert operations. The framework is designed for integration into Go applications, providing a unified interface for managing database connectivity and transactional integrity. - [tooljet/tooljet](https://awesome-repositories.com/repository/tooljet-tooljet.md) (38,027 ⭐) — ToolJet is a low-code development platform designed for building and deploying internal business applications. It provides a visual interface where users can drag and drop components to design layouts, connect to various data sources, and execute custom logic. The platform is built on a containerized architecture, ensuring that applications remain portable and consistent across different cloud and server environments. The platform distinguishes itself through integrated artificial intelligence capabilities that assist in the generation of user interfaces, database schemas, and data queries from natural language requirements. Beyond interface design, it includes a backend orchestration engine that automates complex business processes by chaining together API calls, database operations, and conditional logic. Developers can also manage the entire application lifecycle, including version control, multi-environment deployments, and granular role-based access security. The system supports a broad range of operational needs, including built-in relational database management, external service integrations, and observability tools for monitoring performance. It also offers mechanisms for embedding interactive tools into third-party websites and managing user authentication through identity provider synchronization. The platform is designed for containerized deployment and provides comprehensive documentation for installation, infrastructure configuration, and version upgrades. - [sequelize/sequelize](https://awesome-repositories.com/repository/sequelize-sequelize.md) (30,349 ⭐) — Sequelize is an object-relational mapping library that provides a unified interface for managing relational data through code. By implementing the Active Record pattern, it maps database tables to application objects, allowing developers to perform standard create, read, update, and delete operations using high-level method calls. The library abstracts complex database interactions by translating these calls into optimized, engine-specific SQL statements, ensuring consistent behavior across different database systems. The project distinguishes itself through a comprehensive suite of tools for managing relational complexity and data integrity. It features a robust association system that supports one-to-one, one-to-many, and many-to-many relationships, including polymorphic associations and nested join mapping. To maintain consistency during complex operations, it includes an asynchronous transaction coordinator and a lifecycle management framework that triggers custom logic through hooks and validation rules. Furthermore, it provides a schema synchronization engine that aligns application model definitions with the underlying database structure, supporting versioned migrations to track changes over time. Beyond its core mapping capabilities, the library offers extensive support for database management and performance tuning. This includes connection pooling to manage concurrent requests, read replication for distributed query operations, and query scopes for reusable data retrieval patterns. It also provides native support for TypeScript, allowing for type-safe data definitions and model configurations. The library is designed for modular integration and includes utilities for query logging, custom data type definitions, and soft deletion. - [laravel/laravel](https://awesome-repositories.com/repository/laravel-laravel.md) (84,489 ⭐) — Laravel is a comprehensive full-stack web framework designed for building scalable server-side applications. It provides an integrated development environment that centers on an object-relational mapper for database abstraction, a robust routing system, and a sophisticated service container for dependency injection. The framework is built to handle complex application requirements through a modular architecture that emphasizes convention over configuration. What distinguishes Laravel is its deep integration of background processing and event-driven communication. It features a task queue orchestrator that manages asynchronous job execution, retries, and worker lifecycles, allowing developers to offload resource-intensive operations from the main request cycle. This is complemented by an event-driven observer pattern that decouples application logic, enabling components to trigger and listen for asynchronous events across the system. The framework also provides a complete suite of tools for maintaining data integrity and application reliability. This includes a fluent schema migration system for version-controlled database evolution, a layered middleware pipeline for intercepting HTTP requests, and extensive testing utilities that support everything from database state assertions to simulated HTTP request cycles. These features are supported by a command-line interface that facilitates scaffolding, database management, and test suite execution. - [laravel/framework](https://awesome-repositories.com/repository/laravel-framework.md) (34,774 ⭐) — This project is a full-stack web framework that provides a comprehensive environment for building server-side applications. It utilizes a model-view-controller architecture to separate application logic into distinct layers for data management, user interface presentation, and request handling. The platform manages the entire request-response lifecycle, including security, session handling, and background task processing, while using an object-relational mapping layer to translate database records into programmable objects. The framework distinguishes itself through a central service container that manages class instantiation and dependency resolution to decouple application components. It facilitates rapid development by providing pre-built components for common tasks such as authentication and database management. Developers interact with databases through a fluent query builder abstraction and manage schema changes through version-controlled code files, ensuring consistency across environments. The system architecture is built around a route-based request dispatcher and a middleware pipeline that filters incoming data before it reaches core logic. It includes a template engine that compiles server-side views into plain code for execution, and an event-driven observer pattern that allows components to communicate without direct coupling. Modular service providers handle the bootstrapping of application services during the startup phase. - [ukrbublik/react-awesome-query-builder](https://awesome-repositories.com/repository/ukrbublik-react-awesome-query-builder.md) (2,257 ⭐) — User-friendly query builder for React - [gogf/gf](https://awesome-repositories.com/repository/gogf-gf.md) (13,190 ⭐) — GF is a comprehensive Go application toolkit and web framework. It provides a set of libraries and tools for building scalable web applications, APIs, and enterprise-level software. The project features a driver-agnostic SQL database toolkit with a query builder and object mapper, alongside a dedicated framework for creating structured command line interfaces. It includes a project scaffolding tool to bootstrap application structures and automate development workflows. The toolkit covers several broader capability areas, including concurrent data management with thread-safe collections, cryptographic operations for security, and a stack-aware error handling system. It also provides utilities for background task scheduling, adapter-based configuration management, and local service orchestration for containerized infrastructure. - [avelino/awesome-go](https://awesome-repositories.com/repository/avelino-awesome-go.md) (175,576 ⭐) — This project serves as a comprehensive language ecosystem index, functioning as a centralized, community-curated directory for the Go programming language. It organizes a vast landscape of software components, libraries, and development tools into a structured, navigable hierarchy, enabling developers to efficiently discover resources tailored to specific functional domains. The repository distinguishes itself through a decentralized contribution model, where community-driven updates ensure the index remains current with the rapidly evolving software landscape. Beyond simple resource listing, it acts as a technical knowledge repository, aggregating professional literature, style guides, and best practices to support developer onboarding and professional growth across the entire software development lifecycle. The directory covers a broad capability surface, including essential utilities for distributed systems engineering, application security, data processing, and development productivity. It provides access to specialized tools for database management, web framework integration, testing, and build automation, alongside educational materials that help developers master language-specific architectural patterns. The project is maintained as a static resource aggregation, providing a holistic view of external links and documentation to orient developers within the Go ecosystem. - [metabase/metabase](https://awesome-repositories.com/repository/metabase-metabase.md) (47,696 ⭐) — Metabase is a business intelligence platform designed to connect to various storage systems and relational databases for data exploration, visualization, and reporting. It provides a centralized environment where users can build queries through a graphical interface or raw code, transforming raw information into interactive dashboards and charts. The platform is built to support self-service analytics, allowing non-technical team members to extract insights without requiring deep knowledge of database syntax. The platform distinguishes itself through a metadata-driven modeling layer that abstracts complex database schemas into user-friendly business entities. It includes an automated workflow engine that enables users to trigger external processes and update records directly from the interface, bridging the gap between data analysis and operational action. For organizations requiring external distribution, the software provides an embedded analytics solution that allows secure integration of dashboards into third-party websites and applications, supported by sandboxing to isolate visual components. Beyond core visualization, the system incorporates artificial intelligence to assist with query generation and data summarization through natural language interactions. It maintains strict data governance through granular role-based access control, ensuring that permissions are managed consistently across all connected information assets. The platform handles the full lifecycle of data retrieval, including orchestration, caching, and translation of high-level inputs into database-specific syntax. - [abrignoni/dfir-sql-query-repo](https://awesome-repositories.com/repository/abrignoni-dfir-sql-query-repo.md) (0 ⭐) — Collection of SQL queries templates for digital forensics use by platform and application. These queries are templates that should be edited based on the needs of the analyst. Many of these queries will have an accompanying README with a link for more detailed explanations on usage and possible… - [knex/knex](https://awesome-repositories.com/repository/knex-knex.md) (20,300 ⭐) — Knex is a multi-dialect database client that provides a programmatic SQL query builder, a connection pool manager, and a versioned schema migration tool. It enables programmatic database interaction across multiple SQL engines, including PostgreSQL, MySQL, SQLite3, SQL Server, CockroachDB, and Oracle. The project distinguishes itself through a fluent interface for constructing complex SQL statements and a dedicated framework for database seeding. It utilizes specialized dialects to translate generic query representations into database-specific syntax while maintaining a consistent API across different vendors. The platform covers a broad range of relational database management capabilities, including atomic transaction control, schema definition, and relational constraint management. It also provides tools for query result pagination, stream-based processing for large datasets, and the ability to execute stored procedures and raw SQL expressions. A command-line interface is available for automating the execution of database migrations and seeding workflows. - [solidexpert-ltd/ngx-query-builder](https://awesome-repositories.com/repository/solidexpert-ltd-ngx-query-builder.md) (4 ⭐) — A modern Angular (v15+) query builder inspired by jQuery QueryBuilder and rebuilt with standalone components. It ships sensible defaults, rich templating hooks, and full forms support so you can compose visual query editors that match your domain. - [elixir-ecto/ecto](https://awesome-repositories.com/repository/elixir-ecto-ecto.md) (6,471 ⭐) — Ecto is an Elixir database toolkit that maps database rows to Elixir structs and validates data changes through changesets before persistence. It provides a language-integrated query syntax for composing database queries, building them incrementally and securely with compile-time expansion into safe SQL. The toolkit connects to multiple database backends including PostgreSQL, MySQL, MSSQL, SQLite3, ClickHouse, and ETS through a pluggable adapter interface. It supports eager and lazy preloading of associated records to eliminate N+1 query problems, and can store nested data structures as embedded columns within parent tables. Changesets provide a pipeline for casting, validating, and tracking field changes before applying them to the database. Ecto handles full CRUD operations with structured success or error tuples, and includes automated scaffolding for generating database schemas, migrations, and project files. The repository pattern encapsulates database operations behind dedicated modules that return consistent result types. - [encode/orm](https://awesome-repositories.com/repository/encode-orm.md) (1,863 ⭐) — An async ORM. 🗃 - [vincentrussell/sql-to-mongo-db-query-converter](https://awesome-repositories.com/repository/vincentrussell-sql-to-mongo-db-query-converter.md) (318 ⭐) — sql-to-mongo-db-query-converter - [diesel-rs/diesel](https://awesome-repositories.com/repository/diesel-rs-diesel.md) (14,021 ⭐) — This project is a type-safe database toolkit and object-relational mapper designed to enforce structural consistency between database schemas and application code. By leveraging compile-time validation, it ensures that SQL queries and data structures remain synchronized, preventing common errors before the application executes. It provides a comprehensive framework for relational data modeling, allowing developers to define table associations and map database results directly into strongly-typed language objects. The library distinguishes itself through its focus on compile-time safety and automated schema management. It utilizes procedural macros to inspect database tables and generate corresponding code structures, eliminating the need for manual type definitions. Its expression-based query builder allows for the construction of complex, modular SQL statements that are automatically parameterized to mitigate security risks like SQL injection. Furthermore, the system supports extensive customization, enabling developers to register custom functions and operators or extend the query builder interface to accommodate specific database requirements. Beyond its core mapping and validation capabilities, the toolkit provides a full suite of operations for managing data persistence. This includes support for batch insertions, relational joins, upsert operations, and the retrieval of related records. The library also handles the bidirectional transformation of data, automatically mapping application structures to database columns for updates and insertions while inferring return types for query results. Comprehensive documentation and tooling are provided to assist with schema synchronization, ensuring that local code representations remain aligned with the underlying database throughout the development lifecycle. - [usebruno/bruno](https://awesome-repositories.com/repository/usebruno-bruno.md) (44,931 ⭐) — Bruno is a local-first API client designed for building, testing, and managing network requests across a wide range of protocols. By storing all collections and configurations as plain-text files directly on the local filesystem, it enables native version control and offline access, ensuring that project data remains under user control without requiring cloud synchronization. The platform distinguishes itself through a declarative approach to API management, utilizing a domain-specific language to define request parameters and metadata. This architecture supports a robust testing environment where users can execute custom JavaScript-based validation scripts, perform complex assertions, and automate multi-step workflows. Its multi-protocol engine provides a unified interface for interacting with REST, GraphQL, gRPC, WebSocket, and SOAP services, while integrated environment-aware management allows for seamless switching between different deployment configurations. Beyond core request execution, the tool includes a comprehensive suite of utilities for documentation generation, secure authentication, and CI/CD integration. It supports advanced security workflows through various credential management protocols and secret providers, while its command-line interface facilitates parallel execution and data-driven testing within automated pipelines. Users can also leverage AI-driven automation to generate collections and test scripts, further streamlining the development process. - [vincit/objection.js](https://awesome-repositories.com/repository/vincit-objection-js.md) (7,343 ⭐) — Objection.js is an object-relational mapper for Node.js that maps SQL database tables to classes and rows to model instances. It functions as a high-level abstraction layer built on top of the Knex.js query builder to provide structured model definitions and relational data mapping. The project distinguishes itself through its ability to manage complex object graphs, allowing for the persistence and eager-loading of deeply nested related data in single operations. It incorporates a data integrity layer that uses JSON schema validation to verify model instances before they are persisted to the database. The toolset covers broad relational modeling capabilities, including the definition of associations between entities, atomic transaction management, and support for composite primary keys. It also provides utilities for document storage by persisting complex objects as JSON strings within relational columns and uses mixins to share reusable logic across different data models. - [surrealdb/surrealdb](https://awesome-repositories.com/repository/surrealdb-surrealdb.md) (32,397 ⭐) — SurrealDB is a multi-model database engine designed to store and query document, graph, relational, and vector data within a single ACID-compliant platform. It functions as an AI-native data store, integrating vector search, graph traversal, and machine learning model execution directly into its query layer. By providing a unified declarative query language, the platform eliminates the need for external middleware to synchronize data across different storage models. The platform distinguishes itself through its ability to manage agent memory and complex workflows natively. It allows developers to store agent memory, knowledge graphs, and structured data within a single transaction boundary, ensuring consistent state and permissions. Furthermore, the engine supports real-time reactive applications by pushing data updates directly to connected clients through live queries, removing the requirement for external message brokers or polling mechanisms. SurrealDB is built for versatility, operating as a portable database runtime that maintains a consistent interface across embedded, edge, and cloud environments. Its architecture includes a granular, record-level permission model that enforces security and multi-tenant isolation directly at the data layer. The system also features an isolated sandboxing environment for custom extensions, allowing for specialized data processing without compromising system stability or security. The project provides extensive documentation and learning resources, including a structured curriculum and hands-on projects, to assist with onboarding and architectural mastery. It is distributed as a single binary, facilitating deployment across diverse infrastructure ranging from resource-constrained devices to large-scale distributed cloud clusters. - [sarbbottam/write-an-open-source-js-lib](https://awesome-repositories.com/repository/sarbbottam-write-an-open-source-js-lib.md) (185 ⭐) — Reference for How to Write an Open Source JavaScript Library - https://egghead.io/series/how-to-write-an-open-source-javascript-library - [andywang1688/sql-query-mcp](https://awesome-repositories.com/repository/andywang1688-sql-query-mcp.md) (4 ⭐) — A general-purpose MCP server that lets AI work with multiple databases within clear boundaries. - [shekhargulati/52-technologies-in-2016](https://awesome-repositories.com/repository/shekhargulati-52-technologies-in-2016.md) (7,311 ⭐) — This project serves as a comprehensive educational repository and technical reference collection, documenting a wide range of software engineering practices and modern development technologies. It provides a structured learning path for developers, curating tutorials and practical examples that cover the full lifecycle of application development, from initial project scaffolding to deployment and maintenance. The repository distinguishes itself by offering deep technical insights into complex architectural patterns, including actor-based concurrency models for managing parallel tasks and container-based orchestration for deploying isolated services. It emphasizes robust development workflows through declarative build pipelines and type-safe data modeling, ensuring structural consistency across application components. Furthermore, the project demonstrates advanced capabilities in performance engineering, featuring proxy-based load simulation tools to evaluate system behavior under high-volume traffic. Beyond its core architectural focus, the project encompasses a broad functional surface area that includes API integration, multi-model database persistence, and automated testing frameworks. It provides utilities for managing distributed state, processing natural language data, and implementing secure, declarative request validation. These resources are designed to assist developers in mastering industry-standard tools and frameworks through hands-on implementation examples. - [lazyprogrammer/machine_learning_examples](https://awesome-repositories.com/repository/lazyprogrammer-machine-learning-examples.md) (8,823 ⭐) — This project is a comprehensive collection of practical code examples and implementation libraries for machine learning. It provides a wide array of reference materials for building supervised, unsupervised, and reinforcement learning algorithms. The repository serves as a multi-domain resource, featuring specific implementation suites for financial AI, Bayesian statistical modeling, and deep learning architectures. It includes a framework for training intelligent agents using policy gradients and actor-critic models, as well as practical guides for fine-tuning transformers and utilizing large language models for text analysis. Coverage extends across several core capability areas, including computer vision development for object recognition and synthetic media generation, and financial engineering for portfolio optimization and algorithmic trading. The project also encompasses predictive model development for classification and regression tasks, as well as probabilistic frameworks for A/B testing and uncertainty quantification. The examples are implemented in Python and include configurations for GPU environments on Linux. - [filamentphp/filament](https://awesome-repositories.com/repository/filamentphp-filament.md) (31,215 ⭐) — Filament is a full-stack framework for building administrative panels and management interfaces within the Laravel ecosystem. It provides a declarative, component-based architecture that allows developers to construct complex, data-driven applications using server-side configuration objects rather than manual HTML. By inspecting database model structures and relationships, the framework automates the generation of CRUD interfaces, forms, and data tables, significantly reducing boilerplate code. The project distinguishes itself through a highly modular and extensible design that supports custom plugins, themes, and specialized dashboard widgets. It features a fluent, object-oriented API for defining UI components, validation rules, and data persistence logic, while maintaining application state between the browser and server over a persistent connection. Developers can further customize the interface through dynamic configuration, custom Blade view embedding, and a comprehensive system for managing user identity, multi-tenancy, and role-based access control. Beyond core CRUD capabilities, the framework includes advanced tools for data presentation, such as interactive charts, statistical summaries, and global search functionality. It also provides robust support for complex data entry, including multistep wizards, repeatable form blocks, and file management. The system is designed for reliability, offering built-in observability, automated testing helpers, and performance optimizations like asset scoping and client-side navigation. The framework is distributed as a set of packages that integrate directly into existing Laravel applications, with command-line utilities available to scaffold resources and administrative components. - [cycle/orm](https://awesome-repositories.com/repository/cycle-orm.md) (1,328 ⭐) — PHP DataMapper, ORM - [dapperlib/dapper](https://awesome-repositories.com/repository/dapperlib-dapper.md) (18,331 ⭐) — Dapper is a lightweight object-relational mapper for .NET that functions as a high-performance data access library. It operates by extending standard database connection interfaces, allowing developers to execute raw SQL queries while automating the mapping of database results to strongly-typed objects. The library distinguishes itself through its use of runtime code generation, which creates high-performance instructions to map database rows to object properties with minimal overhead. It provides flexible data retrieval options, supporting both memory-buffered loading for speed and row-by-row streaming to minimize memory footprint. By leveraging non-blocking task patterns, it ensures that database operations remain responsive during high-latency input and output tasks. Dapper covers a broad capability surface for database interaction, including support for parameterized queries to ensure security, atomic transaction management, and the execution of stored procedures. It handles complex data scenarios such as multi-result set parsing, bulk operations, and the mapping of related entities into nested object structures. The library is designed to be database-agnostic, maintaining compatibility with diverse database systems through standard provider abstractions. - [explorerhq/sql-explorer](https://awesome-repositories.com/repository/explorerhq-sql-explorer.md) (2,876 ⭐) — SQL reporting that Just Works. Fast, simple, and confusion-free. Write and share queries in a delightful SQL editor, with AI assistance. - [dataease/dataease](https://awesome-repositories.com/repository/dataease-dataease.md) (23,420 ⭐) — DataEase is an open-source, self-hosted business intelligence platform designed for building interactive data visualizations and managing analytical reporting. It provides a centralized environment where users can construct dashboards through a drag-and-drop interface, connecting to diverse data sources including relational databases, data warehouses, and external APIs. The platform distinguishes itself through its focus on embedded analytics and enterprise-grade governance. It allows for the seamless integration of charts, dashboards, and management modules into third-party web applications using secure iframe containers and token-based authentication. To support complex organizational needs, it includes granular role-based access control, row-level data filtering, and hierarchical organization management, ensuring that data remains secure and isolated across different departments. Beyond core visualization, the system offers extensive automation and connectivity features. It supports automated report scheduling and distribution, cross-source data modeling, and a plugin-based architecture that allows for the addition of custom data sources and visualization types. The platform also includes robust monitoring tools, such as threshold-based alerting and execution logging, to maintain operational visibility over automated tasks. The system is built to be highly configurable, offering options for platform branding, global variable definitions, and comprehensive identity management through integrations with external authentication providers. - [bokwoon95/go-structured-query](https://awesome-repositories.com/repository/bokwoon95-go-structured-query.md) (201 ⭐) — Type safe SQL query builder and struct mapper for Go - [mikro-orm/mikro-orm](https://awesome-repositories.com/repository/mikro-orm-mikro-orm.md) (9,085 ⭐) — Mikro-ORM is a TypeScript-based object-relational mapping system that provides a unified persistence layer for Node.js applications. It translates TypeScript entities into relational or document-based database schemas, supporting a variety of engines including PostgreSQL, MySQL, MariaDB, MS SQL Server, SQLite, and MongoDB. The project implements the data mapper pattern to decouple in-memory domain models from the database persistence layer. It utilizes a unit of work pattern to track entity changes in memory and commit them in a single coordinated database transaction. The library covers comprehensive data storage and synchronization capabilities, including type-safe query building, versioned schema migrations, and request-scoped state management. It provides advanced data modeling for entity inheritance and polymorphic relations, along with tools for query performance monitoring, result caching, and global data filtering. Command-line utilities are included for managing database migrations, seeding data, and exporting entity definitions from existing schemas. - [posthog/posthog](https://awesome-repositories.com/repository/posthog-posthog.md) (35,060 ⭐) — PostHog is a comprehensive product analytics and feature management platform designed to capture, process, and visualize user behavior data. It provides a unified suite for tracking application events, managing feature rollouts, and monitoring system health through session recordings and error tracking. By leveraging a columnar-storage-optimized architecture, the platform enables high-performance aggregation and filtering across massive event datasets. What distinguishes PostHog is its integrated approach to data pipelines and application control. It features a robust event ingestion system that supports custom transformation logic through sandboxed scripting, allowing for real-time data manipulation before storage. The platform also includes a sophisticated feature flagging service that supports multivariate testing and dynamic configuration across web and mobile environments, alongside automated anomaly detection and alerting engines that monitor data streams for performance shifts. The platform covers a broad observability surface, including application performance monitoring, qualitative user feedback collection via targeted surveys, and detailed activity auditing. It provides extensive administrative controls, such as granular access management and secure proxy infrastructure, to ensure reliable data collection and compliance. Developers can interact with the platform through a documented API that supports authenticated access, rate limiting, and efficient result pagination. - [laravel-doctrine/orm](https://awesome-repositories.com/repository/laravel-doctrine-orm.md) (838 ⭐) — An integration library for Laravel and Doctrine ORM - [kysely-org/kysely](https://awesome-repositories.com/repository/kysely-org-kysely.md) (13,969 ⭐) — Kysely is a TypeScript SQL query builder that provides a type-safe interface for constructing and executing database queries. It functions as a database layer that ensures schema compliance and prevents runtime errors by using a fluent interface and a programmable way to build complex SQL statements. The project features a type-safe database layer capable of inferring return types and aliases from SQL selections and joins. It also includes a SQL migration manager to track and apply schema changes across different environments to keep database versions synchronized. The toolkit covers relational database integration through dynamic query construction and the execution of raw SQL statements. It allows for the creation of parameterized SQL snippets and the ability to reference tables and columns dynamically at runtime. - [cube-js/cube](https://awesome-repositories.com/repository/cube-js-cube.md) (20,251 ⭐) — Cube is a semantic data layer that provides a unified framework for defining business metrics, dimensions, and relationships across diverse data sources. By acting as a headless business intelligence engine, it transforms raw data into a governed model that can be queried via SQL, REST, and GraphQL interfaces. This architecture ensures consistent data definitions and logic across all downstream analytical applications and reporting tools. The platform distinguishes itself through its integrated conversational AI capabilities, which allow users to explore data using natural language. It orchestrates these interactions by mapping questions to the underlying semantic model, ensuring that AI-generated insights remain accurate and context-aware. Furthermore, Cube is designed for multi-tenant environments, offering robust infrastructure isolation, row-level security, and dynamic context injection to ensure that data access is strictly governed and personalized for every user or tenant. Beyond its core modeling and AI features, the platform includes a comprehensive suite of tools for performance optimization, including automated pre-aggregation caching and asynchronous query queuing. It supports a wide range of data sources and deployment models, from self-hosted containers to managed cloud environments. The system also provides extensive programmatic control over report management, dashboard publishing, and user identity synchronization, making it suitable for embedding interactive analytics directly into custom software applications. - [launchbadge/sqlx](https://awesome-repositories.com/repository/launchbadge-sqlx.md) (16,630 ⭐) — This toolkit provides an asynchronous interface for interacting with relational databases, offering a unified driver-agnostic layer for managing connection pools and executing transactions. It is designed to integrate with asynchronous runtimes, enabling non-blocking database operations while maintaining secure, encrypted communication between the application and the database server. The project distinguishes itself through its compile-time validation capabilities, which use procedural macros to inspect SQL syntax and parameter types against a live database schema during the build process. This approach ensures that queries are verified for correctness before the application is deployed. Additionally, it features automated type mapping that transforms database rows into strongly typed structures, reducing the need for manual data conversion. Beyond its core validation and mapping features, the toolkit supports both dynamic and prepared SQL execution, with transparent caching of execution plans to optimize performance. It also includes a built-in migration manager that allows developers to bundle versioned schema scripts directly into the application binary, ensuring consistent database state management across different deployment environments. - [ottermind/chat2db](https://awesome-repositories.com/repository/ottermind-chat2db.md) (25,784 ⭐) — Chat2DB is an AI-powered SQL client and multi-database GUI manager designed for managing various relational and NoSQL database systems. It serves as a visual database management tool and a natural language to SQL interface, allowing users to convert plain text descriptions into executable and optimized queries. The platform distinguishes itself through automated business intelligence capabilities, which include the generation of real-time data visualization dashboards and AI-driven data analysis from spreadsheets. To ensure data privacy, it supports secure local AI deployment, enabling large language models to run on-premises so that sensitive metadata is not uploaded to external servers. Broadly, the project covers database administration, visual schema design with entity-relationship diagramming, and data management utilities such as migration assistants and synthetic test data generation. It also provides team collaboration features, including role-based access control and workspace synchronization. The software supports flexible deployment as either a standalone local desktop application or a centralized web-based server. - [thomasmikava/testing-library-queries](https://awesome-repositories.com/repository/thomasmikava-testing-library-queries.md) (1 ⭐) — Enhanced query builder for Testing Library with custom selectors and composable queries. Write cleaner, more maintainable tests with type-safe query composition. - [baomidou/mybatis-plus](https://awesome-repositories.com/repository/baomidou-mybatis-plus.md) (17,391 ⭐) — MyBatis-Plus is a persistence framework extension for Java that simplifies data access by reducing boilerplate code. It provides a toolkit for automating common database operations, utilizing dynamic query wrappers and a system for automated CRUD generation. The project distinguishes itself through a code generation system that produces mapper, model, service, and controller layers based on database metadata. It also implements a security layer that prevents SQL injection through input sanitization and blocks dangerous global update or delete operations to prevent accidental data loss. The framework covers broad capability areas including database pagination management, strategy-based primary key generation, and an ActiveRecord pattern for executing operations directly within entity classes. It additionally provides tools for query performance analysis to identify and resolve slow database queries. - [django/django](https://awesome-repositories.com/repository/django-django.md) (87,878 ⭐) — Django is a full-stack web framework designed for rapid backend development. It provides an integrated environment for building data-driven applications by combining an object-relational mapping layer for database management with a modular request-response pipeline for handling HTTP traffic. The framework emphasizes security and maintainability, offering a suite of tools to protect against common web vulnerabilities while decoupling site structure from implementation through a centralized URL routing system. A defining characteristic of the framework is its ability to generate production-ready administrative dashboards automatically. By inspecting model definitions and field metadata, it creates secure interfaces for managing application data without requiring custom frontend development. This is complemented by a declarative template engine that separates presentation logic from backend code, and a robust form validation system that handles data sanitization and type conversion through class-based schemas. The framework includes a wide range of built-in capabilities to support complex web development, including internationalization and localization tools, performance optimization utilities like caching, and a signal-based observer pattern for decoupling application components. It also provides comprehensive support for testing, static file management, and specialized database features. Extensive documentation is available to guide users through the framework's various components, including its middleware hooks, security policies, and administrative tools. - [mkitzan/constexpr-sql](https://awesome-repositories.com/repository/mkitzan-constexpr-sql.md) (142 ⭐) — Header only library that parses and plans SQL queries at compile time - [base16-builder/base16-builder](https://awesome-repositories.com/repository/base16-builder-base16-builder.md) (454 ⭐) — :hammer: Base16 Builder is a nimble command-line tool that generates themes for your favourite programs. - [pubkey/rxdb](https://awesome-repositories.com/repository/pubkey-rxdb.md) (23,048 ⭐) — This project is a reactive, offline-first NoSQL database engine designed for JavaScript applications. It provides a robust framework for managing application state by synchronizing data across browsers, mobile devices, and server-side runtimes. By treating local storage as the primary source of truth, it enables applications to remain functional without network connectivity, automatically reconciling changes with remote backends once a connection is restored. The database distinguishes itself through a modular architecture that supports cross-environment synchronization and high-performance data management. It features a bidirectional replication protocol that handles conflict resolution and state convergence, alongside a pluggable storage abstraction that allows developers to swap between engines like IndexedDB, SQLite, or in-memory stores without altering application logic. To ensure responsiveness, the system offloads storage operations to background worker threads and coordinates database access across multiple browser tabs through a leader election mechanism. The platform offers a comprehensive suite of capabilities for data integrity, performance, and security. It enforces strict data validation through schema-based definitions and optimizes storage footprints using transparent key compression. Developers can bind database query results directly to user interface components, enabling reactive state management where the UI automatically updates in response to local or remote data changes. The project is built for extensibility, offering a wide range of plugins for encryption, full-text search, and integration with various backend protocols including GraphQL, REST, and peer-to-peer channels. It provides extensive documentation and standardized interfaces to facilitate integration into diverse application architectures. - [theodinproject/theodinproject](https://awesome-repositories.com/repository/theodinproject-theodinproject.md) (4,282 ⭐) — The Odin Project is an open-source, full-stack web development curriculum that guides learners from basic scripting to deploying complete applications through a structured, project-based learning path. It functions as a self-directed bootcamp covering frontend, backend, databases, and job-seeking skills, with a peer-to-peer learning community where developers give and receive structured help through a forum. The platform distinguishes itself through a project-based curriculum engine that presents curated resources and assignments requiring independent problem-solving rather than step-by-step instructions, fostering real-world programming skills. It supports OAuth identity delegation through GitHub and Google for authentication, and maintains a responsive layout using CSS Grid and Flexbox without a framework. The curriculum is built on a Ruby on Rails server-side framework with Sass-powered style preprocessing, and the entire platform evolves through an open-source contribution pipeline accepting community pull requests and issue reports. The curriculum covers building interactive user interfaces, manipulating the DOM dynamically, writing automated tests, querying data with SQL, and mastering object-oriented design. Learners build a professional portfolio through dozens of project assignments, prepare for technical interviews, and find developer jobs. The platform also provides tools for career transition, including portfolio building and job search resources, while accepting donations to fund ongoing development.