# requery/requery

requery - modern SQL based query & persistence for Java / Kotlin / Android

Repository: https://github.com/requery/requery
Canonical: https://ross.abutalabs.com/products/requery
Language: Java
License: Apache-2.0
License Family: permissive
Topics: sql, persistence, java, kotlin, android, mysql, postgres, sqlite, rxjava, jdbc, oracle
Last push: 2026-02-09T08:58:28+00:00

## Health v2 (maintenance only)
Score: 52/100 (v2, computed 2026-09-03T02:20:16.233290+00:00)
- activity 66, release rhythm 8, longevity 100
- inputs: {"age_days": 3946, "days_push": 205, "days_rel": null, "gap_med": null, "n_releases_24m": 0}
- flags: none
- formula: round(0.45*activity + 0.35*rhythm + 0.20*longevity); archived -> min(score, 10)

## Adoption (not part of the score)
Stars 3124, forks 239 (observed 2026-08-28T04:07:44.381347+00:00)

## What it is
requery is a lightweight ORM and SQL query generator for Java, Kotlin, and Android that maps annotated entities to relational databases via JDBC. It supports a type-safe DSL for queries, relationships, RxJava observables, and code generation from abstract classes, interfaces, or immutable types.

## Use cases
- persist Java objects to SQLite on Android
- generate type-safe SQL queries from annotated entities
- use RxJava observables for database queries
- map Kotlin data classes to a MySQL or Postgres database
- replace heavy ORMs with a lightweight persistence layer
- generate entity classes from interfaces or AutoValue types

## When to choose
- you want compile-time code generation instead of runtime reflection
- you need reactive database access with RxJava or Java 8 streams
- you are building an Android app with SQLite persistence
- you prefer a type-safe DSL over raw SQL strings

## When to avoid
- you need a mature, actively developed ORM with a large ecosystem
- you want NoSQL or non-relational persistence
- your project uses newer Java features beyond the library's supported baseline
- you need advanced ORM features like multi-tenant caching or sharding

## Facets
- artifact type: library
- maturity: maintenance
- function: orm, database, database-driver, serialization
- domain: databases, mobile-development, backend, developer-tools
- platform: jvm
- tags: sql-generator, rxjava, jdbc, annotation-processing, sqlite, object-mapping, android

## Member repositories
- requery/requery (main) score 52

## Provenance
- Observed fields: from GitHub, fetched 2026-08-28T04:07:44.381347+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-30T07:26:32.191657+00:00, confidence not recorded.
  - readme: https://github.com/requery/requery (fetched 2026-08-28T04:07:44.381347+00:00, sha fb48b1210335)
- Data as of 2026-08-30T08:39:29.467469+00:00.