dbgate-sqltree
v6.1.0
Published
JavaScript/TypeScript SQL query-builder library
Downloads
1,140
Maintainers
Readme
dbgate-sqltree
JavaScript/TypeScript SQL query-builder library
dbgate-sqltree hold query definition in RAW JSON objects.
Sample usage
const { treeToSql, dumpSqlSelect } = require("dbgate-sqltree");
const dbgatePluginMysql = require("dbgate-plugin-mysql");
const select = {
commandType: "select",
from: {
name: {
pureName: "Album",
},
},
columns: [
{
exprType: "column",
columnName: "name",
},
],
orderBy: [
{
exprType: "column",
columnName: "id",
direction: "ASC",
},
],
};
const sql = treeToSql(dbgatePluginMysql.driver, select, dumpSqlSelect);
console.log("Generated query:", sql);
See TypeScript definitions for complete list of available SQL command options.
Installation
yarn add dbgate-sqltree