let
Source = Sql.Database(".", "SimpleMovies", [Query="SELECT [dbo].[Persons].* #(tab)#(tab)FROM [dbo].[Persons]"]),
#"Renamed Columns" = Table.RenameColumns(Source, {{"Id", "Id"}, {"Height", "Height"}, {"BirthDate", "BirthDate"}, {"Nationality", "Nationality"}}),
#"Changed Type" = Table.RenameColumns(#"Renamed Columns", {{"Id", Int64.Type}, {"FullName", type text}, {"BirthLocation", type text}, {"Country", type text}, {"ImageUrl)
in
Expected behavior
An incorrect PQ should highlight diagnostics
Actual behavior
Diagnostics not highlighted as expected even for incorrect PQ which results in no formatting and incorrect suggestions creating unlikely user experience along with hampered API results for AutoComplete and Code Formatting
To Reproduce
Additional context
Upon further investigation, the API internally seems to identify that there is a Lex Error but does not handle it in the 'validate' API.