Top 8 JavaScript Query Builder Projects

Knex

12 18,007 8.4 JavaScript

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

Project mention: Plankaban Raspberry Pi 4 Setup Help | /r/selfhosted | 2023-06-08

# related: https://github.com/knex/knex/issues/2354
react-awesome-query-builder

3 1,651 8.2 JavaScript

User-friendly query builder for React

Project mention: What are some of the main packages and other parts of the React ecosystem that have yet to be implemented in Svelte contrib? | /r/sveltejs | 2023-04-17

A query builder https://github.com/ukrbublik/react-awesome-query-builder
Appwrite

appwrite.io
sponsored

Appwrite - The open-source backend cloud platform. The open-source backend cloud platform for developing Web, Mobile, and Flutter applications. You can set up your backend faster with real-time APIs for authentication, databases, file storage, cloud functions, and much more!
vue-api-query

0 1,625 6.7 JavaScript

💎 Elegant and simple way to build requests for REST API
PostGUI

0 397 0.0 JavaScript

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

0 257 0.0 JavaScript

Lightweight SQL query builder
structured-filter

1 251 10.0 JavaScript

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 ===` .
ship-hold

0 114 0.0 JavaScript

data access framework for Postgresql on nodejs
SurveyJS

surveyjs.io
sponsored

A Non-Cloud Alternative to Google Forms that has it all.. SurveyJS JavaScript libraries allow you to easily set up a robust form management system fully integrated into your IT infrastructure where users can create and edit multiple dynamic JSON-based forms in a no-code form builder. Learn more now.
super-sqlite3

1 5 10.0 JavaScript

Fast SQLite library with optional full db encryption, simple query builder, and a host of utility features, all in one neat package

Project mention: Show HN: Doculite – Use SQLite Like Firestore | news.ycombinator.com | 2023-08-07

Interesting project! I have lately been trying out these cool and perhaps in some way similar sqlite libraries:
- https://github.com/haxtra/kvstore-sqlite (Basic key-value store for SQLite databases.)
- https://github.com/haxtra/super-sqlite3 (Fast SQLite library with optional full db encryption, simple query builder, and a host of utility features, all in one neat package.)
- https://github.com/haxtra/live-object (Standard javascript object with built-in JSON serialization to file. Dreams do come true sometimes.)
All from github user: https://github.com/haxtra
I think the super-sqlite3 source might also be an inspiration for the 'driver' topic: "super-sqlite3 is a thin wrapper around better-sqlite3-multiple-ciphers, which extends better-sqlite3 (the fastest SQLite library for node.js) with full database encryption using SQLite3MultipleCiphers. super-sqlite3 then adds its own query builder and other convenience features."
And do check out this user's XRay (JavaScript object browser component) library for your preferred component framework.
In my bookmarks I also found these other related and interesting links:

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). The latest post mention was on 2023-08-07.