-- Description: Summary GL report including one line per account segment level, including product code, with opening balance, total transaction amount per month for each period selected, and closing ...

The parsing of the PIVOT statement is compromised when we are doing JOIN before it. I should be able to parse this query: sql_request = """ SELECT consumer.id, event_date FROM consumer LEFT JOIN ...