x-ream/sqli

Health v2 · maintenance only

Adoption not part of the score

1712 stars · 802 forks observed · 2026-08-28

What it is AI-extracted, prompt v1, taxonomy v1, 2026-08-30, confidence not recorded

sqli is a Java SQL query builder and lightweight ORM programming interface with fluent APIs (QB, QB.X, QrB) for building typed and Map-based queries. It integrates with existing frameworks such as Spring Boot via the x7 starter, supporting repositories, pagination, batch operations, and multiple SQL dialects.

Use cases

• build SQL queries programmatically in Java without writing raw SQL
• query MySQL, ClickHouse, Presto, Impala, or TDengine from a Spring Boot app
• create paginated list and find queries with a fluent query builder
• perform batch inserts and upsert-style createOrReplace operations
• run join queries returning Map records with QB.X
• stream large query results with a row handler

When to choose

• you want a lightweight SQL builder/ORM layer on the JVM instead of a full heavyweight ORM
• your project targets multiple SQL dialects like MySQL, ClickHouse, Presto, Impala, or TDengine
• you prefer fluent query construction (QB/QB.X) with repository-style data access in Spring Boot

When to avoid

• you need a full-featured ORM with JPA/Hibernate features like lazy loading and caching
• you are not on the JVM or not using Java
• you want auto-generated schema migrations or self-incrementing key returns, which are not supported

Facets

library · maturity active

orm database database-driver databases backend developer-tools jvm query-builder sql-builder jdbc mysql clickhouse presto impala tdengine fluent-api spring

Member repositories

For agents

markdown · JSON · MCP: product_card(name="x-ream/sqli")