I am trying to execute the below code in the Hana 2.0 SPS 03 environment.
TEMP_DATA is the context name and Entity is the entity name. I don't have namespace in my project.
Straight forward but when I run this, I get an error "500 invalid column name: ID" but when I change the query to add a double quotes to the id column(as shown below) my query executes.
var query = 'select "id" as "Identifier" FROM TEMP_DATA.Entity';
But this would be a problem to me since I have made my context and entity names to match my 1.0 names, so the code in 1.0 works in 2.0. If I have to add quotes for the columns in the select clause, I have to manually do it for all the queries in all the files which would time consuming. So is there a way to make all the queries in 1.0 artifacts to work in 2.0 with just the table name change?
P.S. I found the same issue in procedures and functions too