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 ...