1.0.0 • Published 3 years ago

sql-string-query-builder v1.0.0

Weekly downloads
-
License
ISC
Repository
-
Last release
3 years ago

Simple SQL Query Builder

This SQL query builder accepts:

  • A partially built query template
  • An queryParams object with values which replace the placeholders with intended values

Example:

let queryTemplate =
  "INSERT INTO vegetables (name, quantity) values (@name, @quantity);";

let queryParams = {
  "@name": "apple",
  "@quantity": 2,
};

let query = buildQuery(queryTemplate, queryParams);

// result -> "NSERT INTO vegetables (name, quantity) values(apple, 2);
1.0.0

3 years ago