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

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

latitude - A SQL query builder for PHP with zero dependencies

•    PHP

---

A SQL query builder with zero dependencies. Attempts to be PSR-1, PSR-2, and PSR-4 compliant. Latitude is heavily influenced by the design of Aura.SqlQuery.

sql query-builder php7

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

Objection.js - An SQL-friendly ORM for Node.js

•    Javascript

---

Objection.js is an ORM for Node.js that aims to stay out of your way and make it as easy as possible to use the full power of SQL and the underlying database engine while keeping magic to a minimum.Objection.js is built on an SQL query builder called knex. All databases supported by knex are supported by objection.js. SQLite3, Postgres and MySQL are thoroughly tested.

orm knex sql query query-builder postgresql mysql sqlite3

.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

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

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

jinjasql - Simplify creation and maintenance of complex SQL queries by using Jinja based template language

•    Python

---

JinjaSQL is a template language for SQL statements and scripts. Since it's based in Jinja2, you have all the power it offers - conditional statements, macros, looping constructs, blocks, inheritance, and many more. JinjaSQL doesn't actually execute the query - it only prepares the query and the bind parameters. You can execute the query using any database engine / driver you are working with.

sql sql-builder jinja2 sql-injection sql-query

SQL Server 2-D Matrix Builder

•    DotNet

---

This project is all about bringing a *2-D matrix builder* to Microsoft SQL Server 2005 (or later). Why do we need this? If you need to build a query where the returned resultset colums are not actual tables columns but instead some tables records content, you will need the "...

matrix sql-server query reporting-services sql

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

squel - SQL query string builder for Javascript

•    CoffeeScript

---

SQL query string builder for Javascript

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

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

Sql Query Modelling Language

•    

---

This project library creates simple Sql queries.

qml query query-builder sql

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

TextQL - Execute SQL against structured text like CSV or TSV

•    Go

---

TextQL allows you to easily execute SQL against structured text like CSV or TSV.

query-builder sql-builder sql-on-csv

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

coconut - Simple, elegant, Pythonic functional programming.

•    Python

---

Coconut (coconut-lang.org) is a variant of Python that adds on top of Python syntax new features for simple, elegant, Pythonic functional programming.

functional language functional-programming functional-language programming-language coconut