Top 8 JavaScript Query Builder Projects

Knex

95 18,741 7.9 JavaScript

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

react-awesome-query-builder

6 1,778 5.7 JavaScript

User-friendly query builder for React
SurveyJS

surveyjs.io sponsored

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.
vue-api-query

2 1,644 3.9 JavaScript

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

2 424 0.0 JavaScript

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

1 260 0.0 JavaScript

Lightweight SQL query builder
structured-filter

1 255 6.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

1 113 0.0 JavaScript

data access framework for Postgresql on nodejs
WorkOS

workos.com 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.
super-sqlite3

1 5 2.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).