Beyond basic queries: joins, computed fields, conditional projections, and performance optimization tricks I've learned.