Tests and demonstrates selective column queries, locking and
flushing details as well as derived columns and joins. Note
that care is taken to trap attempts to access unqueried fields
and so prevent errors that could otherwise be the source of
nasty bugs as the application scales.