coral-sql

The nodejs module for building SQL by complec and related like coral.

Installation

> npm install coral-sql
Copy

> yarn add coral-sql
Copy

Usage

import { createBuilder, unescape } from 'coral-sql'

const [sql, bindings] = createBuilder()
  .column('age')
  .column(unescape('COUNT(*)'), 'value')
  .from('users')
  .where('enabled', true)
  .groupBy('age')
  .having('value', '>=', 10)
  .orderBy('value', 'desc')
  .toSQL()

const query = await connection.query(sql, bindings)

// sql:
//   SELECT
//     `age`,
//     COUNT(*) AS `value`
//   FROM
//     `users`
//   WHERE
//     (`enabled` = ?)
//   GROUP BY
//     `age`
//   HAVING
//     (`value` >= ?)
//   ORDER BY
//     `value` DESC
// bindings: [1, 10]
Copy

Documentation

Document is here.