Pql, a pipelined query language that compiles to SQL (written in Go)

• pql

  4 645 7.6 Go

  Pipelined Query Language

  

• SaaSHub

  www.saashub.com featured

  SaaSHub - Software Alternatives and Reviews. SaaSHub helps you find the best software and product alternatives

  

• prql

  121 10,038 9.7 Rust

  PRQL is a modern language for transforming data — a simple, powerful, pipelined SQL replacement

  

  > Looks like PRQL doesn't have a Go library so I guess they just really wanted something in Go?

  There's some C bindings and the example in the README shows integration with Go:

  https://github.com/PRQL/prql/tree/main/prqlc/bindings/prqlc-...

• tenzir

  15 658 10.0 C++

  Tenzir is the data pipeline engine for security teams.

  

  We're in the middle of getting TQL v2 [] out of the door with support for expressions and more advanced control flow, e.g., match-case statements. There's a blog post [#] about the core design of the engine as well.

  While it's a general-purpose ETL tool, we're targeting primary operational security use case where people today use Splunk, Sentinel/ADX, Elastic, etc. So some operators are very security'ish, like Sigma, YARA, or Velociraptor.

  [] https://github.com/tenzir/tenzir/blob/64ef997d736e9416e859bf...

  [#] https://docs.tenzir.com/blog/five-design-principles-for-buil...

• potygen

  4 98 2.8 TypeScript

  Postgres SQL Parser and type generator

  I also wrote a parser (in typescript) for postgres (https://github.com/ivank/potygen), and it turned out quite the educational experience - Learned _a lot_ about the intricacies of SQL, and how to build parsers in general.

  Turned out in webdev there are a lot of instances where you actually want a parser - legacy places where they used to save things in plane text for example, and I started seeing the pattern everywhere.

  Where I would have reached for some monstrosity of a regex to solve this, now I just whip out a recursive decent parser and call it a day, takes surprisingly small amount of code! (https://github.com/dmaevsky/rd-parse)

• rd-parse

  1 103 0.0 JavaScript

  Generic recursive-descent parser in Javascript

  I also wrote a parser (in typescript) for postgres (https://github.com/ivank/potygen), and it turned out quite the educational experience - Learned _a lot_ about the intricacies of SQL, and how to build parsers in general.

  Turned out in webdev there are a lot of instances where you actually want a parser - legacy places where they used to save things in plane text for example, and I started seeing the pattern everywhere.

  Where I would have reached for some monstrosity of a regex to solve this, now I just whip out a recursive decent parser and call it a day, takes surprisingly small amount of code! (https://github.com/dmaevsky/rd-parse)

• Preql

  16 613 0.0 Python

  An interpreted relational query language that compiles to SQL.

Suggest a related project