Sergey Suvorov

SqlRender currently does not process correctly numbers less or equal to number of arguments in select statement. `max(case when ingredient_start_date=ingredient_start_date_new then 10 else 0 end)` will be translated correctly Or...

No, it's bug in SqlRender. There're several iterations during translation. 1 iter - SqlRender searches for column names from group by clause in select clause and substitutes their position in...

BigQuery uses its own translation mechanism due to differences of their dialects

@ schumie it seems to be already fixed could you check it?

@fdefalco Yes, it was to slow on BigQuery I've added link to original issue to description

it adds date range (lines 10-15) to prevent scanning the whole table and removes extracting years and months while selecting values from observation_period