MapMint cannot read PostgreSQL table with uppercase and special character in column name

[niroshansb]

My table uses special characters and upper case for column names, and I unable to create sql view with the following command;

CREATE VIEW odk_prod.newlayer AS (SELECT "_URI", "LOCATION_LNG", "LOCATION_LAT", ST_SetSRID(ST_MakePoint("LOCATION_LNG", "LOCATION_LAT"),4326) FROM odk_prod."BIMARI_CORE");

Is there a way to directly create a view as shown above ?

Right now I need to rename the column name to lower case as below

CREATE VIEW public.odk_niroshan_newlayer AS (SELECT "_URI" as uri, "LOCATION_LNG" as long, "LOCATION_LAT" as lat, ST_SetSRID(ST_MakePoint("LOCATION_LNG", "LOCATION_LAT"),4326) as wkb_geometry FROM public.bimari);