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 ...
I've run into a couple of parser errors using DuckDB's SQL Standard PIVOT syntax (i.e. the non-simplified version). The example statements below are taken from DuckDB's own examples for the standard ...