SQL pipe syntax available in public preview in BigQuery

This page summarizes the projects mentioned and recommended in the original post on news.ycombinator.com

CodeRabbit: AI Code Reviews for Developers
Revolutionize your code reviews with AI. CodeRabbit offers PR summaries, code walkthroughs, 1-click suggestions, and AST-based analysis. Boost productivity and code quality across all major languages with each PR.
coderabbit.ai
featured
SaaSHub - Software Alternatives and Reviews
SaaSHub helps you find the best software and product alternatives
www.saashub.com
featured
  1. prql

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

    Relatedly, PRQL is a lovely pipe-oriented syntax for SQL DBs: https://prql-lang.org/

    Their syntax is a lot cleaner, because it's a new language -- it's not backwards-compatible with SQL. But then again, they don't have the resources of Google behind them.

  2. CodeRabbit

    CodeRabbit: AI Code Reviews for Developers. Revolutionize your code reviews with AI. CodeRabbit offers PR summaries, code walkthroughs, 1-click suggestions, and AST-based analysis. Boost productivity and code quality across all major languages with each PR.

    CodeRabbit logo
  3. duckdb-psql

    A piped SQL for DuckDB

  4. super

    An analytics database that puts JSON and relational tables on equal footing

  5. honeysql

    Turn Clojure data structures into SQL

  6. ClickBench

    ClickBench: a Benchmark For Analytical Databases

    Pipe-based query syntax has been appeared a better alternative to SQL in many databases, because it is easier to read, write and maintain. The only thing is that this syntax isn't standardized among databases yet.

    BTW, we at VictoriaLogs also use pipe-based syntax for LogsQL query language [1] since the first release in 2023. Recently I wrote an SQL -> LogsQL conversion guide [2], which has been appeared quite clear and easy to follow. This guide was written during the conversion of SQL queries to LogsQL at ClickBench benchmark from ClickHouse [3].

    [1] https://docs.victoriametrics.com/victorialogs/LogsQL/

    [2] https://docs.victoriametrics.com/victorialogs/sql-to-logsql/

    [3] https://github.com/ClickHouse/ClickBench/tree/main/victorial...

  7. SaaSHub

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

    SaaSHub logo
NOTE: The number of mentions on this list indicates mentions on common posts plus user suggested alternatives. Hence, a higher number means a more popular project.

Suggest a related project

Related posts

  • SQL queries don't start with SELECT (2019)

    1 project | news.ycombinator.com | 14 Mar 2025
  • Show HN: Hydra – serverless realtime analytics on Postgres

    1 project | news.ycombinator.com | 12 Mar 2025
  • Why Not SQL: The Origin of ScopeQL

    1 project | news.ycombinator.com | 11 Mar 2025
  • MariaDB to PostgreSQL: Lessons & Challenges

    1 project | dev.to | 14 Feb 2025
  • Backblaze Drive Stats for 2024

    3 projects | news.ycombinator.com | 11 Feb 2025

Did you know that Clojure is
the 28th most popular programming language
based on number of references?