powerquery-parser icon indicating copy to clipboard operation
powerquery-parser copied to clipboard

When using a custom Query in any source, Parser does not parse SQL statement. [Enhancement]

Open talhagithub02 opened this issue 2 months ago • 0 comments

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.

talhagithub02 avatar Apr 28 '24 08:04 talhagithub02