I have the following rawQuery

```
final maps = await db.rawQuery("""
select r.id, r.name, r.description,r.created_by,
a.id,a.name,a.description from Resources r 
left join Resource_Attribute ra on ra.resource_id = r.id
left join AttributeItems a on ra.attribute_id=a.id
""");

```

My question is how do I retrieve the data from all the columns in my query? Doing the following

```
 maps.forEach((dbItem){
     String resourceId = dbItem["r.id"];

```

doesn't seem to work. **dbItems** is a map but contains only the four columns in the **Resources** table. dbItem["r.id"] returns a null. 

dbItems does contain a "row" field which is an array with all the field. Is there way to access that?