Welcome on the OpenDataKit forum @Owura_Effah_Ampem. Don't hesitate to take some time to introduce yourself here : Introduce yourself here!
What you describe is not a bug. All column names are created in uppercase. So you have to use double quote to query your data.