Query Builder

Open-source projects categorized as Query Builder
Edit details
Language: + TypeScript + JavaScript + PHP + Rust + Go + C# + Java + Python
Topics: SQL Database Postgresql TypeScript MySQL
The modern identity platform for B2B SaaS
The APIs are flexible and easy-to-use, supporting authentication, user identity, and complex enterprise features like SSO and SCIM provisioning.
workos.com
Sponsored

Top 23 Query Builder Open-Source Projects

  • Prisma

    Next-generation ORM for Node.js & TypeScript | PostgreSQL, MySQL, MariaDB, SQL Server, SQLite, MongoDB and CockroachDB

    • Project mention: Deploy Full-Stack Next.js T3App with Cognito and Prisma using AWS Lambda | dev.to | 2024-04-15

    generator client { provider = "prisma-client-js" binaryTargets = ["native", "rhel-openssl-1.0.x"] } datasource db { provider = "postgresql" // NOTE: When using mysql or sqlserver, uncomment the @db.Text annotations in model Account below // Further reading: // https://next-auth.js.org/adapters/prisma#create-the-prisma-schema // https://www.prisma.io/docs/reference/api-reference/prisma-schema-reference#string url = env("DATABASE_URL") } model Post { id Int @id @default(autoincrement()) name String createdAt DateTime @default(now()) updatedAt DateTime @updatedAt createdBy User @relation(fields: [createdById], references: [id]) createdById String @@index([name]) } // ... rest of the schema

  • Knex

    A query builder for PostgreSQL, MySQL, CockroachDB, SQL Server, SQLite3 and Oracle, designed to be flexible, portable, and fun to use.

    • Project mention: JavaScript Libraries for Implementing Trendy Technologies in Web Apps in 2024 | dev.to | 2024-04-09

    Knex.js

  • SurveyJS

    Open-Source JSON Form Builder to Create Dynamic Forms Right in Your App. With SurveyJS form UI libraries, you can build and style forms in a fully-integrated drag & drop form builder, render them in your JS app, and store form submission data in any backend, inc. PHP, ASP.NET Core, and Node.js.

    SurveyJS logo

  • diesel

    A safe, extensible ORM and Query Builder for Rust

    • Project mention: Top 10 Rusty Repositories for you to start your Open Source Journey | dev.to | 2023-12-19

    7. Diesel

  • kysely

    A type-safe typescript SQL query builder

    • Project mention: Show HN: Tsynamo – Type-friendly DynamoDB query builder for TypeScript | news.ycombinator.com | 2024-04-10

    Hello HN! I was recently introduced to Kysely (https://github.com/kysely-org/kysely), a type-safe Typescript SQL query builder, and instantly fell in love! I got inspired and wanted to make something similar for AWS DynamoDB.

    Thus, I developed Tsynamo! Instead of calling it type-safe, I decided to go with type-friendly, because the library is still in an early stage, and is not 100% type-safe.

    Under the hood, Tsynamo compiles the built queries into AWS SDK v3 commands. I feel that Tsynamo simplifies the AWS SDK API quite a lot since the developer doesn't have to mess around with condition/filter expressions or attribute names/values themselves, and as a bonus gets autocompletion for building the queries!

    There's also a playground to test it out in your browser: https://try.tsynamo.dev. It might not have the most up-to-date API of the library in use yet, but you can get the library's main idea from there.

    Since the project is still in its early stages, it doesn't yet have 100% support for all DynamoDB features, like querying indexes. The next steps will be increasing the support coverage and perhaps adding automatic type generation as inspired by kysely-codegen (https://github.com/RobinBlomberg/kysely-codegen).

    Would love to get some feedback, thanks in advance!

  • SqlKata Query Builder

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

  • sqli

    orm sql query builder, API: QB, QB.X, QrB

  • react-awesome-query-builder

    User-friendly query builder for React

  • InfluxDB

    Power Real-Time Data Analytics at Scale. Get real-time insights from all types of time series data with InfluxDB. Ingest, query, and analyze billions of data points in real-time with unbounded cardinality.

    InfluxDB logo

  • vue-api-query

    💎 Elegant and simple way to build requests for REST API

  • piccolo

    A fast, user friendly ORM and query builder which supports asyncio. (by piccolo-orm)

    • Project mention: Piccolo, a Lightweight and Async Pydantic V2 Python ORM | news.ycombinator.com | 2023-11-07

  • Cycle ORM

    PHP DataMapper, ORM (by cycle)

    • Project mention: RoadRunner: High-performance PHP application server written in Golang | news.ycombinator.com | 2023-07-29

    From the same developers :

    PHP framework : https://spiral.dev/

    ORM library : https://cycle-orm.dev/

  • laravel-eloquent-query-cache

    Adding cache on your Laravel Eloquent queries' results is now a breeze.

  • sea-query

    🔱 A dynamic SQL query builder for MySQL, Postgres and SQLite

  • gocqlx

    All-In-One: CQL query builder, ORM and migration tool

  • bob

    SQL query builder and ORM/Factory generator for Go with support for PostgreSQL, MySQL and SQLite (by stephenafamo)

    • Project mention: how to avoid writing dreadful SQL statements | /r/golang | 2023-05-23

    Use something that does codegen, like sqlc or Bob.

  • mammoth

    A type-safe Postgres query builder for TypeScript. (by Ff00ff)

    • Project mention: PostgresJs: The Fastest full featured PostgreSQL client for Node.js and Deno | news.ycombinator.com | 2023-10-14

    Super happy user of this [1] it's rather minimalistic but great.

    [1] https://github.com/Ff00ff/mammoth

  • orchid-orm

    Orchid ORM

  • Aura.SqlQuery

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

  • PostGUI

    A React web application to query and share any PostgreSQL database.

  • gql-query-builder

    🔧 Simple GraphQL Query Builder

  • sqliterally

    Lightweight SQL query builder

  • structured-filter

    jQuery UI widget for structured queries like "Contacts where Firstname starts with A and Birthday before 1/1/2000 and State in (CA, NY, FL)"...

    • Project mention: looking for a structured text component for search | /r/reactjs | 2023-05-24

    I have been unable to find something other than structured-filter and derivatives but these expects everything to be prefixed with a `category ===` .

  • apollo-studio-community

    🎡  GraphQL developer portal featuring an IDE (Apollo Explorer), auto-documentation, metrics reporting, and more. This repo is for issues, feature requests, and preview docs. 📬

  • workers-qb

    Zero dependencies Query Builder for Cloudflare Workers

  • WorkOS

    The modern identity platform for B2B SaaS. The APIs are flexible and easy-to-use, supporting authentication, user identity, and complex enterprise features like SSO and SCIM provisioning.

    WorkOS logo
NOTE: The open source projects on this list are ordered by number of github stars. The number of mentions indicates repo mentiontions in the last 12 Months or since we started tracking (Dec 2020).

Query Builder related posts

Index

What are some of the best open-source Query Builder projects? This list will help you:

Project Stars
1 Prisma 37,151
2 Knex 18,741
3 diesel 11,904
4 kysely 9,289
5 SqlKata Query Builder 2,997
6 sqli 1,905
7 react-awesome-query-builder 1,778
8 vue-api-query 1,644
9 piccolo 1,266
10 Cycle ORM 1,196
11 laravel-eloquent-query-cache 1,020
12 sea-query 1,008
13 gocqlx 873
14 bob 580
15 mammoth 492
16 orchid-orm 461
17 Aura.SqlQuery 445
18 PostGUI 424
19 gql-query-builder 388
20 sqliterally 260
21 structured-filter 254
22 apollo-studio-community 246
23 workers-qb 213

Sponsored
The modern identity platform for B2B SaaS
The APIs are flexible and easy-to-use, supporting authentication, user identity, and complex enterprise features like SSO and SCIM provisioning.
workos.com