Hacker GitHub

← All repos

google/googlesql

View on GitHub ↗ ★ 2,642 C++

GoogleSQL(formerly ZetaSQL) - Analyzer Framework for SQL

23 mentions on Hacker News by 21 people: 8 stories, 15 comments · first 2019-04-24 · latest 2025-02-14

Mentions per year 23 mentions · busiest year 2019 (7)
20082026
AllStoriesComments NewestTopOldest
  1. …o_orderdate AS date, o_custkey AS user_id |> CALL ExtendDates(7) |> LIMIT 10; from the script here: https://github.com/google/zetasql/blob/master/zetasql/exampl...
    comment by jshute00 · 2025-02-14 · in SQL pipe syntax available in public preview in BigQuery
  2. It is, using table-valued functions (TVFs). There's an example at the bottom of this file: https://github.com/google/zetasql/blob/master/zetasql/exampl...
    comment by jshute4444 · 2024-08-30 · in Google's new pipe syntax in SQL
  3. …of larger queries, see here for all TPC-H queries in standard syntax and converted to pipe syntax: https://github.com/google/zetasql/blob/master/zetasql/exampl... And several more examples with pipe syntax here:…
    comment by jshute4444 · 2024-08-30 · in Google's new pipe syntax in SQL
  4. …which means you can freely mix with regular SQL and use pipes for just parts of your query. https://github.com/google/zetasql/blob/2024.08.2/docs/pipe-s... > Pipe syntax can be mixed with standard syntax in the same query. For example,…
    comment by svat · 2024-08-25 · in Pipe Syntax in SQL
  5. ZetaSQL’s docs for the ‘OVER’ keyword you mention: https://github.com/google/zetasql/blob/master/docs/window-fu... I disagree that the paper not mentioning ‘OVER’ implies that the paper authors secretly think pipe syntax is a bad idea.…
    comment by roryokane · 2024-08-25 · in Pipe Syntax in SQL
  6. …documentation covering pipe syntax last week, which I'm finding easier to follow than this paper: https://github.com/google/zetasql/blob/2024.08.2/docs/pipe-s...
    comment by simonw · 2024-08-24 · in Pipe Syntax in SQL
  7. I've just update the EBNF for rarilroad diagram here https://github.com/google/zetasql/issues/134#issuecomment-14... with the full grammar.
    comment by mingodad · 2024-08-24 · in Pipe Syntax in SQL
  8. …and the way these are used by clients are copy-and-paste. Something as thoughtful as ZetaSQL https://github.com/google/zetasql does not have mechanisms for structuring (modules, packages, interfaces). SQL will not, cannot evolve into such…
    comment by burakemir · 2022-11-27 · in Mangle, a programming language for deductive database programming
  9. If you don't want to do it yourself, there's this: https://github.com/google/zetasql Parsing is huge but it's amazing how small a part of the job it is. This library isn't even the half of it.
    comment by asdfasgasdgasdg · 2022-08-23 · in Parsing SQL
  10. …[2] https://github.com/duckdb/duckdb/blob/master/third_party/lib... [3] https://github.com/google/zetasql/blob/master/zetasql/parser...
    comment by flakiness · 2022-07-05 · in SQLGlot: SQL parser, transpiler, optimizer – translate to Presto, Spark, Hive
  11. …google.com/spanner/docs/postgresql/lexical And this is the zetasql lexical structure and syntax docs: https://github.com/google/zetasql/blob/master/docs/lexical.m... Notice that the new PG docs are an edit of the Zeta ones - evidence that…
    comment by wmitty · 2021-10-13 · in New PostgreSQL Interface for Cloud Spanner
  12. The Cloud Spanner SQL frontend/analyzer has been open sourced by google as ZetaSQL. https://github.com/google/zetasql It is amazingly good. You give it textual SQL (+ schema + all your function definitions) and it returns a really clean…
    comment by wmitty · 2021-10-12 · in New PostgreSQL Interface for Cloud Spanner
  13. …and found it to be very complex to work with. I found ZetaSQL to be a little easier to use. [1] https://github.com/google/zetasql
    comment by brinox · 2021-08-20 · in Let's write a compiler, part 5: A code generator
  14. …protos are an explicitly defined data type, since we use protos for pretty much everything. Docs: https://github.com/google/zetasql/blob/master/docs/one-pager... EDIT: BigQuery SQL is described as "compliant with the SQL 2011 standard and…
    comment by joatmon-snoo · 2019-05-22 · in ZetaSQL – A SQL Analyzer Framework from Google
  15. Direct link to the documentation one-pager: https://github.com/google/zetasql/blob/master/docs/one-pager...
    comment by robfig · 2019-05-22 · in ZetaSQL – A SQL Analyzer Framework from Google