dbgate-sqltree

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

Changelog

5.5.6

• FIXED: DbGate process consumes 100% after UI closed - Mac, Linux (#917, #915)
• FIXED: Correctly closing connection behind SSH tunnel (#920)
• FIXED: Updating MongoDB documents on MongoDB 4 (#916)
• FIXED: (Premium) DbGate container correctly waits for underlying storage database, if database container is started after dbgate container is started
• FIXED: (Premium) Better handling of connection storage errors