dynamic-query-builder

Prisma query builder

buildPrismaQuery Function

The buildPrismaQuery function builds a Prisma query based on flat filter conditions.

Mongoose query builder

buildMongooseQuery Function

The buildMongooseQuery function builds a Mongoose query based on flat filter conditions.

TypeORM query builder

buildTypeORMQuery Function

The buildTypeORMQuery function builds a TypeORM query based on flat filter conditions.

Sequelize query builder

buildSequelizeQuery Function

The buildSequelizeQuery function builds a Sequelize query based on flat filter conditions. Here you also need to provide Op object from sequelize.

Usage

This functions take an object of flat filter conditions and converts it into a ORM query object. The filter conditions are expected to be in the format of field_condition: value, where field is the name of the field to filter on and condition is the type of filter to apply.

Supported Conditions

• lt: Less than
• lte: Less than or equal to
• gt: Greater than
• gte: Greater than or equal to
• between: Between two values (requires an array with two values)
• contains: Contains a value (case-insensitive)
• c: Alias for contains
• caseSensitiveContains: Contains a value (case-sensitive)
• csc: Alias for caseSensitiveContains
• ne: Not equal to
• eq: Equal to
• : Equal to (default condition)
• neContains: Does not contain a value (case-insensitive)
• nec: Alias for neContains
• in: In a list of values
• nin: Not in a list of values

Parameters

• filters (Object): The flat filter conditions.

Returns

• (Object): The ORM query object.

Throws

• Error: Throws an error if the between filter does not receive an array with two values.

Example

const filters = {
  age_gt: 30,
  name_contains: "John",
  status_in: ["active", "pending"],
};

const query = buildPrismaQuery(filters);
console.log(query);