Not Getting data from Index pattern using SQL

@Andrei_Stefan,
I have actually not added any leading dots on my field names, it was automatically done somehow when pushing data. I am also using the latest version.

If you see the below picture, there is a highlighted red dot in the appcode field in the JSON tab

However, in the table tab there is still no do in the app code field

And when I try to query through the field this is the error I get
"Unknown column [app_code], did you mean [app_code]"

This is the how I created the fields in the DevTools