search

GoogleCloudPlatform / zetasql-toolkit

The ZetaSQL Toolkit is a library that helps users use ZetaSQL Java API to perform SQL analysis for multiple query engines, including BigQuery and Cloud Spanner.
Apache License 2.0
39 stars 10 forks source link

pipe-syntax SQL support #110

Open grzegorz8 opened 2 days ago

grzegorz8 commented 2 days ago

Hi! I wonder if pipe-syntax SQL is supported by the toolkit.

For testing purposes I modified query in AnalyzeWithoutCatalog example:

SELECT column from t;

to

FROM t
|> SELECT column;

But when I run the example I get: Syntax error: Unexpected FROM.

We found that there is: FEATURE_PIPES = 101; defined in https://github.com/google/zetasql/blob/a516c6b26d183efc4f56293256bba92e243b7a61/zetasql/public/options.proto#L658 but it is not available in ZetaSQLOptions in zetasql java client. Is there any reason why it is unavailable?

Thanks in advance!

grzegorz8 commented 1 day ago

I see that LanguageFeature.FEATURE_PIPES is available in zetasql-client as of version 2024.08.1 but zetasql-toolkit still uses the older version 2024.03.1.