Google has started the process of open sourcing ZetaSQL, a SQL front-end that consists of a parser and analyzer. It is designed to work with a variety of back ends (…)
The fact that ZetaSQL is used as parser and analyzer for Google’s BigQuery’s Standard SQL dialect is what makes this release interesting.
This is kind of a big deal: Google has open-sourced the C++ code that parses BigQuery SQL and will soon become the parser for other SQL products it operates as well. This allows other products in the ecosystem to not just be able to treat SQL as a chunk of opaque text, but to actually understand it. This could result in better SQL editor front-ends, better query auto-formatters, better SQL error-handling…and much more. Very very cool.