dbgate-sqltree
Advanced tools
Changelog
5.2.3
Readme
JavaScript/TypeScript SQL query-builder library
dbgate-sqltree hold query definition in RAW JSON objects.
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.
yarn add dbgate-sqltree
FAQs
JavaScript/TypeScript SQL query-builder library
The npm package dbgate-sqltree receives a total of 137 weekly downloads. As such, dbgate-sqltree popularity was classified as not popular.
We found that dbgate-sqltree demonstrated a healthy version release cadence and project activity because the last version was released less than a year ago. It has 1 open source maintainer collaborating on the project.
Did you know?
Socket for GitHub automatically highlights issues in each pull request and monitors the health of all your open source dependencies. Discover the contents of your packages and block harmful activity before you install or update your dependencies.
Security News
Cyber extortion in the US and Canada hit record levels in 2023, with ransomware attacks surging and median ransom demands skyrocketing, though fewer companies are choosing to pay ransoms.
Security News
Ecma TC39 is meeting this week and has moved key ECMAScript proposals forward, advancing Deferred Import Evaluation, Error.isError(), RegExp Escaping, and Promise.try to the next stages.
Security News
Researchers have demonstrated that teams of LLM agents can exploit zero-day vulnerabilities with a 53% success rate, and the costs of using AI to do so are rapidly becoming more affordable than hiring a human penetration tester.