@parse-it/database NPM

@parse-it/database

A 2-way query builder and SQL parser for TypeScript, designed to work with BigQuery and PostgresSQL.

Installation

You can install the package using npm:

npm install @parse-it/database

Usage

Here is a basic example of how to use the query builder:

import { QueryBuilder, QueryBuilderMode } from "@parse-it/database"
import { parseBigQuery } from "@parse-it/database"

// Sample SQL query
const sqlQuery = `
WITH RegisteredUsers AS (
    SELECT 
        id,
        registrationDate
    FROM UserSnapshots
    WHERE status = 'Active' 
      AND registrationDate IS NOT NULL
),
EarliestRegistrationDates AS (
    SELECT 
        id,
        MIN(registrationDate) AS earliestRegistrationDate
    FROM RegisteredUsers
    GROUP BY id
),
CurrentlyActiveUsers AS (
    SELECT 
        id
    FROM UserSnapshots
    WHERE status = 'Active'
    GROUP BY id
)
SELECT 
    DATEDIFF(DAY, e.earliestRegistrationDate, GETDATE()) AS daysSinceRegistration
FROM EarliestRegistrationDates e
JOIN CurrentlyActiveUsers c
  ON e.id = c.id;`

const queryNode = parseBigQuery(sqlQuery)

const queryBuilder = new QueryBuilder(QueryBuilderMode.NAMED)
const query = queryBuilder.build(queryNode)

console.log(query)