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

Parser SQL Query

•    C++

---

Class C++ of parse SQL query. Simple, but effective to add a condition to the SQL query of any complexity or replace a variable by its value. Variable begins with a '$'.

parser sql visual-studio-2010

Sqlparse - A non-validating SQL parser module for Python

•    Python

---

sqlparse is a non-validating SQL parser for Python. It provides support for parsing, splitting and formatting SQL statements.

sql-parser sql-statements sql parser

PHPMyAdmin

•    PHP

---

phpMyAdmin is a free software tool written in PHP intended to handle the administration of MySQL over the World Wide Web. phpMyAdmin supports a wide range of operations with MySQL. The most frequently used operations are supported by the user interface (managing databases, tables, fields, relations, indexes, users, permissions, etc), while you still have the ability to directly execute any SQL statement.

database-front-end adminstration tool mysql-admin mysql-management mysql-tool

WowPacketParser - World of Warcraft Packet Parser

•    CSharp

---

Optionally, WPP can connect to two kinds of MySQL databases: world from TrinityCore and its own database, WPP. This can be enabled by setting <add key="DBEnabled" value="true" /> in the .config file. Remember to set <add key="TargetedDatabase" value="1"/> in accordance with the targeted version of the core. The world database is used when creating SQL files after parsing to produce the mimimum number of changes needed to update the database. For example, if only the faction of a creature that appears in the sniff needs to be updated, the produced SQL files will contain an UPDATE query, instead of a full INSERT to the table creature_template. WPP does not modify this database directly, all the tentative changes will be written to the output SQL files.

sniff wow parser c-sharp wpp

sql-parser - A SQL parser written in pure JS

•    Javascript

---

SQL Parser is a lexer, grammar and parser for SQL written in JS. Currently it is only capable of parsing fairly basic SELECT queries but full SQL support will hopefully come in time. See the specs for examples of currently supported queries. The package is distributed on NPM and can be installed with...

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

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

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

datafusion - SQL Query Execution against Apache Arrow, in Rust

•    Rust

---

DataFusion is a SQL parser, planner, and query execution library for Rust. A DataFrame API is also provided. DataFusion can be used as a crate dependency in your project to add SQL support for custom data sources.

spark sql dataframe cluster compute data arrow

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

Open SQL Parser

•    Javascript

---

Open SQL Parser is a database independant SQL parser written in PHP.

sqlparser - Simple SQL parser meant for querying CSV files

•    Go

---

Simple SQL parser meant for querying CSV files

parser csv sql

.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

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

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 Bandwidth Meter Log Parser

•    

---

Parses the log files created by the Hosts Tools SQL Bandwidth Meter application

bandwidth log-viewer logviewer sql sql-2005 sql-2008 sql-server

SQL Buddy - Web based MySQL administration

•    PHP

---

SQL Buddy is a phpMyAdmin alternative with a focus on usability. It supports to create and drop databases and tables, View, edit, insert and delete table rows, Execute custom SQL and view the output, Import and export databases and tables to SQL and CSV formats, Add, edit and delete MySQL users.

database-front-end adminstration tool mysql-admin mysql-management mysql-tool

SQL Parser for Delphi

•    Delphi

---

Develope a string parser that is capable to parse SQL statements into tokens, allows changing theese tokens and rebuilding (modified) SQL statement

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