Also setting analyzer options doesn't seem to be possible. However, from what I see here, the local service doesn't have the full functionalities of the Java client, mainly creating simple catalog with tables and columns to analyze any SQL statement. Res = conn.ExtractTableNamesFromStatement(req) Sql_statement=sql, options=language_options

Language_options.supported_statement_kinds.pop() In that way it turns into a table, which is much easier to work with. Pivot Data With this column, you can now pivot the data. # Used to allow ZetaSQL parser to parse `CREATE TABLE AS` statments Select column Index Go to tab Add column -> Standard (operation) -> click Modulo Fill in the number 5 The added column now shows a series starting from 0 and going to 4, before repeating the pattern again.

Language_options = conn.GetLanguageOptions( It is possible to extract referenced tables using the following simplified Python code and the local service: import zetasql.local_service as zql stack Stack data from input table or timetable into one variable in output table or timetable collapse all in page Syntax S stack (U,vars) S stack (U,vars,Name,Value) S,iu stack ( ) Description example S stack (U,vars) converts the input table or timetable, U, into the stacked table or timetable, S. We are using a Python client binding for ZetaSQL GRPC local service in our application to analyze statements and extract referenced tables and output columns.

Stack openoffice columns in table