You can even control fetching of linked data, eg:
# Get rows from the "users" table, following the linked "group"
# column but only caching the "name" column of the linked rows.
rows = app_tables.users.search(q.fetch_only("email",group=q.fetch_only("name")))