google / zetasql

ZetaSQL - Analyzer Framework for SQL
Apache License 2.0
2.28k stars 214 forks source link

Parsing arguments #121

Closed leoch20 closed 1 year ago

leoch20 commented 1 year ago

Hello, I have a query with a parameter that I'm trying to pass through Analyzer.analyzeStatement()

Is there any way to set the parameters to a dummy value or just ignore them?

select *
from table_name
where date_month between @BEGINNINGMONTH and @ENDMONTH

At the moment I get this error:

com.google.zetasql.SqlException: Query parameter 'BEGINNINGMONTH' not found 
leoch20 commented 1 year ago

I got what I needed in https://github.com/google/zetasql/issues/22