SeaQL/sea-orm

The developer-facing surface spans entity modeling, query execution, persistence, schema management, and code generation. Optional features add access control and analytical data conversion. Examples demonstrate HTTP, JSON-RPC, OpenAPI, synchronous database use, and checkpointed computation; this catalog describes inspected capabilities rather than an exhaustive inventory.

• ActiveModel supports insert, update, save, and delete with lifecycle hooks; nested relation state distinguishes untouched relations, additive child writes, and replacement that deletes omitted children.
  src/entity/active_model.rs#L225-L235src/entity/active_model.rs#L347-L403src/entity/active_model.rs#L448-L457src/entity/active_model_ex.rs#L25-L61
• Select APIs offer optional or required single-row results, vectors, and streams; pagination supports LIMIT/OFFSET pages and keyset cursors with before/after boundaries and key-arity validation.
  src/executor/select.rs#L864-L906src/database/connection.rs#L67-L94src/executor/paginator.rs#L53-L99src/executor/cursor.rs#L67-L114
• Relation APIs cover has-one, has-many, junction-table many-to-many, and self-reference; LoaderTrait batches related queries, while raw_sql! constructs a Statement containing separate SQL and values for three supported dialects.
  CLAUDE.md#L41-L63src/query/loader.rs#L26-L32src/query/loader.rs#L89-L122sea-orm-macros/src/raw_sql.rs#L24-L47
• SchemaBuilder offers initial apply and additive experimental sync; migration commands include init, generate, fresh, refresh, reset, status, up with optional steps, and down defaulting to one step.
  src/schema/builder.rs#L77-L92src/schema/builder.rs#L254-L270sea-orm-cli/src/cli.rs#L108-L164
• generate entity exposes table selection, hidden-table inclusion, schema selection, Serde controls, custom derives and attributes, Seaography helpers, experimental preservation, and optional Mermaid output; EntityWriter supports compact, expanded, frontend, and dense formats.
  sea-orm-cli/src/cli.rs#L166-L204sea-orm-cli/src/cli.rs#L247-L273sea-orm-cli/src/cli.rs#L309-L388sea-orm-codegen/src/entity/writer.rs#L71-L109
• Optional RBAC loads permission data into an engine and produces user-bound restricted connections; authorization considers inherited roles, explicit user overrides, exact grants, and wildcard permissions/resources.
  src/database/db_connection.rs#L615-L648src/rbac/engine/mod.rs#L274-L335tests/rbac_tests.rs#L83-L107
• Arrow-enabled entities convert ActiveModels to and from RecordBatch; the synchronous Parquet example writes and reads a file before inserting restored rows into SQLite, and pi_spigot exposes digit count, checkpoint interval, and database-path options.
  sea-orm-sync/examples/parquet_example/src/main.rs#L59-L101sea-orm-sync/examples/parquet_example/src/main.rs#L114-L121sea-orm-sync/examples/pi_spigot/src/main.rs#L5-L34
• Inspected examples provide Actix post-list/create/edit/delete pages, JSON-RPC Post.List/Insert/Update/Delete methods, and Rocket OpenAPI documentation through Swagger UI and RapiDoc; README also enumerates Axum, GraphQL, Loco, Poem, Salvo, Tonic, and Seaography integrations.
  examples/actix_example/api/src/lib.rs#L37-L89examples/actix_example/api/src/lib.rs#L92-L153examples/jsonrpsee_example/api/src/lib.rs#L22-L39README.md#L42-L53