Android Question Recorddata mapping with SQL

Why do we need to define recorddata in code when SQL query can anyways return not just the data but field type.
There seems to be so much of duplication of efforts like

1. defining data in sql ,
2. creating a query with all those fields
3. then in class_global as type,
4. then map resultset to record data using getstring

why can we not have a simple recordset which is formed using the sql query itself?

its easy for 4-5 fields in examples but gets very complicated with larger database. One I am working on has 116 fields. ?