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. Learn more →
Top 7 Querybuilder Open-Source Projects
-
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.
-
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)"...
-
squashql
Official repository of SquashQL, the SQL query engine for multi-dimensional and hierarchical analysis that empowers your SQL database
-
pecee-pixie
Lightweight, easy-to-use querybuilder for PHP inspired by Laravel Eloquent - but with less overhead.
-
SaaSHub
SaaSHub - Software Alternatives and Reviews. SaaSHub helps you find the best software and product alternatives
For SQL, I'd probably go with goqu http://doug-martin.github.io/goqu/
Project mention: Interpolated String Builder: like a StringBuilder but for Interpolated Strings | /r/dotnet | 2023-06-25When I first drafted this idea of concatenating FormattableStrings to build SQL, I didn't have any ambition to inherit from FormattableString, then in this new project (aimed at writing something more flexible/reusable and less coupled with Dapper) I realized that I was basically writing what you said - a mutable FormattableString. But yeah, when I rely on this new structure for SQL-Building I should pay extra attention to those risks.
I have been unable to find something other than structured-filter and derivatives but these expects everything to be prefixed with a `category ===` .
I am building a SQL like query engine with a typescript query builder. It aims to provide multidimensional query capabilities (think about olap cube). The query engine is compatible with several databases (sucks, clickhouse, bigqueryx, snowflake...). Our users are developers building decision making applications. They are using for instance duckdb to develop locally their application and use a cloud provider in production. Here's the link https://github.com/squashql/squashql. Feel free to ask me any questions.
Some go for lighter things. https://thephpleague.com/ once you get their router and container running you probably have everything you need. Simple query builders that are usually also helpful (eg. https://github.com/skipperbent/pecee-pixie and https://github.com/TCB13/sequel-mongo-php) for most projects.
Querybuilder related posts
-
Interpolated String Builder: like a StringBuilder but for Interpolated Strings
-
Dapper Simple SQL Builder (A simple SQL builder for Dapper using string interpolation)
-
DapperQueryBuilder using string interpolation
-
Dapper Query Builder using String Interpolation - making Dapper easier, and on my way to reach 250 stars :-)
-
What patterns, libraries do you use to enable robust search APIs?
-
Entity Framework RawQueryBuilder (Replaces FromSqlRaw with StringBuilder-like query builder)
-
InterpolatedLogging - ILogger extensions to accept Interpolated Strings in Structured Logging
-
A note from our sponsor - InfluxDB
www.influxdata.com | 9 May 2024
Index
What are some of the best open-source Querybuilder projects? This list will help you:
Project | Stars | |
---|---|---|
1 | goqu | 2,245 |
2 | DapperQueryBuilder | 481 |
3 | structured-filter | 256 |
4 | typed-knex | 113 |
5 | squashql | 43 |
6 | pecee-pixie | 39 |
7 | sqle | 9 |
Sponsored