LiteORM review
A Go data-access library joining typed query building, CRUD, ORM, and migrations.
Reviewed by iTechGuides Editors · Editorial team · Updated Oct 2026
LiteORM is a Go data-access library for developers who want both explicit query building and a declarative ORM in one package. Its generics-first query API includes typed predicates, while the ORM front end supports model-based CRUD, associations, hooks, soft deletes, and schema migrations. The library is aimed at teams building Go applications that need typed database access without choosing exclusively between query-builder and ORM styles.
The breadth of the query API is a central strength: it covers joins, subqueries, common table expressions, set operations, streaming results, and raw SQL execution with bound arguments. Typed repository CRUD and a model-based ORM sit alongside those constructs, and both front ends share sessions and transactions. That makes LiteORM relevant when an application needs different levels of abstraction for different data-access tasks. Static type safety applies to its typed constructs; raw SQL remains an escape hatch for queries expressed directly.
LiteORM is open source, has a free plan, and is self-hosted; the published product details describe no paid tiers. Its documented SQL dialects are SQLite, Postgres, MySQL, and SQL Server. Additive, reviewable migrations are included, which may suit teams managing schema changes within the same library. The tradeoff is its Go focus: teams working in other languages should choose a language-compatible option, and teams seeking only a narrow query builder or only an ORM may prefer a more focused library. For Go teams that value typed CRUD alongside flexible query construction, LiteORM brings those approaches together.
LiteORM pros and cons
- Where it wins
- Typed predicates with joins, subqueries, CTEs, and set operations
- Query builder and ORM share sessions and transactions
- Supports SQLite, Postgres, MySQL, and SQL Server
- Where it doesn't
- Go-only, so it does not fit teams using other languages
- Raw SQL is available, but moves query logic outside typed constructs
- Combines query building and ORM, which may exceed needs for teams wanting only one style
LiteORM fact sheet, pricing and score →
Advertiser disclosure: iTechGuides is reader-supported. Vendors can pay for top positions in our rankings and for a place on other products' pages, and we may earn a commission when you click some links. How we rank.
Last updated · How we research and update