XORM - eXtra ORM for Go

•    Go

---

Xorm is a simple and powerful ORM for Go.

orm mysql sqlite mssql postgres postgresql tidb database-library go-orm

Class Builder Wizard

•    

---

Class Builder Wizard is a Microsoft Visual Studio wizard that generates data object classes and a full data layer implementation for database objects (MS SQL Server and others). It can also be used to quickly create custom classes (not necessarily based on a database object) b...

code-generation addin class-builder class-builder-wizard class-designer class-generator class-generator1

database - [READ ONLY] Subtree split of the Illuminate Database component (see laravel/framework)

•    PHP

---

The Illuminate Database component is a full database toolkit for PHP, providing an expressive query builder, ActiveRecord style ORM, and schema builder. It currently supports MySQL, Postgres, SQL Server, and SQLite. It also serves as the database layer of the Laravel PHP framework. First, create a new "Capsule" manager instance. Capsule aims to make configuring the library for usage outside of the Laravel framework as easy as possible.

rel - :gem: Database Access Layer for Golang - Testable, Extendable and Crafted Into a Clean and Elegant API

•    Go

---

Modern Database Access Layer for Golang. REL is golang orm-ish database layer for layered architecture. It's testable and comes with its own test library. REL also features extendable query builder that allows you to write query using builder or plain sql.

mysql sql orm database postgresql help-wanted repository-pattern hacktoberfest database-migration

Apache Superset is a Data Visualization and Data Exploration Platform

•    Python

---

Superset is fast, lightweight, intuitive, and loaded with options that make it easy for users of all skill sets to explore and visualize their data, from simple line charts to highly detailed geospatial charts. It easily integrates your data, using either our simple no-code viz builder or state of the art SQL IDE. Superset can query data from any SQL-speaking datastore or data engine (e.g. Presto or Athena) that has a Python DB-API driver and a SQLAlchemy dialect.

react flask data-science bi analytics superset apache data-visualization data-engineering business-intelligence data-viz data-analytics data-analysis sql-editor asf business-analytics

pixie - Database query builder for PHP, framework agnostic, lightweight and expressive.

•    PHP

---

A lightweight, expressive, framework agnostic query builder for PHP it can also be referred as a Database Abstraction Layer. Pixie supports MySQL, SQLite and PostgreSQL and it takes care of query sanitization, table prefixing and many other things with a unified API. At least PHP 5.3 is required. The syntax is quite similar to Laravel's query builder.

knex.js - A SQL query builder that is flexible, portable, and fun to use

•    Javascript

---

Knex.js is a "batteries included" SQL query builder for Postgres, MSSQL, MySQL, MariaDB, SQLite3, Oracle, and Amazon Redshift designed to be flexible, portable, and fun to use. It features both traditional node style callbacks as well as a promise interface for cleaner async flow control, a stream interface, full featured query and schema builders, transaction support (with savepoints), connection pooling and standardized responses between different query clients and dialects.

query-builder orm connection-pool database-library database-tools

querybuilder - SQL query builder, written in c#, helps you build complex queries easily, supports SqlServer, MySql, PostgreSql and Firebird

•    CSharp

---

SqlKata Query Builder is a powerful Sql Query Builder written in C#. It's secure and framework agnostic. Inspired by the top Query Builders available, like Laravel Query Builder, and Knex.

sql-query-builder sql-server postgresql mysql c-sharp database query-builder sql-query sql activerecord data-access-layer

goqu - SQL builder and query library for golang

•    Go

---

In order to start using goqu with your database you need to load an adapter. We have included some adapters by default. Adapters in goqu work the same way as a driver with the database in that they register themselves with goqu once loaded.

sql sql-statement sql-builder database postgresql mysql sqlite sql-query sql-generation

SQLx - The Rust SQL Toolkit

•    Rust

---

SQLx is an async, pure Rust SQL crate featuring compile-time checked queries without a DSL. It is truly Asynchronous. Built from the ground-up using async/await for maximum concurrency. It has support for PostgreSQL, MySQL, SQLite, and MSSQL.

