powerquery-parser
powerquery-parser copied to clipboard
When using a custom Query in any source, Parser does not parse SQL statement. [Enhancement]
Custom Query example: with data as (#(lf)select *#(lf)exclude (total_aum_1, total_aum_2)#(lf), total_aum_1 * 1000000 as total_aum_1#(lf), total_aum_2 * 1000000 as total_aum_2#(lf)from db.funds.evestment_equity#(lf) )#(lf) select *,#(lf) CASE WHEN as_of_date = (SELECT MAX(as_of_date) from data) #(lf) THEN 'Latest Date'#(lf) ELSE TO_CHAR(as_of_date::DATE)#(lf) END LATEST_DATE#(lf) from data
Ideally, this should also had been parsed with db, table and attributes names. Any input is appreciated.