sql-query-builder

Open-source projects categorized as sql-query-builder
Edit details
Language: + C# + Java + Go + TypeScript
Topics: sql-query SQL Postgresql MySQL Database
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 5 sql-query-builder Open-Source Projects

  • jOOQ

    jOOQ is the best way to write SQL in Java

    • Project mention: Serious flaws in SQL – Edgar F. Codd (1990) | news.ycombinator.com | 2024-04-25

    > 2. ORMs do not hide SQL nastiness.

    This is certainly true!

    I mean: ORMs are now well known to "make the easy queries slightly more easy, while making intermediate queries really hard and complex queries impossible".

    I think the are of ORMs is over. It simply did not deliver.

    If a book on SQL is --say-- 100 pages, a book on Hibernate is 400 pages. So much to learn just to make the easy queries slightly easier to type? Just not worth it.

    I prefer jooq any day over ORMs. And dont get me started over what tools like Hasuna have to offer.

    There are also some languages (forgot the names) that are SQL-done-right. Select in the back, more type safe, more logic, more in the same steps as the query gets executed. These need to be adopted by PG and MySQL and we're good to go. (IMHO)

    https://www.jooq.org/

    https://hasura.io/

  • SqlKata Query Builder

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

  • 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

  • jet

    Type safe SQL builder with code generation and automatic query result data mapping

    • Project mention: Open-sourcing SQX, a way to build flexible database models in Go | news.ycombinator.com | 2023-09-02

    We are really happy using jet. It lets you write type safe SQL and can read the results into structs- including joins into slice fields.

    https://github.com/go-jet/jet

  • sql-template-tag

    ES2015 tagged template string for preparing SQL statements, works with `pg`, `mysql`, and `sqlite`

    • Project mention: Python: Just Write SQL | news.ycombinator.com | 2023-08-14

    You can avoid this entirely with JavaScript's tagged template literals. Here is an example library: https://github.com/blakeembrey/sql-template-tag

  • Dapper.SimpleSqlBuilder

    A simple SQL builder for Dapper using string interpolation and fluent API for building safe static and dynamic SQL queries.

  • 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).

sql-query-builder related posts

Index

What are some of the best open-source sql-query-builder projects? This list will help you:

Project Stars
1 jOOQ 5,893
2 SqlKata Query Builder 2,997
3 jet 2,025
4 sql-template-tag 312
5 Dapper.SimpleSqlBuilder 39

Sponsored
SaaSHub - Software Alternatives and Reviews
SaaSHub helps you find the best software and product alternatives
www.saashub.com