5.2.7 • Published 7 months ago

dbgate-sqltree v5.2.7

Weekly downloads
23
License
MIT
Repository
github
Last release
7 months ago

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
sqlmssqlmssqlpostgresqlquerydbgate
lodash
@infinitebrahmanuniverse/nolb-dbg@everything-registry/sub-chunk-1453@zalastax/nolb-dbgdbgate-toolsdbgate-apidbgate-datalib
5.2.7

7 months ago

5.2.7-alpha.1

8 months ago

5.2.6

12 months ago

5.2.5

1 year ago

5.2.4-alpha.1

1 year ago

5.2.4

1 year ago

5.2.3

1 year ago

5.1.7-alpha.13

1 year ago

5.1.7-alpha.14

1 year ago

5.2.2-alpha.13

1 year ago

5.2.2-alpha.12

1 year ago

5.2.2-alpha.11

1 year ago

5.2.2

1 year ago

5.2.1

1 year ago

5.2.0

1 year ago

5.1.6

1 year ago

5.1.5

2 years ago

5.1.4

2 years ago

5.1.3

2 years ago

5.1.2

2 years ago

5.1.1

2 years ago

5.0.9

2 years ago

5.0.8

2 years ago

5.0.7

2 years ago

5.0.6

2 years ago

5.0.6-alpha.2

2 years ago

5.1.0

2 years ago

5.0.4-alpha.2

2 years ago

5.0.4-alpha.7

2 years ago

5.0.4-alpha.8

2 years ago

5.0.0-alpha.1

2 years ago

5.0.5

2 years ago

5.0.4

2 years ago

5.0.3

2 years ago

5.0.2

2 years ago

5.0.1

2 years ago

5.0.0

2 years ago

4.8.8

2 years ago

4.8.5

2 years ago

4.8.4

2 years ago

4.8.7

2 years ago

4.8.6

2 years ago

4.7.4-alpha.12

2 years ago

4.7.4-alpha.10

2 years ago

4.7.4-alpha.15

2 years ago

4.7.4-alpha.16

2 years ago

4.7.4-alpha.14

2 years ago

4.7.2

2 years ago

4.7.4

2 years ago

4.7.3

2 years ago

4.7.4-alpha.1

2 years ago

4.7.4-alpha.3

2 years ago

4.7.4-alpha.2

2 years ago

4.7.4-alpha.8

2 years ago

4.7.4-alpha.7

2 years ago

4.8.1

2 years ago

4.8.0

2 years ago

4.8.3

2 years ago

4.8.2

2 years ago

4.7.3-alpha.3

2 years ago

4.7.3-alpha.5

2 years ago

4.7.3-alpha.2

2 years ago

4.7.1

2 years ago

4.6.1

2 years ago

4.4.3

2 years ago

4.6.0

2 years ago

4.4.2

2 years ago

4.4.5-alpha.1

2 years ago

4.6.3

2 years ago

4.6.2

2 years ago

4.4.4

2 years ago

4.5.0

2 years ago

4.7.0

2 years ago

4.5.1

2 years ago

4.4.1

2 years ago

4.4.0

2 years ago

4.4.0-alpha.2

3 years ago

4.3.4

3 years ago

4.4.0-alpha.1

3 years ago

4.3.3

3 years ago

4.3.2

3 years ago

4.3.1

3 years ago

4.3.0

3 years ago

4.2.8

3 years ago

4.2.7

3 years ago

4.2.6

3 years ago

4.2.5

3 years ago

4.2.4

3 years ago

4.1.9

3 years ago

4.1.10

3 years ago

4.1.11

3 years ago

4.1.12

3 years ago

4.2.3

3 years ago

4.2.2

3 years ago

4.2.1

3 years ago

4.2.0

3 years ago

4.1.8

3 years ago

4.1.7

3 years ago

4.1.4

3 years ago

4.1.3

3 years ago

4.1.6

3 years ago

4.1.5

3 years ago

4.1.1

3 years ago

4.1.0

3 years ago

4.0.3

3 years ago

4.0.1

3 years ago

4.0.0

3 years ago

4.0.2

3 years ago

3.9.6

3 years ago

3.9.6-alpha.14

3 years ago

3.9.6-alpha.13

3 years ago

3.9.6-alpha.12

3 years ago

3.9.6-alpha.11

3 years ago

3.9.6-alpha.10

3 years ago

3.9.6-alpha.9

3 years ago

3.9.6-alpha.8

3 years ago

3.9.6-alpha.7

3 years ago

1.0.4

3 years ago

1.0.3

3 years ago

1.0.2

3 years ago

1.0.1

3 years ago

1.0.0

3 years ago