LFX Platform

Know more about LFX Platform

LFX Insights

SQL Query Builders

Libraries for constructing, formatting, and executing SQL queries using fluent, type‐safe APIs.

34 projects

78,353 contributors

$180M

Prisma

Prisma is a next-generation ORM (Object-Relational Mapping) that helps developers build faster and make fewer errors with an intuitive data model, automated migrations, type-safety and auto-completion. It provides a clean and type-safe database access layer that supports multiple databases including PostgreSQL, MySQL, SQLite, and MongoDB.

Contributors

19,335

Organizations

4,681

Software value

$6.9M

knex.js

A flexible SQL query builder for Node.js and browsers that provides a clean, chainable interface for constructing database queries across multiple database platforms including PostgreSQL, MySQL, SQLite and more

Contributors

5,931

Organizations

1,757

Software value

$3.6M

MyBatis-Plus

MyBatis-Plus is an enhanced toolkit for MyBatis that simplifies database operations by providing powerful wrapper APIs, plugins, and code generation tools. It extends MyBatis functionality with features like CRUD operations, active record support, and automatic SQL injection protection.

Contributors

5,717

Organizations

264

Software value

$2.1M

SQLAlchemy

SQLAlchemy is a Python SQL toolkit and Object-Relational Mapping (ORM) library that provides a full suite of well-known enterprise-level persistence patterns, designed for efficient and high-performing database access while providing high-level abstraction over SQL operations.

Contributors

4,899

Organizations

1,110

Software value

$23M

SQLx

🧰 The Rust SQL Toolkit. An async, pure Rust SQL crate featuring compile-time checked queries without a DSL. Supports PostgreSQL, MySQL, and SQLite.

Contributors

3,433

Organizations

1,070

Software value

$3.2M

Doctrine DBAL

Doctrine DBAL (Database Abstraction Layer) is a powerful database abstraction library for PHP that provides a lightweight and consistent interface for communicating with various relational database systems. It sits on top of PDO and offers additional functionality, security, and an object-oriented API for database operations.

Contributors

3,061

Organizations

921

Software value

$2.5M

Laravel DataTables

jQuery DataTables API for Laravel

Contributors

2,924

Organizations

339

Software value

$163K

Ecto

Ecto is a database wrapper and query generator for Elixir applications. It provides a DSL for writing database queries, a robust migration system, and tools for mapping database rows to Elixir structs, making it easier to work with databases in Elixir projects.

Contributors

2,694

Organizations

824

Software value

$2M

Diesel

A safe, extensible ORM and Query Builder for Rust

Contributors

2,664

Organizations

912

Software value

$3.8M

Dapper

Dapper - a simple object mapper for .Net

Contributors

2,635

Organizations

416

Software value

$699K

jOOQ

jOOQ is a Java library that provides a fluent API for building type-safe SQL queries. It generates Java code from database schemas and enables developers to write SQL queries using Java code, offering compile-time safety, code completion, and database abstraction.

Contributors

2,424

Organizations

590

Software value

$13M

MyBatis

MyBatis is a SQL mapping framework that simplifies database access in Java applications by providing a layer between Java code and SQL databases. It automates the mapping between SQL queries and Java objects, reducing boilerplate code while maintaining full control over SQL statements.

Contributors

2,171

Organizations

273

Software value

$3.9M

Querydsl

Unified Queries for Java

Contributors

1,960

Organizations

338

Software value

$4.8M

Exposed

Kotlin SQL Framework

Contributors

1,796

Organizations

445

Software value

$34M

Objection.js

An SQL-friendly ORM for Node.js

Contributors

1,734

Organizations

474

Software value

$2.7M

Slick

Slick (Scala Language Integrated Connection Kit) is a modern database query and access library for Scala

Contributors

1,708

Organizations

502

Software value

$1.1M

SQLGlot

Python SQL Parser and Transpiler

Contributors

1,680

Organizations

260

Software value

$4.9M

Sequel

Sequel is a database toolkit and Object-Relational Mapper (ORM) for Ruby that provides a flexible domain-specific language for constructing SQL queries and database interactions. It supports multiple database adapters, migrations, prepared statements, connection pooling, and advanced features like eager loading and dataset chaining.

Contributors

1,449

Organizations

465

Software value

$5.2M

Flask App Builder

Simple and rapid application development framework, built on top of Flask. includes detailed security, auto CRUD generation for your models, google charts and much more. Demo (login with guest/welcome) - http://flaskappbuilder.pythonanywhere.com/

Contributors

1,402

Organizations

249

Software value

$1.6M

sqlx

general purpose extensions to golang's database/sql

Contributors

1,376

Organizations

500

Software value

$196K

LINQ to DB

Linq to database provider.

Contributors

1,361

Organizations

142

Software value

$31M

FluentMigrator

Fluent migrations framework for .NET

Contributors

1,268

Organizations

234

Software value

$3.7M

Jdbi

The Jdbi library provides convenient, idiomatic access to relational databases in Java and other JVM technologies such as Kotlin, Clojure or Scala.

Contributors

971

Organizations

236

Software value

$3.3M

GRDB.swift

A toolkit for SQLite databases, with a focus on application development

Contributors

962

Organizations

181

Software value

$5.3M

Atlas

Manage your database schema as code

Contributors

908

Organizations

299

Software value

$3.8M

MyBatis-Flex

MyBatis-Flex is a powerful and flexible MyBatis enhancement toolkit that provides dynamic table mapping, active record pattern support, automatic SQL generation, and advanced query capabilities while maintaining compatibility with native MyBatis features

Contributors

676

Organizations

35

Software value

$2.5M

Yii Database

Yii Database Library

Contributors

563

Organizations

57

Software value

$1.1M

QueryDSL

Unified Queries for Java

Contributors

307

Organizations

35

Software value

$5.7M

Nette Database

🏆 A full-stack component-based MVC kernel for PHP that helps you write powerful and modern web applications. Write less, have cleaner code and your work will bring you joy.

Contributors

247

Organizations

55

Software value

$215K

Data API builder

Data API builder is a framework that enables developers to create REST and GraphQL APIs from various data sources like SQL Server, PostgreSQL, MySQL, and CosmosDB. It provides automatic CRUD operations, role-based access control, and configurable endpoints without writing boilerplate code.

Contributors

97

Organizations

9

Software value

$4.6M

Blaze-Persistence

Rich Criteria API for JPA providers

This project hasn't been onboarded to LFX Insights.

Ibis

the portable Python dataframe library

This project hasn't been onboarded to LFX Insights.

JSqlParser

JSqlParser parses an SQL statement and translate it into a hierarchy of Java classes. The generated hierarchy can be navigated using the Visitor Pattern

This project hasn't been onboarded to LFX Insights.
Looking for a project that’s not listed?