[web2py] packaging return from executesql as Rows object?

[David Watson]

Does anybody have example code showing how to package the return from
executesql as a gluon.sql.Rows object?

I have tried:

    raw_rows = legacy_db.executesql(sqlstr, as_dict=True)
    from gluon import sql
    columns = ['col1', 'col2', 'col3']
    rowsobj = sql.Rows(legacy_db, raw_rows, columns)
    table = SQLTABLE(rowsobj)

but this blows up in sql.Rows. I'm just looking for a quick and dirty
(throw-away) way to do some reports with existing complex SQL queries.

Thanks,
Dave