# braisdom/ObjectiveSql

Writing SQL using Java syntax

Repository: https://github.com/braisdom/ObjectiveSql
Canonical: https://ross.abutalabs.com/products/objectivesql
Language: Java
License: Apache-2.0
License Family: permissive
Topics: sql, java, orm, objsql, activerecord, java-orm, sql-programming, java-api, orm-framework, rapid-development
Last push: 2024-05-06T07:03:37+00:00

## Health v2 (maintenance only)
Score: 32/100 (v2, computed 2026-09-02T17:46:02.011165+00:00)
- activity 0, release rhythm 35, longevity 100
- inputs: {"age_days": 2246, "days_push": 849, "days_rel": null, "gap_med": null, "n_releases_24m": 0}
- flags: no_releases
- formula: round(0.45*activity + 0.35*rhythm + 0.20*longevity); archived -> min(score, 10)

## Adoption (not part of the score)
Stars 1258, forks 158 (observed 2026-08-28T04:04:09.564839+00:00)

## What it is
ObjectiveSQL is a Java ORM framework based on the ActiveRecord pattern that lets developers write SQL expressions using Java syntax with minimal configuration. It uses annotation-driven dynamic code generation so a single annotation gives a class full database persistence, relational query, and pagination capabilities.

## Use cases
- write SQL queries in Java without raw SQL strings
- build ActiveRecord-style models with one annotation
- express arithmetic and comparison SQL expressions using Java syntax
- perform has_one, has_many, and belongs_to relational queries
- add pagination to queries easily
- access databases in Spring Boot projects without writing boilerplate DAO code
- run data analysis queries with complex arithmetic expressions against relational databases

## When to choose
- your Java project involves heavy SQL arithmetic expressions you want type-safe in Java
- you want ActiveRecord-style rapid development with convention over configuration
- you want database access with minimal boilerplate and no XML configuration
- you use Spring Boot and want a lightweight ORM alternative

## When to avoid
- you need a mature ecosystem like Hibernate or JPA with broad community support
- your team prefers explicit SQL or a query DSL like jOOQ
- you need multi-tenant, caching, or advanced ORM features beyond ActiveRecord basics
- you are not on the JVM

## Facets
- artifact type: framework
- maturity: active
- function: orm, database, database-driver
- domain: databases, backend, web-development, developer-tools
- platform: jvm
- tags: activerecord, sql-programming, code-generation, intellij-plugin, spring-boot

## Member repositories
- braisdom/ObjectiveSql (main) score 32

## Provenance
- Observed fields: from GitHub, fetched 2026-08-28T04:04:09.564839+00:00.
- Health v2: computed from the inputs above; adoption is never an input.
- Inferred fields (summary, facets, guidance): AI-extracted, prompt v1, taxonomy v1, on 2026-08-30T05:05:34.349047+00:00, confidence not recorded.
  - readme: https://github.com/braisdom/ObjectiveSql (fetched 2026-08-28T04:04:09.564839+00:00, sha 53e737ab12f2)
- Data as of 2026-08-30T08:39:29.467469+00:00.