This small free software is a query builder of mysql for node or express JS developer
- You can customize it for yourself to use with other DBMS
- It's BEST for building API(s)!!!
Dependency: - const { format } = require('date-fns'); // a dependency for node js (date-functions)
List of Functions to be used:
- addRow
- updateRow
- deleteRow
- getRows
- getFirstRow
- getLastRow
- getNextRows
- getPrevRows
- getDistinctRows
- getRowMath
- searchRows
- updateSingleVal
You can install this with npm:
- npm i node-mysql-sql-builder