{{extend 'layout.html'}} {{if request.function=='index':}}
The "query" is a condition like "db.table1.field1=='value'". Something like "db.table1.field1==db.table2.field2" results in a SQL JOIN.
Use (...)&(...) for AND, (...)|(...) for OR, and ~(...) for NOT to build more complex queries.
"update" is an optional expression like "field1='newvalue'". You cannot update or delete the results of a JOIN