== [broken_pivot.sql] FAIL                                                                                                              
L:   7 | P:   1 |  PRS | Line 7, Position 1: Found unparsable section:                                                                  
                       | 'pivot\n(\n    count(state_code) as states\n...'
WARNING: Parsing errors found and dialect is set to 'oracle'. Have you configured your dialect correctly? 

-- broken_pivot.sql
select * from (
    select
        times_purchased,
        state_code
    from customers
)
pivot
(
    count(state_code) as states
    for state_code in ('NY' as new_york, 'CT', 'NJ', 'FL', 'MO')
);

-- working_pivot.sql
select * from (
    select
        times_purchased,
        state_code
    from customers
)
pivot
(
    count(state_code)
    for state_code in ('NY' as new_york, 'CT', 'NJ', 'FL', 'MO')
);

[sqlfluff]
dialect = oracle