Hi community, I have been working on supporting ZetaSQL[1] as a SQL dialect in BeamSQL. ZetaSQL is a SQL analyzer open sourced by Google. Here is ZetaSQL's documentation[2].
Birfely, the design of integrating ZetaSQL with BeamSQL is, I made a plugable query planner interface in BeamSQL, and we can easily plug in a new planner[3] (in my case, ZetaSQL planner). Actually anyone can add new planners by this way (e.g. PostgreSQL dialect). I want to contribute ZetaSQL planner and its related code(~10k) to Beam repo(#9210 <https://github.com/apache/beam/pull/9210>). This contribution barely touch existing Beam code (because the idea is plugable planner). *Acknowledgement* Thanks to all the people who provided help during Beam ZetaSQL development: Matthew Brown, Brian Hulette, Andrew Pilloud, Kenneth Knowles, Anton Kedin and Mikhail Gryzykhin. This list is not exhausted and also thanks to contributions which are not listed. [1]: https://github.com/google/zetasql [2]: https://github.com/google/zetasql/tree/master/docs [3]: https://github.com/apache/beam/blob/master/sdks/java/extensions/sql/src/main/java/org/apache/beam/sdk/extensions/sql/impl/QueryPlanner.java -Rui
