prql-js

Currently these functions are exposed


function prql_to_pl(prql_query: string): string;
function pl_to_rq(pl_json: string): string;
function rq_to_sql(rq_json: string): string;

Direct usage

const prqljs = require("prql-js");
const sql = prqljs.compile(`from employees | select first_name`);
console.log(sql);

Options

const opts = new prql.CompileOptions();
opts.target = "sql.mssql";
opts.format = false;
const sql = prqljs.compile(`from employees | take 10`, opts);
console.log(sql);

Template literal with newlines

const prqljs = require("prql-js");
const prql = (string) => prqljs.compile(string[0] || "");
const sql = prql`
    select first_name
`;
console.log(sql);

<html>
  <head>
    <script src="./node_modules/prql-js/dist/web/prql_js.js"></script>
    <script>
      const { compile } = wasm_bindgen;
      async function run() {
        await wasm_bindgen("./node_modules/prql-js/dist/web/prql_js_bg.wasm");
        const sql = compile("from employees | select first_name");
        console.log(sql);
      run();
    </script>
  </head>
  <body></body>

import compile from "prql-js/dist/bundler";
const sql = compile(`from employees | select first_name`);
console.log(sql);

Errors are returned as following object, serialized as a JSON array:

These errors can be caught as such:

try {
  const sql = prqlJs.compile(`from employees | foo first_name`);
} catch (error) {
  const errorMessages = JSON.parse(error.message).inner;
  console.log(errorMessages[0].display);
  console.log(errorMessages[0].location);
}

npm run build

This builds Node, bundler and web packages in the dist path.

Test:

npm test

This uses to generate bindings1.

6.4. JavaScript

prql-js