Bookshelf - A simple Node.js ORM for PostgreSQL, MySQL and SQLite3 built on top of Knex.js

•    Javascript

---

Bookshelf is a JavaScript ORM for Node.js, built on the Knex SQL query builder. Featuring both promise based and traditional callback interfaces, providing transaction support, eager/nested-eager relation loading, polymorphic associations, and support for one-to-one, one-to-many, and many-to-many relations. It is designed to work well with PostgreSQL, MySQL, and SQLite3.

bookshelf database mysql postgresql sqlite nodejs orm datamapper active-record

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

knex - 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, and Oracle 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 async sql query sql-query-builder

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

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

Diesel - A safe, extensible ORM and Query Builder for Rust

•    Rust

---

Diesel is the most productive way to interact with databases in Rust because of its safe and composable abstractions over queries. Diesel offers a high level query builder and lets you think about your problems in Rust, not SQL. Its focus on zero-cost abstractions allows Diesel to run your query and load your data even faster than C. Unlike Active Record and other ORMs, Diesel is designed to be abstracted over. Diesel enables you to write reusable code and think in terms of your problem domain and not SQL.

query-builder orm postgresql sqlite mysql

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

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

Aura.SqlQuery - Independent query builders for MySQL, PostgreSQL, SQLite, and Microsoft SQL Server.

•    PHP

---

Provides query builders for MySQL, Postgres, SQLite, and Microsoft SQL Server. These builders are independent of any particular database connection library, although PDO in general is recommended. This package is installable and PSR-4 autoloadable via Composer as aura/sqlquery.

query-builder mysql postgresql microsoft-sql-server sqlite

sqler - write APIs using direct SQL queries with no hassle, let's rethink about SQL

•    Go

---

SQL-er is a tiny portable server enables you to write APIs using SQL query to be executed when anyone hits it, also it enables you to define validation rules so you can validate the request body/query params, as well as data transformation using simple javascript syntax. sqler uses nginx style configuration language (HCL) amd javascript engine for custom expressions. RESTful server could be used to interact directly with i.e mobile, browser, ... etc, in this mode SQLer is protected by authorizers, which gives you the ability to check authorization against another 3rd-party api. Each macro you add to the configuration file(s) you can access to it by issuing a http request to /<macro-name>, every query param and json body will be passed to the macro .Input.

mysql sqlite3 postgresql cockroach mssql api-rest restful baas

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

lucid - AdonisJS SQL ORM. Supports PostgreSQL, MySQL, MSSQL, Redshift, SQLite and many more

•    TypeScript

---

AdonisJS SQL ORM. Supports PostgreSQL, MySQL, MSSQL, Redshift, SQLite and many more

mysql sql orm postgresql sqlite3 active-record first-party-package

DbGate- Database manager for MySQL, PostgreSQL, SQL Server, MongoDB, SQLite and others

•    Svelte

---

DbGate is cross-platform database manager. It's designed to be simple to use and effective, when working with more databases simultaneously. But there are also many advanced features like schema compare, visual query designer, chart visualisation or batch export and import. It supports MySQL, PostgreSQL ,SQL Server, MongoDB, Redis, SQLite, Amazon Redshift, CockroachDB, and MariaDB.

electron mysql sql sql-server mongodb sqlite postgresql database-gui database-manager database-tools

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

TableQA - AI Tool for querying natural language on tabular data.

•    Python

---

AI Tool for querying natural language on tabular data.Built using QA models from transformers.

nlp qa machine-learning csv sql database ai tabular-data sql-query question-answering sql-generation nl2sql tableqa table-qa querying-natural-language

Chloe - A lightweight and high-performance Object/Relational Mapping(ORM) library for .NET --C#

•    CSharp

---

Chloe is a lightweight Object/Relational Mapping(ORM) library. The query interface is similar to LINQ.You can query data like LINQ and do any things(Join Query | Group Query | Aggregate Query | Insert | Batch Update | Batch Delete) by lambda with Chloe.ORM.

orm chloe c-sharp dotnetcore mysql oracle sqlite poco postgresql

MikroORM - TypeScript ORM for Node

•    Typescript

---

MikroORM is a TypeScript ORM for Node.js based on Data Mapper, Unit of work and Identity Map patterns. It supports MongoDB, MySQL, MariaDB, PostgreSQL and SQLite databases. Heavily inspired by Doctrine and Nextras ORM.

orm javascript-orm mongodb sqlite postgresql entities entity sqlite3 datamapper unit-of-work identity-map postgre typescript-orm mongo mariadb mysql data-mapper

godb - A Go SQL query builder and struct mapper.

•    Go

---

godb is a simple Go query builder and struct mapper, not a full-featured ORM. godb does not manage relationships. Initially, godb was a learning project. The goal was to improve my Go skills by doing some useful things. But more and more features have been added and godb has become a serious project that can be used by others.

sql orm database

Coolstorage - ORM library for .NET

•    CSharp

---

The main strength of Vici CoolStorage is the ease of use. Most ORM tools still require a lot of unneeded code to accomplish basic data persistence tasks, but Vici CoolStorage is designed to relieve the programmer from these tedious and error-prone tasks, making it very intuitive to use.

orm persistence database-development datamapper ormdotnet

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.