https://pql.dev/

[runreveal_]
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

[github-mar]See the code[discord]Join the community -

Try it in the browser

pql 

Reset

[users      | where l]
sql[WITH   "__subquery0"]

Examples

Where Operator

Note: unknown functions are passed through.  

Reset

[users     | where ev]
generated sql[WITH   "__subquery0"]

Summarize Operator

 

Reset

[records     | summar]
generated sql[SELECT   "type" AS "]

Join Operator

 

Reset

[users | project user]
generated sql[WITH   "__subquery0"]

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:

  * as
  * count
  * join
  * project
  * sort / order
  * summarize
  * take / limit
  * top
  * where

Functions

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

  * not
  * isnull
  * isnotnull
  * strcat
  * iff / iif
  * count
  * countif

Copyright (c) 2024 RunReveal, Inc. All rights reserved.