pql version 0.1.0 is out! Read the blog

pql |

pql is an open-source pipelined query language that translates to SQL and is written in Go

See the code

Join the community

Try it in the browser

pql

Reset

sql

WITH
  "__subquery0" AS (
    SELECT
      *
    FROM
      "users"
    WHERE
      like ("email", 'gmail')
  )
SELECT
  COUNT(*) AS "count()"
FROM
  "__subquery0";

Examples

Where Operator

Note: unknown functions are passed through.

Reset

generated sql

WITH
  "__subquery0" AS (
    SELECT
      *
    FROM
      "users"
    WHERE
      "eventTime" > minus (now (), toIntervalDay (1))
  )
SELECT
  "user_id" AS "user_id",
  "user_email" AS "user_email"
FROM
  "__subquery0";

Summarize Operator

Reset

generated sql

SELECT
  "type" AS "type",
  max("created_at") AS "newest"
FROM
  "records"
GROUP BY
  "type";

Join Operator

Reset

generated sql

WITH
  "__subquery0" AS (
    SELECT
      "id" AS "user_id",
      "user_email" AS "user_email"
    FROM
      "users"
  ),
  "userTable" AS (
    SELECT
      *
    FROM
      "__subquery0"
  ),
  "__subquery2" AS (
    SELECT
      *
    FROM
      "workspace_members"
  )
SELECT
  *
FROM
  "userTable" AS "$left"
  LEFT JOIN "__subquery2" AS "$right" ON "$left"."user_id" = "$right"."user_id";

What is pql?

pql is an open-source pipelined query language that compiles to SQL. It's written in Go and released under the Apache 2.0 license.

Why pql?

pql is designed with the Unix philosophy in mind. It's designed to be a small, efficient, and make developing queries simple by piping the result of each statement into the next.

Where's the code?

The pql source code is available on GitHub. You can find it here!

Why did we build pql?

Splunk, Sumologic, and Microsoft all have proprietary languages similar to pql. Open source databases can't compete because they all support SQL. pql is meant to bridge that gap by providing a simple but powerful interface.

Language

The language syntax is based on Microsoft's kql with few exceptions. The following tabular operators are supported:

Functions

The following functions are specifically handled. Functions not in this list will be passed through to the underlying SQL engine.