build a nested structure from a sql query

Question

I have a table in sqlite that I am accessing in my Adobe Air project. The table structure is as follows:

id, chapter_num, verse_num, translation_id, translation_txt;

I want to write a query that returns me one row per chapter_num and verse_num with a nested structure of translation ids and translation_txt under it. For example, I want a structure like this:

 chapter_num1, verse_num1
--[translation_id1, some_text1]
--[translation_id2, some_text2]

chapter_num1, verse_num2
--[translation_id1, some_text1]
--[translation_id2, some_text2]

I know i have done this before with NHibernate but in adobe Air how would I return an object structure like this?