Write SQL
No query builders. Just SQL.
API documentation
Types for database queries with minimum fuss. Supports MySQL, PostgreSQL and SQLite.
import { Database, MySQLConnection } from "ts-query-model";
const db = new Database(
new MySQLConnection({
uri: "mysql://your-database-connection-string",
})
);
const myAwesomeModel = {
getUsers: db.getMany({
name: "get-all-users",
columns: {
id: columns.numberColumnAutoIncrement(),
name: columns.stringColumn(),
dateCreated: columns.dateColumn(),
isAwesome: columns.booleanIntColumn(),
},
query: ({ limit }: { limit: number }) =>
SQL`SELECT id, name, dateCreated, isAwesome FROM users LIMIT ${limit}`,
}),
};
const awesomeUsers = await myAwesomeModel.getUsers({ limit: 10 });