Safe SQL query design
Design a parameterized SQL query for the requirement and schema below. State the target dialect, assumptions, indexes that affect the plan, transaction boundaries, and expected result shape. Flag injection, locking, null, timezone, and pagination risks. Do not invent columns that are not in the schema.