mysql postgres sql async sqlite postgresql mariadb mssql await orm sql-builder connection-pool

.NET Dynamic SQL Generator

•    CSharp

---

A Database agnostic SQL query builder and Data Access Layer for .NET. Build safe SQL Statements using familiar syntax and execute on any database with minimal effort. Written in C# using VS 2008

data-access-layer dynamic-sql query-builder sql sql-server

NHibernate Criteria Builder

•    

---

NHibernate Criteria Builder is a business layer over NHibernate mapping classes enabling business way of database querying. The library goal is to query the database as close to business needs as possible: focusing mainly on "what data should be retrieved" instead of "how".

reindexer - Embeddable, in-memory, document-oriented database with a high-level Query builder interface

•    C++

---

Reindexer is an embeddable, in-memory, document-oriented database with a high-level Query builder interface. Reindexer's goal is to provide fast search with complex queries. We at Restream weren't happy with Elasticsearch and created Reindexer as a more performant alternative.

pypika - PyPika is a SQL query builder with a pythonic syntax that doesn't limit the expressiveness of SQL

•    Python

---

PyPika is a Python API for building SQL queries. The motivation behind PyPika is to provide a simple interface for building SQL queries without limiting the flexibility of handwritten SQL. Designed with data analysis in mind, PyPika leverages the builder design pattern to construct queries to avoid messy string formatting and concatenation. It is also easily extended to take full advantage of specific features of SQL database vendors. PyPika supports python 2.7 and 3.3+. It may also work on pypy, cython, and jython, but is not being tested for these versions.

sql functional python27 python3 builder pythonic query

piccolo - A fast, user friendly ORM and query builder which supports asyncio.

•    Python

---

A fast, user friendly ORM and query builder which supports asyncio. Read the docs. The syntax is clean and expressive.

orm database sqlite postgresql python3 asyncio query-builder asgi piccolo starlette fastapi

prisma-client-go - Prisma Client Go is an auto-generated and fully type-safe database client

•    Go

---

Prisma Client Go is an auto-generated query builder that enables type-safe database access and reduces boilerplate. You can use it as an alternative to traditional ORMs such as gorm, xorm, sqlboiler and most database-specific tools. It is part of the Prisma ecosystem. Prisma provides database tools for data access, declarative data modeling, schema migrations and visual data management.

mysql orm database sqlite postgresql mariadb mssql sqlserver prisma

Prisma - Next-generation ORM for Node.js and TypeScript

•    Typescript

---

Prisma helps app developers build faster and make fewer errors with an open source ORM for PostgreSQL, MySQL and SQLite. It makes database access easy with an auto-generated and type-safe query builder that's tailored to your database schema. It provides an alternative to traditional ORMs and SQL query builders.

mysql postgres mongo sql-server orm database mongodb sqlite postgresql mariadb mssql sqlserver mongodb-orm prisma-client nodejs-orm rest-api database-migration

orbit-db - Peer-to-Peer Databases for the Decentralized Web

•    Javascript

---

OrbitDB is a serverless, distributed, peer-to-peer database. OrbitDB uses IPFS as its data storage and IPFS Pubsub to automatically sync databases with peers. It's an eventually consistent database that uses CRDTs for conflict-free database merges making OrbitDB an excellent choice for decentralized apps (dApps), blockchain applications and offline-first web applications.

p2p distributed decentralized database ipfs crdt peer-to-peer

DB Lens - Database explorer for Mac, Windows & Linux

•    TypeScript

---

DB Lens is an open-source database client that helps you to explore database, understand data relations more quickly with automatic ER diagrams, visualise and analyse internal DB metrics such as index utilisation sequential scans, slow running queries, storage and many more.

electron postgres database-management database-explorer database db boilerplate react typescript ts database-manager database-gui database-tools

JavaDB

•    Java

---

Java DB is Sun's supported distribution of the open source Apache Derby 100% Java technology database. It is fully transactional, secure, easy-to-use, standards-based — SQL, JDBC API, and Java EE — yet small, only 2.5 MB.

database relational transactional