gritql
TypeScript icon, indicating that this package has built-in type declarations

3.0.0-beta.24 • Public • Published

gritql | A query library for your SQL ddatabase.

The library is built to query simple dimension/metric based tables. It allows to fetch data in the form you want it.

example

Query:

query customers{
  fetch(country: US){
    plan {
      revenue: sum(a: planPrice)
    }
  }
}

Response:

{
  free: {
    revenue: 0
  },
  small: {
    revenue: 9000
  },
  large: {
    revenue: 380
  },
  pro: {
    revenue: 500
  }
}

Table Schema: Customer Name, plan, planPrice

installation

query table

multiple queries

fetch an Array

sort

dates

group

aggregation functions

sum

divide

share

distinct

Readme

Keywords

none

Package Sidebar

Install

npm i gritql

Weekly Downloads

72

Version

3.0.0-beta.24

License

MIT

Unpacked Size

382 kB

Total Files

61

Last publish

Collaborators

  • edjafarov
  • strukevich.y