Relational Database Models & Query Builder for Node JS
~ $
Insert, select, update & delete Data from Postgresql and MySQL with complex nested where conditions.
Create class-based models for your tables with built-in features.
Designed to perform complex and nested where statements, ordering and grouping.
Specify certain fields to be selectable, allow HTML tags to be stored in database for certain fields, add default values on insert and update, and more.
Extract data in various ways: list, select one column, first item, slicing, chunking, pagination.
This package is light and can be added on APIs, web workers, .. etc.
Read our documentation to know how to optimize this awesome features.
Documentationraw()
function to pass raw queries.distinct
function to pass a column to DISTINCT ON(col)
primaryKey
property in Model class.