LiteORM
LiteORM: A Go data-access library joining typed query building, CRUD, ORM, and migrations. Ranked #29 of 51 in Database Query Builders by our editors (6.1/10); pricing: Free plan; best for go teams seeking typed CRUD and ORM capabilities.
At a glance
- Editor score6.1 / 10
- PricingFree plan
- Best forGo teams seeking typed CRUD and ORM capabilities
- Free planYes
- Paid fromNone
- Type safetyStatic
- Facts checked4 Oct 2026
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
Our verdict on LiteORM
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.
Your product? Our editors can test LiteORM in depth and publish a review, labelled as paid · from $99/mo →
LiteORM pricing
LiteORM fact sheet
| Free plan | Yes |
|---|---|
| Paid from | None |
| Languages | Go |
| SQL dialects | SQLite, Postgres, MySQL, SQL Server |
| Type safety | Static |
| Async queries | Not verified |
| Raw SQL support | Yes |
| Compile without execution | Not verified |
| Deployment | Self-hosted |
| Built for | Solo, Small business, Mid-market, Enterprise (editorial estimate) |
| Pricing | Free plan |
| Website | liteorm.com |
| Facts checked | 4 Oct 2026 |
Alternatives to LiteORM
- jOOQA fluent SQL framework for JVM teams that want generated, type-safe database access.9.3
- SQLAlchemySQL construction, ORM, and database services for Python applications.9.1
- JetBrains ExposedA free, open-source Kotlin library with a type-safe SQL DSL and JDBC and R2DBC access.9.0
See all LiteORM alternatives →
Used LiteORM? Be the first to review it
The editor score above is our own research. What this page doesn't have yet is a reader's view — what you used LiteORM for, what worked and what didn't. No stars are seeded and no review is paid for; an editor reads every one before it appears.
Write a reviewTwo minutes · verified accounts only · read by an editor before it appears
Featured on iTechGuides
LiteORM is listed in our Database Query Builders directory. Add the badge to your site — it links back to this page.
<a href="https://www.itechguides.com/products/liteorm/"><img src="https://www.itechguides.com/best/badge/liteorm.svg" alt="Featured on iTechGuides" width="230" height="46"></a>
Reviewed by iTechGuides Editors · Editorial team · Updated Oct 2026
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
