latitude - A SQL query builder for PHP with zero dependencies

  •        41

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.

https://github.com/shadowhand/latitude

Tags
Implementation
License
Platform

   




Related Projects

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.

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.

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.

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.

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.


.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

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.

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 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 "...

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 Query Modelling Language

  •    

This project library creates simple Sql queries.

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.

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.

SuperDB

  •    Java

Fast, easy, Java developer's tool for query building that works with Apache Derby, HSQLDB, Sql Server and other JDBC DB's. Includes a PreparedStatement Editor, Query Builder, SQL Code Generator, editor with colorful letters amp; more.

dotsql - A Golang library for using SQL.

  •    Go

A Golang library for using SQL. It is not an ORM, it is not a query builder. Dotsql is a library that helps you keep sql files in one place and use it with ease.

join-monster - A GraphQL to SQL query execution layer for query planning and batch data fetching.

  •    Javascript

Efficient query planning and data fetching for SQL. Use JOINs and/or batched requests to retrieve all your data. It takes a GraphQL query and your schema and automatically generates the SQL. Send that SQL to your database and get back all the data needed to resolve with only one or a few round-trips to the database. ...and get back correctly hydrated data.

Mini SQL Query

  •    

Mini SQL Query is a minimalist SQL query tool for multiple databases (MSSQL, MSSQL CE, SQLite, OLEDB, MS Access/Excel files etc). The tool uses a generic schema engine taking advantage of the ADO.NET providers. Mini SQL Query is also easily extended with plugins.

elastic-builder - A Node.js implementation of the elasticsearch Query DSL :construction_worker:

  •    Javascript

A Node.js implementation of the Elasticsearch DSL for use with the official elasticsearch javascript client with builder syntax. Check out the API reference documentation.