This is my test query SELECT IF(CAST(age as numeric) < 0.5, name, last_name) as customer_name FROM 307320.test_dataset.customers
On Fri, Dec 17, 2021 at 5:47 AM Maxim Gramin <mgra...@querifylabs.com> wrote: > Can you show the query? I don't see this one. > > On Thu, Dec 16, 2021 at 10:12 PM Arash Bizhan zadeh <aras...@gmail.com> > wrote: > > > Hi, > > I am trying to create a parser to parse big query statements like this - > > this is kotlin btw: > > > > val sqlParserConfig = BigQuerySqlDialect( > > > > > BigQuerySqlDialect.DEFAULT_CONTEXT.withDatabaseProduct(SqlDialect.DatabaseProduct.BIG_QUERY)).configureParser(SqlParser.config() > > .withParserFactory(SqlBabelParserImpl.FACTORY) > > > > .withConformance(SqlConformanceEnum.BIG_QUERY)) > > val parser = SqlParser.create(str, sqlParserConfig) > > > > but the resulting parser seems not to understand BQ specific things like > > the `IF` function. > > > > How can I properly construct a SqlParser? > > >