There is an overload to instantRows which takes a var seq[DbColumn] as in
iterator instantRows*(db: DbConn; columns: var DbColumns; query: SqlQuery;
args: varargs[string, `$`]): InstantRow =
Run
So you should be able to do something like:
var cols : DbColumns = @[]
for x in db.instantRows(cols, query):
for idx, col in cols:
echo col.name
Run
