sagframe/sagacity-sqltoy

Health v2 · maintenance only

Adoption not part of the score

1151 stars · 188 forks observed · 2026-09-01

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

sqltoy-orm is a Java ORM framework that combines JPA-style object CRUD with powerful, flexible SQL query capabilities. It provides advanced features like cache translation, optimized pagination, cross-database SQL adaptation, sharding, multi-tenancy, data encryption/masking, and unified data permission filtering, targeting complex business and large-scale data analysis scenarios.

Use cases

• build a Java backend with JPA-style CRUD plus complex custom SQL queries
• implement multi-tenant SaaS applications with data isolation
• shard large tables across multiple databases in Java
• optimize pagination queries over large datasets
• apply unified data permission filtering and anti-privilege-escalation checks
• encrypt sensitive database fields and mask data on output
• run the same SQL across MySQL, Oracle, PostgreSQL and other databases
• perform hierarchical grouping, year-over-year comparison, and pivot transformations in SQL

When to choose

• you need a Java ORM that goes beyond JPA/Hibernate with stronger SQL control and query patterns
• your project involves complex business logic, multi-tenancy, or large-scale data analysis
• you want built-in sharding, data encryption, masking, and permission filtering without extra middleware
• you use Spring Boot, traditional Spring, or Solon and want a mature, actively maintained ORM
• you need SQL that adapts automatically across different database dialects

When to avoid

• you prefer lightweight micro-ORMs or pure SQL mappers like MyBatis without extra abstraction
• your stack is not JVM-based (e.g., Python, Go, Node.js)
• you rely heavily on Hibernate-specific features or JPA specification compliance strictly
• you need a framework with large English-language community and documentation
• you are on JDK 8 long-term without plans to upgrade, since jre8 builds are end-of-life

Facets

library · maturity active

orm database search-engine caching security data-science databases backend web-development big-data developer-tools jvm cross-platform sqltoy jpa sql-management multi-tenant sharding data-encryption data-masking pagination cache-translation spring-boot-starter solon elasticsearch mongodb dynamic-datasource erp saas data-analysis chinese-documentation spring

Member repositories

For agents

markdown · JSON · MCP: product_card(name="sagframe/sagacity-sqltoy")