[web2py] question about view, rows query and table generate with sqltable

[Richard]

Hello,

I would like to better understand what web2py exactly do...

Say I have this controller function :

def func():
    rows = db().select(db.test1.ALL)
    table = SQLTABLE(rows)
    return dict(table=table)

I would like to know when exactly the query contained into rows will
be effectively executed? Is it executed once when I affect rows or do
SQLTABLE(rows) is call rows that call db().select(db.test1.ALL)...

For sure table contain a HTML table so the view just receive a plain
html table and don't execute rows again...

Thanks.

Richard