Inquire is a lightweight TypeScript SQL builder. It helps you define schemas, build SQL queries, and execute them through a connection wrapper. It does not model records, relationships, or unit-of-work behavior for you.
If you are evaluating the library, start with the quick start. If you already know what you need, jump to the API reference.
- Quick start: create a table, insert rows, and run a typed query.
- Mental model: how
Engine, builders, dialects, and connections fit together. - Schema changes: create, alter, diff, rename, drop, and truncate tables.
- JSON fields and filters: work with JSON columns across supported dialects.
- Raw SQL and transactions: drop down to hand-written SQL when the builder is not enough.
- API reference: exact class, method, and package details.
Use Inquire when you want:
- typed query results in TypeScript
- one small API for MySQL, PostgreSQL, SQLite, and PGlite
- schema helpers without adopting a full ORM
- the option to mix builders and raw SQL
Use something else if you want:
- model instances and change tracking
- relationship loading
- migrations with a full workflow and state management
- repository or domain abstractions generated by the library
The quick start shows one happy path:
- create a connection wrapper
- build an
Engine - create a table
- insert data
- query typed results
After that, use the guides and API reference as lookup material.